Search Results
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.
https://dev.mysql.com/doc/refman/8.4/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/8.4/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning.html
See Section 28.3.21, “The INFORMATION_SCHEMA PARTITIONS Table”, for more information; for some examples of queries against this table, see Section 26.2.7, “How MySQL Partitioning Handles NULL”. Note Table partitioning differs from ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed periodically. Password reuse restrictions, to prevent old passwords from being chosen again. Password verification, to require that ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host ...