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/innodb-auto-increment-handling.html
The only circumstance in which InnoDB uses the equivalent of a SELECT MAX(ai_col) FROM table_name FOR UPDATE statement to initialize an auto-increment counter is when importing a table without a .cfg metadata file. To use the AUTO_INCREMENT ...This ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
Granting the SELECT privilege for the error_log table thus gives clients and applications access to error log contents using SQL queries, enabling DBAs to provide access to the log without the need to permit direct file system access on the server ... Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error ...The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a backup. In some cases, apparent database page corruption is actually due to the operating system ...After ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-ssl-rsa-setup.html
Invoke mysql_ssl_rsa_setup like this: mysql_ssl_rsa_setup [options] Typical options are --datadir to specify where to create the files, and --verbose to see the openssl commands that mysql_ssl_rsa_setup executes. If openssl is present, ...This ...
https://dev.mysql.com/doc/refman/8.0/en/problems.html
This section lists some common problems and error messages that you may encounter. It describes how to determine the causes of the problems and what to do to solve them.
https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html
InnoDB has to set locks in the latter case: During roll-forward recovery using a statement-based binary log, every SQL statement must be executed in exactly the same way it was done originally. InnoDB does not remember the exact WHERE condition, but ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html
Use a noop or deadline I/O scheduler with native AIO on Linux InnoDB uses the asynchronous I/O subsystem (native AIO) on Linux to perform read-ahead and write requests for data file pages. Increase buffer pool size When table data is cached in the ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
This script installs the innodb_memcache database with three required tables (cache_policies, config_options, and containers). get BB VALUE BB 10 16 GOODBYE, GOODBYE END quit If you shut down the MySQL server, which also shuts off the integrated ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Transaction data for an intention lock appears similar to the following in SHOW ENGINE INNODB STATUS and InnoDB monitor output: TABLE LOCK table `test`.`t` trx id 10080 lock mode IX Record Locks A record lock is a lock on an index record. Shared and ...A shared (S) lock permits the transaction that holds the lock to read a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-perror.html
This includes the error message, the type of error, and whether the error is permanent or temporary. To make substitution easier in scripts and other applications that might depend on perror for obtaining NDB error information, ndb_perror supports ... ndb_perror shows information about an NDB error, given its error ...--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type ...