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/pluggable-storage.html
Unplugging a Storage Engine To unplug a storage engine, use the UNINSTALL PLUGIN statement: UNINSTALL PLUGIN example; If you unplug a storage engine that is needed by existing tables, those tables become inaccessible, but are still present on disk ... MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
The correct way to do floating-point number comparison is to first decide on an acceptable tolerance for differences between the numbers and then do the comparison against the tolerance value. Suppose that you execute the following statements: ...
https://dev.mysql.com/doc/refman/8.0/en/query-attributes.html
INSTALL COMPONENT loads the component, and also registers it in the mysql.component system table to cause it to be loaded during subsequent server startups. To uninstall the query_attributes component, use this statement: UNINSTALL COMPONENT ... The ...
https://dev.mysql.com/doc/refman/8.0/en/query-log.html
Each line that shows when a client connects also includes using connection_type to indicate the protocol used to establish the connection. connection_type is one of TCP/IP (TCP/IP connection established without SSL), SSL/TLS (TCP/IP connection ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs.html
The mysql.slave_master_info and mysql.slave_relay_log_info tables are created using the transactional storage engine InnoDB. Updates to the replica's applier metadata repository table are committed together with the transactions, meaning that the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-status.html
The Performance Schema has replication tables that provide this information in a more accessible form. The replication heartbeat information shown in the Performance Schema replication tables lets you check that the replication connection is active ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html
Source lists are stored in the mysql.replication_asynchronous_connection_failover and mysql.replication_asynchronous_connection_failover_managed tables, and can be viewed in the Performance Schema replication_asynchronous_connection_failover table.
https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
If the replica is running, check whether it established a connection to the source. Then make the replica's table identical to the source's and run START REPLICA. If you are sure that the replica started out perfectly synchronized with the source, ... If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/8.0/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. row *************************** ...