Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. The --base64-output=DECODE-ROWS and ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
On the production server: $> mysqldump --all-databases --no-create-info > dump-data.sql On the upgraded server: $> mysql < dump-data.sql Now check the table contents and run some test queries. When contemplating a MySQL upgrade, it is prudent to ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, “SET Syntax for Variable Assignment”). However, not all system variables can be ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
Note The ZEROFILL attribute is ignored for columns involved in expressions or UNION queries. MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-benchmarking.html
To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of time. With simple tests, you usually test how ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-multi-tables.html
Some techniques for keeping individual queries fast involve splitting data across many tables. When the number of tables runs into the thousands or even millions, the overhead of dealing with all these tables becomes a new performance consideration.
https://dev.mysql.com/doc/refman/8.4/en/optimizer-tracing-typical-usage.html
To examine traces for multiple queries, repeat the previous two steps as needed. To perform optimizer tracing entails the following steps: Enable tracing by executing SET optimizer_trace="enabled=ON". See Section 10.15.3, “Traceable ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
When the system has unused I/O capacity, more read-ahead can improve the performance of queries. Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
Increase buffer pool size When table data is cached in the InnoDB buffer pool, it can be accessed repeatedly by queries without requiring any disk I/O. If you follow best practices for database design and tuning techniques for SQL operations, but ...
https://dev.mysql.com/doc/refman/8.4/en/option-modifiers.html
Some options are “boolean” and control behavior that can be turned on or off. For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names at the beginning of query results.