PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-state-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA table instead; see Section 28.5.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-stats-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA table instead; see Section 28.5.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”. The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. If your database is stored in binary portable files, you can copy the raw ...
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
Another way to serialize transactions is to create an auxiliary “semaphore” table that contains just a single row. When modifying multiple tables within a transaction, or different sets of rows in the same table, do those operations in a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-txn.html
This option is less appropriate when accessing the same tables through both memcached and SQL, because it blocks CREATE INDEX statements on the tables, which could be important for running reporting queries. Although the default behavior does not ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
The latter corresponds to the type of value displayed by SHOW CREATE USER for password hashes containing unprintable characters when the print_identified_with_as_hex system variable is enabled. In most cases, ALTER USER requires the global CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/cache-index.html
A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE INDEX t1 IN non_existent_cache; ERROR 1284 (HY000): Unknown key cache 'non_existent_cache' By default, table indexes are assigned to the main (default) key ...| ...| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
Miscellaneous Information The xxx_general_mysql500_ci collations preserve the pre-5.1.24 ordering of the original xxx_general_ci collations and permit upgrades for tables created before MySQL 5.1.24 (Bug #27877). Beginning with MySQL 8.0.28, utf8mb3 ... This section describes the collations available for Unicode character sets and their differentiating ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
myisam_max_sort_file_size The maximum size of the temporary file that MySQL is permitted to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA). If the server finds an error, it tries to do a fast table repair (with ... The following options to mysqld can be used to change the behavior of MyISAM ...