PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/key-cache-block-size.html
But setting the size of key nodes equal to the size of the I/O buffer does not always ensure the best overall performance. It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable.
https://dev.mysql.com/doc/refman/5.7/en/key-cache-restructuring.html
For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's ...If the cache contains any dirty blocks, the server saves them to disk before destroying and re-creating the ...
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those blocks that declare a variable with the same name. Because local variables are in scope only during stored ...
https://dev.mysql.com/doc/refman/5.7/en/optimization-indexes.html
The best way to improve the performance of SELECT operations is to create indexes on one or more of the columns that are tested in the query. The index entries act like pointers to the table rows, allowing the query to quickly determine which rows ...Indexes also add to the cost of inserts, updates, and deletes because each index must be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-options.html
Consumer names in the setup_consumers table use underscores, but for consumers set at startup, dashes and underscores within the name are equivalent. Performance Schema parameters can be specified at server startup on the command line or in option ...The name may be given as a pattern to configure instruments that match the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-consumers-table.html
For detailed information about the effect of enabling different consumers, see Section 25.4.7, “Pre-Filtering by Consumer”. If you disable a consumer, the server does not spend time adding event information to it.
https://dev.mysql.com/doc/refman/5.7/en/select-benchmarking.html
For example: mysql> SELECT BENCHMARK(1000000,1+1); +------------------------+ | BENCHMARK(1000000,1+1) | +------------------------+ | 0 | +------------------------+ 1 row in set (0.32 sec) This result was obtained on a Pentium II 400MHz system. To ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
For more information, see Section 4.5.4, “mysqldump — A Database Backup Program”. For InnoDB, all tables in all databases are stored in the system tablespace files, unless you have the innodb_file_per_table option enabled. The following files ... If the database on the source contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
The INNODB_SYS_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for MyISAM Tables CHECK TABLE Output CHECK TABLE returns a result set with the columns shown in the ...The ...