PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to crashes, hardware issues, or power outages, only use these tables as temporary work areas ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
The stage event shown differs depending on which ALTER TABLE phase is currently in progress. You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
To view available InnoDB mutex wait instruments, query the Performance Schema setup_instruments table, as shown below. Because waits are timed in picoseconds (trillionths of a second) by default, wait times are divided by 1000000000 to show wait ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-mysql-memory-use.html
The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. Memory instruments have ...
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
When MRR is used, the Extra column in EXPLAIN output shows Using MRR. Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's ...
https://dev.mysql.com/doc/refman/5.7/en/multibyte-characters.html
The existing character sets provide the best documentation and examples to show how these functions are implemented. If you want to add support for a new character set named MYSET that includes multibyte characters, you must use multibyte character ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-key-caches.html
Any attempt to do this is ignored: mysql> SET GLOBAL key_buffer_size = 0; mysql> SHOW VARIABLES LIKE 'key_buffer_size'; +-----------------+---------+ | Variable_name | Value | +-----------------+---------+ | key_buffer_size | 8384512 | ... Shared ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html
To see the values used by a given instance, connect to it and execute a SHOW VARIABLES statement. In some cases, you might want to run multiple instances of MySQL on a single machine. You might want to test a new MySQL release while leaving an ...
https://dev.mysql.com/doc/refman/5.7/en/my-print-defaults.html
--show, -s As of MySQL 5.7.8, my_print_defaults masks passwords by default. my_print_defaults displays the options that are present in option groups of option files. The output indicates what options are used by programs that read the specified ...