Search Results
https://dev.mysql.com/doc/refman/9.7/en/load-data.html
For information about the efficiency of INSERT versus LOAD DATA and speeding up LOAD DATA, see Section 10.2.5.1, “Optimizing INSERT Statements”. The file can be read from the server host or the client host, depending on whether the LOCAL ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/performance-schema-mysql-option-table.html
To be shown in this table, a component or plugin must be written and compiled with support for the Option Tracker component. Not all MySQL components and plugins currently available provide such support. See Section 7.5.9.2, “Option Tracker ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ...