NAV: SLTechnology News&Howtos > Database >

• 

  MySQL Index performance Test

  MySQL Index performance Test blog document structure Diagram: I haven't studied MySQL for a long time, and I've been working on oracle. If I'm free recently, pick up MySQL and have a look. I remember two MySQL articles published last year: MySQL 5.6.21.

  2022-06-01 06:43:07 Views: 244
• 

  ADDM report

  As soon as each snapshot is generated, the addm-related background process starts automatically. After starting, an addm report is generated. Generally, when there is no problem, there is nothing in the automatically generated addm report. If the value after ADDM Findings is greater than 0, there is nothing in the em.

  2022-06-01 06:43:06 Views: 224
• 

  Basic configuration of hbase and hive

  Hadoop configuration was introduced in the previous blog, where hbase and hivemaster nodes are configured directly: lab201,slave node: lab201,lab202,lab203 all perform the following operations (the following is a master node

  2022-06-01 06:43:03 Views: 215
• 

  Mytop installation, using mytop to monitor MySQL performance

  This article mainly describes the installation of mytop, the possible errors during installation, and the use of mytop to monitor MySQL performance. Welcome to reprint, please indicate the author and source. Author: Zhang Zheng blog: http://space.itpub.net/26355

  2022-06-01 06:43:03 Views: 288
• 

  PostgreSQL DBA (148C)-pgAdmin (Showscript for psql command)

  This section briefly describes how to display the SQL built into the psql command. When we use psql, we can use commands such as\ d,\ df,\ df,\ sf to query the relevant information. What is the SQL behind these commands? You can set ECHO_HIDDEN o

  2022-06-01 06:42:59 Views: 215
• 

  Duplicate DB experiment on the same host (including GI)

  Explanatory text: oracle version 11g operating system: oracle linux 5Main DB (target DB)-> connection-> Duplicate DB---- creates Duplic according to the main library

  2022-06-01 06:42:59 Views: 219
• 

  Oracle 11g R2 + RAC+ ASM+ OracleLinux6.4 installation details (1) preliminary preparation

  1. Version description: software version: oracle 11.2.0.4 RAC system version: Redhat 6.4.This time the RAC environment of Oracle 11g R2 11.2.0.4 is built, and the operating system version is Oracle L.

  2022-06-01 06:42:51 Views: 273
• 

  Summary of key points and optimization items at all levels in the process of Oracle RAC construction

  Original title: what must be known and done in the process of Oracle RAC construction author: Zhao Hai, a city commercial bank system architect, specializes in banking data center solution planning and design. There is a lack of practical standards that can be followed in the process of database construction, and it is difficult for knowledge points and experience points to be scattered everywhere.

  2022-06-01 06:42:47 Views: 260
• 

  Microclass sql Optimization (2)-Why do you need to collect statistics

  1. Why do you need to collect statistics Cost-based optimizer (CBO), Based on object statistics, optimizer statistics to describe the details of objects in the database, and query optimizer to use these systems

  2022-06-01 06:42:46 Views: 286
• 

  Oracle 11g rac OCR disk group renaming (correction scheme after OCR disk group naming error during creation)

  Refer to Rename Diskgroup having OCR, Vote File, ASM SPILE (documentation ID 1335975.1) Target: Consider a 11.2 Grid Infra

  2022-06-01 06:42:46 Views: 298
• 

  Do not know how to read the official oracle documents? Look here!

  Original address: http://www.cnblogs.com/moveofgod/p/3731680.htmlConcept contains some basic concepts and principles in oracle database, such as database logical structure, objects.

  2022-06-01 06:42:46 Views: 258
• 

  SQL Server uses the xp_cmdshell prompt "not an internal or external command, nor a runnable program or batch file"

  After data migration, use SQL Server 2012 to back up the database, and automatically compress the database into rar files after the backup is completed. Statements that have no problems before can only be used for backup, but cannot automatically compress and delete backups, indicating that there is a problem with compression after backup. Put the statement

  2022-06-01 06:42:41 Views: 269
• 

  12C New feature in Oracle-Container Database concept-basic Operation

  12C new feature in Oracle-Container Database-12.1.0.2GIXRACKING CreateCDB _ blog in March, Jackie told me that I had time to deploy Oracle 12C-container database, refer to the company's migration documentation, and do

  2022-06-01 06:42:38 Views: 214
• 

  Introduction of MySQL 5.5FLUSH TABLES WITH READ LOCK statement

  The FLUSH TABLES WITH READ LOCK statement closes all open tables and adds a global read-only lock to all database tables. This is very convenient for backup. If you have a file system like Veritas or ZFS, you can prepare

  2022-06-01 06:42:38 Views: 301
• 

  12c how does rac delete the flashback log to free up space

  Small experiment, turn on flashback and turn off flashback. The 12c RAC flashback environment actually starts the rvwr process in the background, then automatically creates a flashback directory and writes the flashback log. When we temporarily want to clean the flashback log, all we have to do is turn off the flashback.

  2022-06-01 06:42:38 Views: 230
• 

  Xtrabackup automatic full backup script

  Xtrabackup automatic full backup script, with sending mail and master-slave judgment function. # # set environment##. ~ / .bash_profileBASEDIR= "/ data_bak" SPACE_RATE=95

  2022-06-01 06:42:37 Views: 224
• 

  Pure practical information! The sooner you shut down the three Apple & quot; & quot; giants, you don't have to change one battery a year.

  Users who have used Apple, the small battery capacity is a hidden danger of battery life, the phone did not use for a while, the battery rubbed down, do not know who thought the electricity was stolen. Really can not survive, can only go to the mobile phone store to replace the battery, in fact, many times mobile phone power consumption is fast, but also related to these big power consumers, it is recommended to close as soon as possible

  2022-06-01 06:42:33 Views: 282
• 

  Evolution and analysis of RDS storage capacity of cloud database!

  Database is the core of enterprise IT system, and its performance will directly affect the performance of the overall business system. The factors that affect database performance include system architecture design, application business SQL statements, optimal configuration of database parameters, and resource capabilities of database operation. System architecture design and application industry

  2022-06-01 06:42:26 Views: 256
• 

  Explanation of mysql's implementation plan

  With regard to the execution plan of MySQL, take a note, which can be used as a basis for optimization. Try to optimize the fourth column type to ref, at least to ensure that range mode can be used to overwrite the index, and then possible_keys shows that null does not mean that you do not want to

  2022-06-01 06:42:13 Views: 282
• 

  The esql compilation parameter of informix avoids the problem of SQL interrupt caused by / / comments

  In EXEC SQL, if the "/ /" symbol appears in the SQL statement, it causes the SQL statement from the end of ";" to be ignored, not just the current line. This often comes as a surprise to programmers. For example, the following example program t1.ec. Int main () {

  2022-06-01 06:42:13 Views: 210