PDF (US Ltr)
- 40.2Mb
PDF (A4)
- 40.3Mb
Man Pages (TGZ)
- 262.0Kb
Man Pages (Zip)
- 367.6Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
You can hint that you want to have fixed length rows even if you have VARCHAR columns with the CREATE TABLE option ROW_FORMAT=FIXED. Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
InnoDB processes SELECT COUNT(*) statements by traversing the smallest available secondary index unless an index or optimizer hint directs the optimizer to use a different index. This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
A user with this privilege can use the SET RESOURCE GROUP statement and the RESOURCE_GROUP optimizer hint. The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
--default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint about which client-side authentication plugin to use. mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are compressed. These options can be given on ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-issues.html
MySQL uses a cost-based optimizer to determine the best way to resolve a query. In many cases, MySQL can calculate the best possible query plan, but sometimes MySQL does not have enough information about the data at hand and has to make ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
--default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint about which client-side authentication plugin to use. The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G *************************** 1. row *************************** NAME: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. For example, use ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
--default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint about which client-side authentication plugin to use. The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed ...