Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-diagnostics.html
Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-analysis.html
The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. full_scan The total number of full table scans performed by ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
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 for tables that are queried often and rarely inserted into or updated. Splitting table contents into ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace.html
Tracing telemetry enables you to visualize the flow of any processing action as it is processed through your server. The data for each action, a span, includes possible error information and timing data. Traces are generated for COM_QUERY commands ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-table-problems.html
Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You ...
https://dev.mysql.com/doc/refman/8.4/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...
https://dev.mysql.com/doc/refman/8.4/en/thread-commands.html
Query Employed for user clients while executing queries by single-threaded replication applier threads, as well as by the replication coordinator thread. A thread can have any of the following Command values: Binlog Dump This is a thread on a ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-information-schema-tables.html
Note The INFORMATION_SCHEMA thread pool tables are deprecated, and subject to removal in a future version of MySQL. You should use the versions available as Performance Schema tables instead. Applications should transition away from the old tables ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the results. mysql may also be used in batch mode: you place your ...