PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
Otherwise, MySQL locks the table during the time OPTIMIZE TABLE is running. To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a ...
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/prepare.html
Beginning with MySQL 8.0.22, a parameter used in a prepared statement has its type determined when the statement is first prepared, and retains this type whenever EXECUTE is invoked for this prepared statement (unless the statement is reprepared, as ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/8.0/en/processlist-access.html
Note As of MySQL 8.0.22, an alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist table, which, like the threads table, does not require a mutex and has better performance characteristics. Time ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-thread_concurrency.html
In situations where it is helpful to minimize context switching between threads, InnoDB can use a number of techniques to limit the number of concurrently executing operating system threads (and thus the number of requests that are processed at any ... InnoDB uses operating system threads to process requests from user ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-summary-tables.html
Example error event summary information: mysql> SELECT * FROM performance_schema.events_errors_summary_global_by_error WHERE SUM_ERROR_RAISED <> 0\G *************************** 1. Each error summary table has these summary columns containing ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-timeout.html
The global value of the system variable replica_transaction_retries (from MySQL 8.0.26) or slave_transaction_retries (before MySQL 8.0.26) sets the maximum number of times for applier threads on a single-threaded or multithreaded replica to ...If a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
To start a replica using GTID-based replication, you need to enable the SOURCE_AUTO_POSITION | MASTER_AUTO_POSITION option in the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23). This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
For example: mysql> SELECT * FROM performance_schema.events_transactions_current LIMIT 1\G *************************** 1. The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, TIMER_END is ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/data-types.html
MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional ...