PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
Incompatible change: The INFORMATION_SCHEMA has tables that contain system and status variable information (see Section 24.3.11, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”, and Section 24.3.10, “The ... Before ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-thread-states.html
Processing events from schema table The thread is doing the work of schema replication. Shutting down Syncing ndb table schema operation and binlog This is used to have a correct binary log of schema operations for NDB. Waiting for allowed to take ... Committing events to binlog Opening mysql.ndb_apply_status Processing events The thread is processing events for binary ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
mysqlslap runs in three stages: Create schema, table, and optionally any stored programs or data to use for the test. --create-schema=value Command-Line Format --create-schema=value Type String The schema in which to run the tests. Note If the ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html
Note When changing the total number of LCP threads or LQH threads per node group, you should recreate the schema from backup created using mysqldump. $> mysqldump --no-data --routines --events --triggers --databases > myschema.sql Important Once you ... It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the backup was ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
Note As of MySQL 5.7.39, an alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist table, which, like the threads table, does not require a mutex and has better performance characteristics. You can ... The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of process list ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
innodb_cmp_per_index_enabled Command-Line Format --innodb-cmp-per-index-enabled[={OFF|ON}] System Variable innodb_cmp_per_index_enabled Scope Global Dynamic Yes Type Boolean Default Value OFF Enables per-index compression-related statistics in the ... System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE INNODB STATUS displays extensive information from the standard InnoDB Monitor about the state of the InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
Aborting a Buffer Pool Load Operation To abort a buffer pool load operation, issue the following statement: SET GLOBAL innodb_buffer_pool_load_abort=ON; Monitoring Buffer Pool Load Progress Using Performance Schema You can monitor buffer pool load ... To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
To identify orphan intermediate tables on your system, you can query the Information Schema INNODB_SYS_TABLES table. SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%#sql%'; To remove an orphan intermediate table, perform the ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
--skip-mysql-schema Command-Line Format --skip-mysql-schema Introduced 5.7.36 Type Boolean Do not drop the mysql schema when the dump file is restored. This option may be used to dump the INFORMATION_SCHEMA and performance_schema databases, which ...