https://dev.mysql.com/slave-logs-status.html
The next time the slave starts, it reads the two logs to determine how far it previously proceeded in reading binary logs from the master and in processing its own relay logs. A replication slave server creates two slave status logs in the form of ...
https://dev.mysql.com/slave-logs.html
In MySQL 8.0, execution of any statement requiring a write lock on either or both of the slave_master_info and slave_relay_log_info tables is disallowed while replication is ongoing, while statements that perform only reads are permitted at any time. During replication, a slave server creates several logs that hold the binary log events relayed from the master to the slave, and record information about the current status and location within the relay ...
https://dev.mysql.com/source-ssl-library-configuration.html
If the installed OpenSSL version is lower than 1.0.1, CMake produces an error at MySQL configuration time. An SSL library is required for support of encrypted connections, entropy for random number generation, and other encryption-related ...
https://dev.mysql.com/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...
https://dev.mysql.com/starting-server-troubleshooting.html
(The default MySQL port number is 3306.) Then press Enter a couple of times. This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.5, “Troubleshooting a ...
https://dev.mysql.com/starting-server.html
(For Windows, see Section 2.3.4.5, “Starting the Server for the First Time”.) For some suggested commands that you can use to test whether the server is accessible and working properly, see Section 2.10.3, “Testing the Server”. This section ...
https://dev.mysql.com/stop-slave.html
You can control how long STOP SLAVE waits before timing out by setting the rpl_stop_slave_timeout system variable. When the timeout value is reached, the issuing client returns an error message and stops waiting, but the STOP SLAVE instruction ...] ...
https://dev.mysql.com/storage-engines.html
NDB (also known as NDBCLUSTER): This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability. Storage engines are MySQL components that handle the SQL operations for ...
https://dev.mysql.com/string-comparison-functions.html
Table 12.12 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...
https://dev.mysql.com/subquery-optimization-with-exists.html
Most optimizations cannot deal with predicates that may be turned on and off at query execution time, so they assume any trigcond(X) to be an unknown function and ignore it. Certain optimizations are applicable to comparisons that use the IN (or ...
