PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/telemetry-metrics-configuration.html
This section lists the system variables used to configure Metric telemetry. Server Configuration telemetry.metrics_enabled System Variable telemetry.metrics_enabled Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value OFF ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/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/doc/refman/9.7/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Connect Used by replication receiver threads connected to the source, and by replication ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/unix-signal-response.html
Clients can prevent installation of SIGPIPE handlers by specifying the CLIENT_IGNORE_SIGPIPE option to mysql_real_connect() at connect time. On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system ...
https://dev.mysql.com/doc/refman/9.7/en/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 ...