Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option: CREATE TABLE t (i INT) ENGINE = MYISAM; In MySQL 8.4, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...It ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. If you store values larger than the display width in an integer column that has the ZEROFILL ...
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 ...Use ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. C API Function Corresponding Server Command mysql_stmt_prepare() COM_STMT_PREPARE mysql_stmt_execute() COM_STMT_EXECUTE ... The ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...
https://dev.mysql.com/doc/refman/8.4/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. In practice, option files are used more commonly for this purpose, but Section 7.8.3, “Running Multiple MySQL Instances ...This is common for options that apply to a specific invocation of the ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
MySQL tries to extract range conditions from the WHERE clause for each of the possible indexes. MySQL performs an additional check to filter out rows that satisfy the range condition but not the full WHERE clause. MySQL does not support merging ...
https://dev.mysql.com/doc/refman/8.4/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. Required table repairs or upgrades reported by CHECK TABLE or mysqlcheck. Methods for ...For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-formats.html
This is called statement-based replication (which can be abbreviated as SBR), which corresponds to the MySQL statement-based binary logging format. You can also configure MySQL to use a mix of both statement-based and row-based logging, depending on ... Replication works because events written to the binary log are read from the source and then processed on the ...