PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
For the case of a key longer than 250 bytes, a larger key block size than the default of 1024 bytes is used. Dynamic-sized rows are much less fragmented when mixing deletes with updates and inserts. Table 18.2 MyISAM Storage Engine Features Feature ... MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-worker.html
If an unusually large event exceeds this size, the transaction is held until all the applier worker threads have empty queues, and then processed. Waited due to the total size The number of times that the coordinator thread had to wait to schedule ... On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
However, if logging occurs at the statement level, there are certain binary logging issues with respect to stored programs (stored procedures and functions, triggers, and events): In some cases, a statement might affect different sets of rows on ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. Note If you specify the TABLE log destination, see Log Tables and “Too many open ...The slow query log can be used to find queries that take a long time to execute and are therefore candidates for ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Note When using tot_key_writes, you should keep in mind that a write operation in this context updates the row if the key exists, and inserts a new row otherwise. Generally, such a refusal is due to duplicate keys (inserts), Key not found errors ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ...mysql> SHOW WARNINGS; +---------+------+---------------------------------------------------------------+ | Level | Code | Message | +---------+------+---------------------------------------------------------------+ | Warning | 1478 | InnoDB: KEY_BLOCK_SIZE requires ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. Suppose that your application requires replica-side filtering rules, but transferring all binary log data to the replica first ...To ...
https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html
mysql shows how many rows were returned and how long the query took to execute, which gives you a rough idea of server performance. (For brevity, the “rows in set” line is sometimes not shown in the remaining examples in this chapter.) Keywords ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
The SHOW PROCESSLIST statement is very useful if you get the “too many connections” error message and want to find out what is going on. row *************************** Id: 1 User: system user Host: db: NULL Command: Connect Time: 1030455 State: ... SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
In other words, the replication line (indicated by the curved arrows in the diagram) directly connects all SQL nodes used as sources and replicas. This type of circular replication scheme for NDB Cluster, in which the line of replication (again ...