Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory is required in the buffer pool, and less I/O is required to write out updated values. The pages that make up each table are arranged in a tree ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
NDB error code QRY_SCAN_ORDER_ALREADY_SET MySQL error DMEC Error message Index scan order was already set in query definition. The following list enumerates all NDB errors of type AE (Application error). Having a table without primary key uses an ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
In the latter case, you can temporarily work around the problem by executing an ALTER TABLE statement such as this one: ALTER TABLE tbl ALTER INDEX idx INVISIBLE; This causes MySQL to ignore the index idx on table tbl. This may be desirable when ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains UUID(). Like all other unsafe statements, this generates a warning if ...When ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
For statement-based logging, event information includes the SQL statement, the ID of the server on which it was executed, the timestamp when the statement was executed, how much time it took, and so forth. For row-based logging, the event indicates ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-fine-tuning.html
Some variable changes require that you rebuild the FULLTEXT indexes in your tables. Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. After changing any of these options, ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
Executing a SELECT expr statement N times differs from executing SELECT BENCHMARK(N, expr) in terms of the amount of overhead involved. This function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
The default value for the SOURCE_RETRY_COUNT option of the CHANGE REPLICATION SOURCE TO statement was changed to 10. The START REPLICA statement option SQL_AFTER_GTIDS is now compatible with the multi-threaded applier. (Previously, when MTA was ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
Traditionally, you would get this type of information using the techniques from Section 17.17, “InnoDB Monitors”, setting up InnoDB monitors and parsing the output from the SHOW ENGINE INNODB STATUS statement. InnoDB INFORMATION_SCHEMA schema ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
(This applies to statements terminated by ; or \G.) --batch, -B Command-Line Format --batch Print results using tab as the column separator, with each row on a new line. By default, mysql translates \r\n in statement strings to \n and interprets \0 ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...