PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.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/8.0/en/mysql-nutshell.html
A CREATE TABLESPACE statement executed without an ADD DATAFILE clause implicitly creates a tablespace data file with a unique file name. MySQL 8.0.31 adds the read-only build_id system variable for Linux systems, where a 160-bit SHA1 signature is ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/en/performance-schema-tp-thread-group-state-table.html
That is, these two queries are equivalent: SELECT TP_GROUP_ID, MAX_THREAD_IDS_IN_GROUP FROM tp_thread_group_state; SELECT TP_GROUP_ID, MAX(TP_THREAD_NUMBER) FROM tp_thread_state GROUP BY TP_GROUP_ID; The tp_thread_group_state table has these ...
https://dev.mysql.com/doc/refman/8.0/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. Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL ...
https://dev.mysql.com/doc/refman/8.0/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 ...