Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisam-optimization.html
OPTIMIZE TABLE does a table repair and a key analysis, and also sorts the index tree so that key lookups are faster. myisamchk has a number of other options that you can use to improve the performance of a table: --analyze or -a: Perform key ... To ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-start.html
Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers between writes for any MyISAM table. If the file size would be larger than this value, the index is created using the key cache instead, which is slower. If the repair ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-secure-installation.html
--ssl* Options that begin with --ssl specify whether to connect to the server using encryption and indicate where to find SSL keys and certificates. This program enables you to improve the security of your MySQL installation in the following ways: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-shell.html
For more information, see Section 6.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value Pairs”. MYSQL SQL> MySQL Shell supports input-line editing as follows: left-arrow and right-arrow keys move horizontally within the current ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-shell.html
For more information, see Section 6.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value Pairs”. mysql-py> MySQL Shell supports input-line editing as follows: left-arrow and right-arrow keys move horizontally within the current ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-queries.html
Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical queries. Do ... To tune queries for InnoDB tables, create an appropriate set of indexes on each ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
For information about working with tables that are partitioned by hash or key, see Section 26.3.2, “Management of HASH and KEY Partitions”. Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-log-status-table.html
LOCAL The log position state information from the source, provided as a single JSON object with the following keys: binary_log_file The name of the current binary log file. STORAGE_ENGINES Relevant information from individual storage engines, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-summary-tables.html
The Performance Schema makes status variable information available in the tables described in Section 29.12.15, “Performance Schema Status Variable Tables”. It also makes aggregated status variable information available in summary tables, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-row-searches.html
If there are suitable indexes, one index is selected from the candidates, in the following priority order: A primary key. If the algorithm is able to select a primary key or a unique index where every column in the index has a NOT NULL attribute, it ... When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching ...