https://dev.mysql.com/sys-statement-performance-analyzer.html
in_views SET ('with_runtimes_in_95th_percentile', 'analysis', 'with_errors_or_warnings', 'with_full_table_scans', 'with_sorting', 'with_temp_tables', 'custom'): Which views to include. mysql> CALL sys.statement_performance_analyzer('delta', ...
https://dev.mysql.com/sys-sys-config.html
set_time The timestamp of the most recent modification to the row. (For example, the statements_with_runtimes_in_95th_percentile view has a built-in limit in the sense that it returns only statements with average execution time in the 95th ... This ...
https://dev.mysql.com/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/test-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. If you installed the plugin at runtime using an INSTALL PLUGIN statement, it remains installed across server restarts. MySQL includes a test plugin that checks ...
https://dev.mysql.com/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a master server for sending binary log contents to a slave server. Daemon This thread is internal to the server, not a thread that services a client connection.
https://dev.mysql.com/thread-pool-components.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. thread_pool_stall_limit: The time before an executing statement is considered to be stalled.
https://dev.mysql.com/thread-pool.html
Note MySQL Enterprise Thread Pool is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Thread Pool, implemented using a server plugin. The default thread-handling model in ...
https://dev.mysql.com/triggers-table.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The ...
https://dev.mysql.com/udf-features.html
You can define simple functions that operate on a single row at a time, or aggregate functions that operate on groups of rows. The MySQL interface for user-defined functions provides the following features and capabilities: Functions can return ...
https://dev.mysql.com/update-optimization.html
Performing multiple updates together is much quicker than doing one at a time if you lock the table. An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data ...
