PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-trx-table.html
During times of contention, it counts down to zero, and statements release the latch immediately after each row lookup. TRX_AUTOCOMMIT_NON_LOCKING A value of 1 indicates the transaction is a SELECT statement that does not use the FOR UPDATE or LOCK ... The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-skip.html
You can use mysqlbinlog to retrieve and display the events that were logged around the time of the error. When you issue the START REPLICA statement for the next time following this SET statement, the new value for the system variable ...Details of ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
To avoid the issues that come with storing all tables and indexes inside the system tablespace, you can enable the innodb_file_per_table configuration option (the default), which stores each newly created table in a separate tablespace file (with ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
Dynamic-sized rows are much less fragmented when mixing deletes with updates and inserts. MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 18.2 MyISAM Storage Engine Features Feature ...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.0, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the default ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The value is one of int, uint (unsigned integer), double, decimal, datetime, or string (includes character and binary strings). On the other hand, the statistics become progressively more out of date when table modifications occur, until the next ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
2013-09-24T13:04:38.639684Z 49 [Note] Replication I/O thread: connected to source 'root@localhost:13000', replication started in log '0.000001' at position 114 Testing the InnoDB memcached Replication Configuration This example demonstrates how to ... Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high ...
https://dev.mysql.com/doc/refman/8.0/en/index-condition-pushdown-optimization.html
ICP can reduce the number of times the storage engine must access the base table and the number of times the MySQL server must access the storage engine. Without ICP, the storage engine traverses the index to locate rows in the base table and ...
https://dev.mysql.com/doc/refman/8.0/en/windows-troubleshooting.html
When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. The following examples show other common error messages you might encounter when installing MySQL and starting the ...This section helps you diagnose and correct some of these ...Your ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. If you start the MySQL server with external locking disabled, myisamchk may report an ...myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description of your ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
In MySQL 8.0, the method of delaying replication depends on two timestamps, immediate_commit_timestamp and original_commit_timestamp (see Replication Delay Timestamps). The output of mysqlbinlog displays these timestamps in two formats, microseconds ... MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of ...Use a CHANGE ...