Search Results
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
The storage engine interface enables the optimizer to provide information about the size of the record buffer to be used for scans that the optimizer estimates are likely to read multiple rows. MySQL allocates buffers and caches to improve ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-other-options.html
This improves join performance by enabling the join optimizer to better choose the order in which to join the tables and which indexes it should use. This optimizes seeks and makes table scans that use indexes faster. myisamchk supports the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
You can do this by issuing, for each NDBCLUSTER table, an OPTIMIZE TABLE statement in the mysql client. OPTIMIZE TABLE is not supported for fixed-width columns of in-memory tables; it is also not supported for Disk Data tables. In this section, we ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
In addition, for each table, the ALTER TABLE statement should be followed by an OPTIMIZE TABLE to reclaim wasted space. REORGANIZE PARTITION and OPTIMIZE TABLE statements for each existing NDBCLUSTER table. In this section we provide a detailed ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
If there is a concern that optimizer-hint comments may be stored in object definitions so that dump files when reloaded with mysql would result in execution of such commands, either invoke mysql with the --binary-mode option or use a reload client ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-queries.html
Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
Most Performance Schema tables have indexes, which gives the optimizer access to execution plans other than full table scans. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
mysqlcheck A table-maintenance client that checks, repairs, analyzes, and optimizes tables. myisamchk A utility to describe, check, optimize, and repair MyISAM tables. Later sections provide a more detailed description of each one, with the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
By default, the replication I/O (receiver) thread does not write binary log events to the relay log if they have the replica's server ID (this optimization helps save disk usage). replication_optimize_for_static_plugin_config Command-Line Format ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
It also causes OPTIMIZE TABLE to be mapped to ALTER TABLE for storage engines for which OPTIMIZE TABLE is not supported. When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, ...