Search Results
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
logging slow query The thread is writing a statement to the slow-query log. The following list describes thread State values that are associated with general query processing and not more specialized activities such as replication. Many of these ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-logging-category.html
Log Output This option determines the destination for general query log and slow query log output. Log Timestamps This variable controls the timestamp time zone of error log messages, and of general query log and slow query log messages written to ... Lists the Logging configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
During this time, disk I/O is increased, which can cause a significant slowdown for disk-bound queries. Periodically, the purge operation that runs when the system is mostly idle, or during a slow shutdown, writes the updated index pages to disk.
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
mysqldumpslow A utility to read and summarize the contents of a slow query log. Oracle Corporation also provides the MySQL Workbench GUI tool, which is used to administer MySQL servers and databases, to create, execute, and evaluate queries, and to ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
For example, if you need to fit many backups on a particular storage device, you might use compressed backups, even if that made the backup process slower. You might choose a set of options resulting in a slightly slower backup, if those options ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O optimizations. Increase buffer pool size When table data is cached in ...If the Unix top tool or the Windows Task Manager shows that the CPU usage percentage with your workload is less than 70%, your workload is probably ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-timing.html
Processor cycle rate might change, such as when a laptop goes into power-saving mode or when a CPU slows down to reduce heat generation. Some processor details related to out-of-order execution or multiprocessor synchronization might cause the ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-tablecaching.html
Table caching is a feature that can be used to cache slow-changing datasets on the client side. This is useful for applications that are designed to use readers, but still want to minimize trips to the server for slow-changing tables. This feature ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tablecaching.html
Table caching is a feature that can be used to cache slow-changing datasets on the client side. This is useful for applications that are designed to use readers, but still want to minimize trips to the server for slow-changing tables. This feature ...
https://dev.mysql.com/doc/mysqld-version-reference/en/optvar-changes-5-7.html
The following list details the changes to specific options and variables within MySQL 5.7.