https://dev.mysql.com/error-log.html
The error log contains a record of mysqld startup and shutdown times. This section discusses how to configure the MySQL server for logging of diagnostic messages to the error log. For information about selecting the error message character set or ...
https://dev.mysql.com/events-privileges.html
You can view current values for all of these at one time by running the statement SHOW STATUS LIKE '%event%';. To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable.
https://dev.mysql.com/execute.html
You can execute a given prepared statement multiple times, passing different variables to it or setting the variables to different values before each execution. EXECUTE stmt_name [USING @var_name [, @var_name] ...] After preparing a statement with ...
https://dev.mysql.com/expired-password-handling.html
Pass the CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS flag to mysql_real_connect() at connect time: MYSQL mysql; mysql_init(&mysql); if (!mysql_real_connect(&mysql, host, user, password, db, port, unix_socket, CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS)) { ...
https://dev.mysql.com/explain-for-connection.html
For example, if you are running a statement in one session that is taking a long time to complete, using EXPLAIN FOR CONNECTION in another session may yield useful information about the cause of the delay. To obtain the execution plan for an ...
https://dev.mysql.com/external-locking.html
If the server is run with external locking enabled, you can use myisamchk at any time for read operations such a checking tables. External locking affects server performance because the server must sometimes wait for other processes before it can ...
https://dev.mysql.com/faqs-general.html
Does MySQL 8.0 have a NOW() function with fractions of seconds? Yes, see Section 11.2.6, “Fractional Seconds in Time Values”. Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Does MySQL 8.0 have a NOW() ...
https://dev.mysql.com/faqs-migration.html
This may seem more complicated, but it will you save time and trouble. Where can I find information on how to migrate from MySQL 5.7 to MySQL 8.0? A.8.2. How has storage engine (table type) support changed in MySQL 8.0 from previous versions? A.8.1.
https://dev.mysql.com/faqs-security.html
Does MySQL 8.0 include support for Roles Based Access Control (RBAC)? Not at this time. Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself ...
https://dev.mysql.com/faqs-sql-modes.html
Does strict mode impact performance? The intensive validation of input data that some settings requires more time than if the validation is not done. What is the default server SQL mode when MySQL 8.0 is installed? A.3.1. What are server SQL modes? ...
