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/zlib-decompress.html
The zlib_decompress utility decompresses mysqlpump output that was created using ZLIB compression. Note zlib_decompress is deprecated as of MySQL 8.0.34; expect it to be removed in a future version of MySQL. This is because the associated mysqlpump ...In this case, the system openssl zlib command can be used ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-component-scheduler-tasks-table.html
For example, the audit_log server plugin utilizes the scheduler component to run a regular, recurring flush of its memory cache: mysql> select * from performance_schema.component_scheduler_tasks\G *************************** 1. Does a periodic ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema Runtime Configuration”. Transaction Boundaries In MySQL Server, transactions ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
With efficient use of the InnoDB buffer pool, MyISAM key cache, and the MySQL query cache, repeated queries run faster because the results are retrieved from memory the second and subsequent times. Tuning these statements is a top priority, whether ... Queries, in the form of SELECT statements, perform all the lookup operations in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
To improve the start up time of the mysql client and to updating statistics, you can turn off auto-rehash using the --disable-auto-rehash option. Starting a mysql client with the --auto-rehash option enabled, which is the default. InnoDB detects ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
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 data. (For unique indexes, this is always 1.) MySQL uses this ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-hash.html
This can simply be the name of a column whose type is one of MySQL's integer types. 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 ... 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/table-locking.html
MySQL uses table locking (instead of page, row, or column locking) for all storage engines except InnoDB. But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
thread_pool_prio_kickup_timer: How long before the thread pool moves a statement awaiting execution from the low-priority queue to the high-priority queue. Consider increasing the value if you experience slower response times due to long-running ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. Statistics are collected again the next time the table is accessed. This column is reset each time table statistics are recalculated AUTOINC The ... The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB ...