PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-configurator-cli.html
server-id N/A serverid number N/A 1 configure N/A For servers that are used in a replication topology, you must specify a unique server ID for each replication server in the range from 1 to 2^32 - 1. "Unique" means that each ID must be different ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-configurator-workflow-server.html
The Advanced Options step enables you to set the unique server ID required when binary logging is enabled in a replication topology. The advanced-configuration options include: Server ID Set the unique identifier used in a replication topology.
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
This option is effective only for nonunique indexes of MyISAM tables. --order-by-primary Command-Line Format --order-by-primary Dump each table's rows sorted by its primary key, or by its first unique index, if such an index exists. The mysqldump ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-queries-myisam.html
(For unique indexes, this is always 1.) MySQL uses this to decide which index to choose when you join two tables based on a nonconstant expression. This is a good way to make queries faster if you have a unique index from which you want to read all ... Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-statements-current-table.html
The THREAD_ID and EVENT_ID values taken together uniquely identify the row. The value is unique for the server instance because these IDs are generated using a global counter that is incremented atomically. The table stores one row per thread ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-waits-current-table.html
The THREAD_ID and EVENT_ID values taken together uniquely identify the row. With single-row reporting, the total number of instrumented operations is: 10 + (10 * 20) + (10 * 20 * 30) = 6210 A significant reduction in the number of instrumented ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-threads-table.html
The threads table has these columns: THREAD_ID A unique thread identifier. For a background thread (not associated with a user connection), PROCESSLIST_ID is NULL, so the values are not unique. The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-group-state-table.html
The tp_thread_group_state table has one index; this is a unique index on the TP_GROUP_ID column. The tp_thread_group_state table has one row per thread group in the thread pool. Each row provides information about the current state of a group. The ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-group-stats-table.html
The tp_thread_group_stats table has these indexes: Unique index on (TP_GROUP_ID) TRUNCATE TABLE is not permitted for the tp_thread_group_stats table. The tp_thread_group_stats table has these columns: TP_GROUP_ID The thread group ID. This number is ...
https://dev.mysql.com/doc/refman/9.7/en/pluggable-storage-common-layer.html
From a technical perspective, what are some of the unique supporting infrastructure components that are in a storage engine? Some of the key feature differentiations include: Concurrency: Some applications have more granular lock requirements (such ... A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific application ...