Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysqldumpslow.html
-h host_name Type String Default Value * Host name of MySQL server for *-slow.log file name. -i name Type String Name of server instance (if using mysql.server startup script). The MySQL slow query log contains information about queries that take a ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-transaction-management.html
To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your server. The default MySQL setting AUTOCOMMIT=1 can impose performance limitations on a busy ...For ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-memory-model.html
The buffers are global to the server, so the instruments are displayed only in the memory_summary_global_by_event_name table, and not in other memory_summary_by_xxx_by_event_name tables. Memory used depends on the load actually seen, not the load ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-memory-summary-tables.html
Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on performance. It has these effects: In general, truncation resets the baseline for statistics, but does not change ...Allocating a single byte one million times is not the same as allocating one million bytes a single time; tracking both sizes and counts can expose the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-mysql-option-table.html
The mysql_option table has the following columns: OPTION_NAME The name of the option or feature, or MySQL Server, as appropriate. To be shown in this table, a component or plugin must be written and compiled with support for the Option Tracker ...
https://dev.mysql.com/doc/refman/9.7/en/replication-binlog-encryption-scope.html
Existing binary log files and relay log files that were present on the server when you started encryption are not encrypted. When binary log encryption is active on the server, temporary files used to hold the binary log cache are encrypted using ...
https://dev.mysql.com/doc/refman/9.7/en/replication-channels.html
In MySQL multi-source replication, a replica opens multiple replication channels, one for each source server. The maximum number of channels that can be created on one replica server in a multi-source replication topology is 256. This is because ...
https://dev.mysql.com/doc/refman/9.7/en/replication-privilege-checks-recover.html
If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the channel. Details of the error and the last applied transaction are recorded in the Performance Schema ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics.html
The Server Telemetry Metrics Service and the Server Metrics Instrument Service enable you to register and query telemetry meters, metrics, and metric measurements, in order to periodically export these measurements using the OpenTelemetry protocol.
https://dev.mysql.com/doc/refman/9.7/en/upgrade-troubleshooting.html
If problems occur, such as that the new mysqld server does not start, verify that you do not have an old my.cnf file from your previous installation. If this command displays anything other than the program name, you have an active my.cnf file that ... A schema mismatch in a MySQL 9.6 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 9.7 to ...