PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-build-configuration.html
If you install MySQL over a previous installation that was configured without the Performance Schema (or with an older version of the Performance Schema that has missing or out-of-date tables). One indication of this issue is the presence of ...It ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/en/query-cache-status-and-maintenance.html
Also, every table that is used by a query requires one block. However, if two or more queries use the same table, only one table block needs to be allocated. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. To ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/replica-logs.html
The connection metadata repository is written to the mysql.slave_master_info table or to a file. The applier metadata repository is written to the mysql.slave_relay_log_info table or to a file. The mysql.slave_master_info and ... A replica server ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-configuration.html
Replicas in a multi-source replication topology require TABLE repositories for the connection metadata repository and applier metadata repository, as specified by the master_info_repository and relay_log_info_repository system variables. A ...
https://dev.mysql.com/doc/refman/5.7/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 SLAVE. If you are sure that the replica started out perfectly synchronized with the source, and ... 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/5.7/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 4.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
MySQL Server supports multiple-table DELETE statements that can be used to efficiently delete rows based on information from one table or even from many tables at the same time. Sometimes there are other ways to test membership in a set of values ...