PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_stages_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when ... The events_stages_history table contains the N most recent stage events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_statements_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded ... The events_statements_history table contains the N most recent statement events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_transactions_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded ... The events_transactions_history table contains the N most recent transaction events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_waits_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when a ... The events_waits_history table contains the N most recent wait events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. In this ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
InnoDB performs row-level locking in such a way that when it searches or scans a table index, it sets shared or exclusive locks on the index records it encounters. The so-called phantom problem occurs within a transaction when the same query ...Let ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-read_ahead.html
For example, if you set the value to 48, InnoDB triggers a linear read-ahead request only when 48 pages in the current extent have been accessed sequentially. Statistics include counter information for the following global status variables: ... A ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-timezone.html
Verify that your combination of settings for the system time zone (system_time_zone), server current time zone (the global value of time_zone), and per-session time zones (the session value of time_zone) on the source and replica is producing the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-security.html
For security reasons, audit log files should be written to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log. By default, contents of audit log files produced by the audit log plugin are not ...
https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html
By granting the privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of ...The extra connection is reserved for use by accounts that have the SUPER ... If clients encounter Too many connections errors when attempting to ...