PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-stages.html
By default, rows are sorted by host and descending total latency. The host_summary_by_stages and x$host_summary_by_stages views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-stages.html
By default, rows are sorted by user and descending total stage latency. The user_summary_by_stages and x$user_summary_by_stages views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema ...total The total number of occurrences of the stage event for the ...
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
This statement returns results only for databases and tables for which you have the TRIGGER privilege. The LIKE clause, if present, indicates which table names (not trigger names) to match and causes the statement to display triggers for those ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-nodes.html
For each data node that is running in the cluster, a corresponding row in this table provides the node's node ID, status, and uptime. Notes The uptime column shows the time in seconds that this node has been running since it was last started or ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-rwlock-instances-table.html
An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access to some common resource following certain rules. The access is either shared (many threads can have a read lock at the same time), ...
https://dev.mysql.com/doc/refman/8.0/en/concurrent-inserts.html
If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT statements. By default, the variable is set to AUTO (or 1) and concurrent inserts are handled as just described. Use of the CONCURRENT ...The results of a concurrent INSERT may not be visible ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-json.html
This section describes how to configure error logging using the built-in filter, log_filter_internal, and the JSON sink, log_sink_json, to take effect immediately and for subsequent server startups. It is permitted to name log_sink_json multiple ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-maintenance-schedule.html
If you are performing many updates to MyISAM tables with dynamic-sized rows (tables with VARCHAR, BLOB, or TEXT columns) or have tables with many deleted rows you may want to defragment/reclaim space from the tables from time to time. One way to ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-close.html
The counter works as follows: The first time a table is updated in MySQL, a counter in the header of the index files is incremented. (The table may still be okay because MySQL always issues writes for everything between each statement.) A table was ...When the last instance of a table is closed (because a FLUSH TABLES operation was performed or because there is no room in the table cache), the counter is decremented if the table has been updated at any ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...