Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL Statistics     - Yii2 Advanced Version Copy New Project Problem Solved (Programming)

- The difference between statement and preparedStatement of the jdbc (Database)

- SQLite3 simple operation (Database)

- Linux landing problem (Linux)

- To configure parameter configuration and software installation and uninstallation under Linux (Linux)

- Hands to teach you to solve Ubuntu error message (Linux)

- To use Linux to create a secure managed gateway (Linux)

- Java thread lifecycle (Programming)

- Linux add a new hard disk (Linux)

- Linux System Getting Started Tutorial: Installing Brother printer in Linux (Linux)

- Java heap (Heap) and stack difference (Programming)

- How to install Eclipse Luna IDE on CentOS 7 / RHEL 7 (Linux)

- Examples of testing and installation Mesos on CentOS (Linux)

- CentOS 6.x Basic System Optimization after installation (Linux)

- Create the container and run the application Docker (Server)

- The Rabbitmq installation under CentOS 6.4 (Linux)

- By way of a binary installation innobackupex (Database)

- A brief introduction to some important Docker commands (Server)

- Android development environment to build under Fedora 13 (Linux)

- In-depth understanding of PHP ini configuration (Server)

 
         
  MySQL Statistics
     
  Add Date : 2018-11-21      
         
         
         
  I believe the importance of statistical data to understand the Oracle database is very clear that he is the only standard execution plan, so the accuracy of statistical data directly affect the correctness of the implementation of the plan, although there is no statistical data on MYSQL ORACLE so multi-dimensional (eg histogram) but is still there, MYSQL 5.6 and divided into two kinds of statistics.

1, perpetuating statistics
 After the default 5.6.6 When using this mode, the parameters affect his
The number of blocks innodb_stats_persistent_sample_pages each sample, the default is 20
 Are innodb_stats_auto_recalc open automatically collected, the default is to modify the amount exceeds 10% of the data
innodb_stats_persistent default is ON, whether perpetuate statistics


 Perpetuate statistical data stored in innodb_index_stats and innodb_table_stats, the official statistics say that the document is not in real time, that is, the collection of statistical data lag a few minutes, if you want to timely update statistics

Data need to manually perform ANALYZE TABLE (In some cases, statistics
 recalculation may be delayed by a few seconds. If up-to-date statistics are
 required immediately after changing significant portions of a table, run ANALYZE
 TABLEto initiate a synchronous (foreground) recalculation of statistics)

If the statistics are not allowed to modify the values innodb_stats_persistent_sample_pages may need a larger, if analyze table too slow can consider reducing the value innodb_stats_persistent_sample_pages smaller. Both table INNODB table


2, non-perpetuating statistics
 If set to OFF innodb_stats_persistent on the use of statistical data in this way, this way statistical data in the database is lost after the restart, his statistical data in STATISTICS, TABLES two tables, they are the engines MEMORY table, this way affected parameters
innodb_stats_persistent set to OFF
 innodb_stats_transient_sample_pages default is 8, the number of sample blocks
innodb_stats_on_metadata English description To have statistics updated when metadata statements such as SHOW TABLE STATUS

                          or SHOW INDEX are run, or when accessing the INFORMATION_SCHEMA.TABLES or
                          INFORMATION_SCHEMA.STATISTICSt ables, execute the statement SET GLOBAL
                          innodb_stats_on_metadata = ON


When innodb_stats_persistent set to ON, the default is OFF innodb_stats_on_metadata, because it will affect the speed of SHOW TABLE STATUS, etc.

Finally, let us briefly describe the policy ORCALE statistical data collection, ORACLE 10G, 11G through automated job to collect default 11G Week 1 to Week 5 22:00 to start collecting statistical data, the weekend is 6 am of course this is not all collect statistical data collection, ORACLE will modify the number of more than 10% recorded mon_mods_all $ tABLES internal table, and then collect these tables, so to ensure as much as possible of the statistics describe the distribution of data while ORACLE will use the predicate to determine whether the histogram collected predicate usage records in COL_USAGE $ interior view, the histogram data for determining the inclination, MYSQL in this regard depends on yet.
     
         
         
         
  More:      
 
- Impact test noatime Linux file access time (Linux)
- CentOS7 compile and install Tengine + PHP + MariaDB notes (Server)
- Elaborate .NET Multithreading: Concepts (Programming)
- Web cache basics: terminology, HTTP headers, and caching policies (Server)
- AppCode developed Mac OS X application or shared library experience summary (Programming)
- Ubuntu 14.04 to install Blender 2.71 (Linux)
- Help you enhance Python programming languages 27 (Programming)
- Linux / UNIX: Use the dd command to create a 1GB size binary (Linux)
- Reported too many open files Linux solutions (Server)
- Rman Oracle database backup and recovery plan (Database)
- C ++ handling text input (Programming)
- Linux command binlog by filtering out the complete SQL statement (Database)
- Linux memory management -free learning experience (Linux)
- Ubuntu 14.04 Configuring cuda-convnet (Linux)
- A simple shell script for monitoring in Linux (Linux)
- Oracle11g build physical standby database (Database)
- STL in the list of erase () method (Programming)
- Java recognize simple codes (Programming)
- To use Java arrays implement the order form (Programming)
- The formatted Linux hard drive and mount (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.