PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqladmin.html
Thus, the next time you invoke mysqladmin (or any other client program) using the same account, you must specify the new password. Slow queries The number of queries that have taken more than long_query_time seconds. --connect-timeout=value ...You ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long time. --extended, -e Command-Line Format --extended If you are using this option to check tables, it ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
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 sequence of OPTIMIZE TABLE statements until the search index is fully updated.
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam-bulk-data-loading.html
For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if there are no deleted rows in middle of the data file. Locking also lowers the total time for multiple-connection tests, although ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
The first time you sort a large table this way, it may take a long time. MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-hash.html
You should also keep in mind that this expression is evaluated each time a row is inserted or updated (or possibly deleted); this means that very complex expressions may give rise to performance issues, particularly when performing operations (such ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-attribute-tables.html
Connection attributes are key-value pairs that application programs can pass to the server at connect time. FEDERATED storage engine connections: program_name: mysqld _client_role: federated_storage Connection Attribute Limits There are limits on ...For applications based on the C API implemented by the libmysqlclient client library, the mysql_options() and mysql_options4() functions define the connection attribute ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-metadata-locks-table.html
Lock requests that have timed out and are waiting for the requesting session's lock request to be discarded. When a pending lock request times out (ER_LOCK_WAIT_TIMEOUT), its row status is updated from PENDING to TIMEOUT. The VICTIM, TIMEOUT, and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_hosts_lost The number of times a row could ...Performance_schema_digest_lost The number of digest instances that could not be instrumented in the events_statements_summary_by_digest ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-stats-table.html
PRIO_KICKUPS The number of statements that have been moved from low-priority queue to high-priority queue based on the value of the thread_pool_prio_kickup_timer system variable. BECOME_CONSUMER_THREAD The number of times thread have been assigned ... Note The Performance Schema table described here is available as of MySQL ...