https://dev.mysql.com/automatic-start.html
systemd, the mysqld_safe and mysql.server scripts, Solaris SMF, and the macOS Startup Item (or MySQL Preference Pane) can be used to start the server manually, or automatically at system startup time. This section discusses methods for starting and ...
https://dev.mysql.com/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...
https://dev.mysql.com/backup-strategy-example.html
Assume also that the MySQL server is under load at the time of the crash. You should include such options as necessary to enable client programs to connect to the MySQL server. Assume that data is stored in the InnoDB storage engine, which has ...
https://dev.mysql.com/batch-mode.html
Why use a script? Here are a few reasons: If you run a query repeatedly (say, every day or every week), making it a script enables you to avoid retyping it each time you execute it. In the previous sections, you used mysql interactively to enter ...
https://dev.mysql.com/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains ...
https://dev.mysql.com/binary-log-transaction-compression-stats-table.html
The statistics cover all transactions written to the binary log and relay log from the time the server was started or the table was truncated. FIRST_TRANSACTION_TIMESTAMP The timestamp when the first transaction was written to the log. This table ...
https://dev.mysql.com/c-api-data-structures.html
(The BLOB_FLAG and TIMESTAMP_FLAG flags are unneeded.) ENUM and SET values are returned as strings. This section describes C API data structures other than those used for prepared statements, the asynchronous interface, or the replication stream ...
https://dev.mysql.com/c-api-function-overview.html
An advantage of mysql_use_result() is that the client requires less memory for the result set because it maintains only one row at a time (and because there is less allocation overhead, mysql_use_result() can be faster). The following list ...
https://dev.mysql.com/c-api-prepared-statement-problems.html
Here follows a list of the currently known problems with prepared statements: TIME, TIMESTAMP, and DATETIME do not support parts of seconds (for example, from DATE_FORMAT()). When converting an integer to string, ZEROFILL is honored with prepared ...
https://dev.mysql.com/c-api-threaded-clients.html
Two threads can share the same connection with the following caveats: Unless you are using the asynchronous C API functions mentioned previously, multiple threads cannot send a query to the MySQL server at the same time on the same connection. This ...
