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/using-log-files.html
Note that before starting mysqld with the general query log enabled, you should check all your tables with myisamchk. If this happens, you should check all your tables with myisamchk (see Chapter 7, MySQL Server Administration), and test the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/windows-restrictions.html
Alternatively, to use more than 2GB, use a 64-bit version of Windows. File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir location.
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
On the source, issue the following statement to enable the source to begin processing updates again: mysql> UNLOCK TABLES; A.14.5. Thus, when the update of client A makes it to co-source 2, it produces tables that are different from what you have on ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
LDAP pluggable authentication provides these capabilities: External authentication: LDAP authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables in LDAP directories. The following tables show the ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-reserved-words.html
For example, a table column named rank on a MySQL 5.7 source that is replicating to a MySQL 8.0 replica could cause a problem because RANK is a reserved word beginning in MySQL 8.0. Replication can fail in such cases with Error 1064 You have an ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-additionalslaves.html
For example, the InnoDB system tablespace, undo tablespace, and redo log might be stored in an alternative location. Alternatively, you can use the ALTER EVENT statement to set individual events to DISABLE or DISABLE ON SLAVE to prevent them from ...
https://dev.mysql.com/doc/refman/8.0/en/events-metadata.html
Value EVENTS Table SHOW EVENTS Execute at ETZ ETZ Starts ETZ ETZ Ends ETZ ETZ Last executed ETZ n/a Created STZ n/a Last altered STZ n/a . To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database. The session time ...Event Scheduler Time Representation Each session in MySQL has a session time zone ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-concurrent-ddl.html
DDL operations that are not permitted during a cloning operation regardless of the clone_block_ddl setting include: ALTER TABLE tbl_name DISCARD TABLESPACE; ALTER TABLE tbl_name IMPORT TABLESPACE; ALTER INSTANCE DISABLE INNODB REDO_LOG; . Prior to ...A workaround is to use dedicated donor instances, which can accommodate DDL operations being blocked while data is ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
By extracting a session ticket from an established session and then submitting that ticket while establishing the next connection, the overall cost is reduced if the session can be reused. The following table shows the system variables that define ... As of MySQL 8.0.29, MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime ...
https://dev.mysql.com/doc/refman/8.0/en/set-default-role.html
However, ALTER USER can set the default for only a single user, whereas SET DEFAULT ROLE can set the default for multiple users. On the other hand, you can specify CURRENT_USER as the user name for the ALTER USER statement, whereas you cannot for ...