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/group-replication-secure-socket-layer-support-ssl.html
This variable has the following possible values: Table 20.1 group_replication_ssl_mode configuration values Value Description DISABLED Establish an unencrypted connection (the default). REQUIRED Establish a secure connection if the server supports ... Secure sockets can be used for group communication connections between members of a ...
https://dev.mysql.com/doc/refman/8.0/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. Found wrong password for user 'some_user'@'some_host'; ignoring user As ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-flushing.html
When table data is stored on a traditional HDD storage device, flushing neighbor pages in one operation reduces I/O overhead (primarily for disk seek operations) compared to flushing individual pages at different times. For table data stored on SSD, ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-configuration.html
For information about optimizing database operations for InnoDB tables, see Section 10.5, “Optimizing for InnoDB Tables”. This section provides configuration information and procedures for InnoDB initialization, startup, and various components ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-developing.html
Coming from a database background, you might be used to general-purpose SQL tables with many columns. The tables accessed by memcached code likely have only a few or even a single column holding data values. Typically, writing an application for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
This information is stored in undo tablespaces in a data structure called a rollback segment. Otherwise, InnoDB cannot discard data from the update undo logs, and the rollback segment may grow too big, filling up the undo tablespace in which it ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-ro-txn.html
In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) causes an error, and the transaction continues in read-only state: ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction. You ... InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-scheduling.html
You can view transaction scheduling weights by querying the TRX_SCHEDULE_WEIGHT column in the Information Schema INNODB_TRX table. For information about using INNODB_METRICS counters, see Section 17.15.6, “InnoDB INFORMATION_SCHEMA Metrics ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-recovery.html
From MySQL 8.0.26, checkpoints and advancing the checkpoint LSN are not permitted until redo log recovery is complete and data dictionary dynamic metadata (srv_dict_metadata) is transferred to data dictionary table (dict_table_t) objects. If an ...
https://dev.mysql.com/doc/refman/8.0/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT ...