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/import-table.html
Given those file names, the copy commands look like this: $> cd export_basedir/data/hr $> cp employees_125.sdi /tmp/export $> cp managers_238.sdi /tmp/export $> cp employees.{MYD,MYI} /tmp/export $> cp managers.{MYD,MYI} /tmp/export Unlock the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-introduction.html
Row-level locking and Oracle-style consistent reads increase multi-user concurrency and performance. InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
The innodb_api_enable_mdl option can be used to lock the table at the MySQL level, so that the mapped table cannot be dropped or altered by DDL through the SQL interface. Without the lock, the table can be dropped from the MySQL layer, but kept in ... The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-failure-conditions.html
A LOCK clause specifies a low degree of locking (SHARED or NONE) that is not compatible with the particular type of DDL operation. A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-thread_concurrency.html
Threads waiting for locks are not counted in the number of concurrently executing threads. A thread that is waiting for a lock is given one ticket once the lock becomes available. InnoDB uses operating system threads to process requests from user ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting.html
If the failure is related to a deadlock, run with the innodb_print_all_deadlocks option enabled so that details about each deadlock are printed to the MySQL server error log. The following general guidelines apply to troubleshooting InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/kill.html
In most cases, it might take some time for the thread to die because the kill flag is checked only at specific intervals: During SELECT operations, for ORDER BY and GROUP BY loops, the flag is checked after reading a block of rows. During UPDATE or ... KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
This may lead to unpleasant surprises if your operating system does not support fault-free system locking. Usually NFS file locking is handled by the lockd daemon, but at the moment there is no platform that performs locking 100% reliably in every ... Each MySQL Instance on a machine should have its own data ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-crash-recovery.html
If you run mysqld with external locking disabled (which is the default), you cannot reliably use myisamchk to check a table when mysqld is using the same table. If the server is run with external locking enabled, you can use myisamchk to check ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-check-options.html
This is useful if you use myisamchk to check a table that is in use by some other application that does not use locking, such as mysqld when run with external locking disabled. This should be used to get full benefit of the --check-only-changed ...