NAV: SLTechnology News&Howtos > Database >

• 

  Summary of MySQL tools

  Contains useful tools related to MySQL. Tools include: performance testing, state analysis, SQL routing, etc. This article summarizes all the tools related to MySQL operation and maintenance development, and will continuously update the tool suite percona-toolkit oak-tool.

  2022-06-01 07:45:43 Views: 203
• 

  Full backup of ORACLE_ database + archived remote recovery

  Full backup: #! / bin/bashexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/app/oracle/product/11.2.0/d

  2022-06-01 07:45:33 Views: 269
• 

  Brief introduction of MySQL permission system

  1) method of granting and reclaiming permissions 1: the permissions of MySQL are mainly stored in several system tables called grant tables, namely: mysql.User,mysql.db,mysql.Host,mysql

  2022-06-01 07:45:33 Views: 203
• 

  Meituan Dianping's Real-time data Warehouse Construction practice based on Flink

  Introduction in recent years, enterprises have an increasing demand for real-time data services. This paper collates the performance characteristics and applicable scenarios of common real-time data components, and introduces how Meituan builds a real-time data warehouse through Flink engine, so as to provide efficient and robust real-time data services. Before that, we played the beauty team.

  2022-06-01 07:45:33 Views: 290
• 

  [Mysql] MySQL query plan key_len knows everything

  This paper first introduces the meaning of ken_len in MySQL's query plan, then introduces the calculation method of key_len, and finally uses a fake example to illustrate how to use key_len to see how many columns are used in the federated index. The meaning of key_len is in M

  2022-06-01 07:45:26 Views: 272
• 

  Maximum protection to maximum availability

  PS: this experiment builds on the state before the main library based on the previous DG blog, executes the transition statement, and the state after the main library is 15:00:01 SYS @ slow > select name,database_role,protection

  2022-06-01 07:45:26 Views: 219
• 

  DM backup job reported pipe connection failure error problem

  We often encounter this error when we regularly back up the database in the Dameng database job: [description] when the backup job chooses to back up the database based on the backup set, there is a high probability that you will encounter a backup job failure report pipeline connection failure error. How can we solve this kind of problem? There are two.

  2022-06-01 07:45:26 Views: 300
• 

  ORACLE RAC Cluster configuration Management tool-SRVCTL

  SRVCTL Overview SRVCTL is an ORACLE RAC cluster configuration management tool that manages Database, Instance, ASM, Service, Listener and Node Application,Node

  2022-06-01 07:45:25 Views: 299
• 

  11.2.0.4 RAC patch manually

  1. Download the patch and the latest OPatchGI PSU: p25869727_112040_Linux-x86-64.zipOPatch: p6880880_112000_Linux-x86-64.zip says

  2022-06-01 07:45:25 Views: 297
• 

  Sublime text 4 for Mac (front-end code editing artifact)

  Sublime text 4 mac is a code editing tool running on Mac, which integrates window grouping, project management, extension tools, code folding and other functions. It supports vim mode, window grouping, extension tools, code folding, etc., and sublime t

  2022-06-01 07:45:06 Views: 293
• 

  Understand the resource update mechanism of K8s, starting with an OpenKruise user question

  Background OpenKruise is Aliyun's open source large-scale application automation management engine, which is functionally aligned with Kubernetes's native Deployment / StatefulSet controllers, but OpenKruise mentions

  2022-06-01 07:45:05 Views: 301
• 

  Wechat moments can comment on memes! 1W memes are ready, netizens: advise you to be kind

  Good news! Good news! Good news! Bear is here to share a piece of good news with you! Wechat moments can comment on pictures. Recently, if you have a full screen of emojis in your moments, please don't be surprised! Because your friends can comment on the meme pictures under your moments, Xiong's 1W

  2022-06-01 07:44:53 Views: 218
• 

  Linux Advanced flow Control tc usage

  When doing MHA testing, an important step is to test the network conditions of MHA Manager nodes and Master nodes. If jitter occurs, MHA itself provides a parameter secondary_check to guarantee, but if your deployment

  2022-06-01 07:44:53 Views: 228
• 

  Shrink the table to eliminate empty blocks in the table

  When you shrink a table, Oracle reorganizes the blocks with minimal storage space. The Delete operation usually does not lower the high water mark. When doing a full table scan, oracle scans blocks below the high water mark. A table may not have much data, but it takes a long time to execute.

  2022-06-01 07:44:53 Views: 234
• 

  DBV (DBVERIFY) tool

  DBV (DBVERIFY) is a command line tool provided by Oracle, which can check both physical and logical consistency of data files. However, this tool does not check the matching of index records and data records, which must be checked using analyze validat

  2022-06-01 07:44:52 Views: 269
• 

  Error: install:% pre scriptlet failed (2), skipping cvuqdisk-1.0.9-1

  When installing 11g rac, one step is to install cvuqdisk-1.0.9-1.rpm, but the error is as follows: [root@oraclerac1 rpm] # rpm-ivh cvuqdisk-1.0.9-1.rp

  2022-06-01 07:44:52 Views: 227
• 

  OPatch/Patch Questions/Issues for Oracle Clusterware/ RAC Environments_1339140.1

  FAQ: OPatch/Patch Questions/Issues for Oracle Clusterware (Grid Infrastructure or CRS) and RAC Envir

  2022-06-01 07:44:47 Views: 263
• 

  [Mongo] MongoDB index management-creation, viewing and deletion of indexes

  Http://itbilu.com/database/mongo/E1tWQz4_e.html index is the most effective means to improve the efficiency of query. An index is a special data structure that stores parts of the data in a form that is easy to traverse, such as

  2022-06-01 07:44:46 Views: 247
• 

  Add a trigger

  DELIMITER | CREATE TRIGGER phpmyadmin.tri_hisInsert AFTER INSERTON pma__history FOR EACH ROWBEGININSE

  2022-06-01 07:44:46 Views: 222
• 

  [kingsql sharing] introduction of various new features of Oracle Database 19c

  In February 2019, Oracle launched 19c, how about it? when you watch a TV show or play a game, you don't know how many people are traveling day and night. In this era, the pace is fast, and therefore, the Oracle interface is still the same as before.

  2022-06-01 07:44:37 Views: 287