Search Results
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-tuning.html
The default value of 6 (60ms) is suitable for servers that primarily execute very simple statements. Assuming that the tp_thread_group_stats table is enabled, you can use the following query to determine the fraction of executed statements that ...
https://dev.mysql.com/doc/refman/8.4/en/time.html
Note that because '00:00:00' is itself a valid TIME value, there is no way to tell, from a value of '00:00:00' stored in a table, whether the original value was specified as '00:00:00' or whether it was invalid. MySQL retrieves and displays TIME ...
https://dev.mysql.com/doc/refman/8.4/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...
https://dev.mysql.com/doc/refman/8.4/en/transport-protocols.html
The following table shows the permissible values for --protocol and indicates the applicable platforms for each value. For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based ...
https://dev.mysql.com/doc/refman/8.4/en/tuning-trace-purging.html
A subsequent SELECT from the OPTIMIZER_TRACE table returns the first limit traces of the offset oldest stored traces (if offset >= 0), or the first limit traces of the -offset newest stored traces (if offset < 0). Thus, if a statement contains ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-paths.html
Notes Make sure you understand the MySQL release model for MySQL for MySQL long long-term support (LTS) and Innovation versions before proceeding with a downgrade. We recommend checking upgrade compatibility with MySQL Shell's Upgrade Checker ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
This section describes the system and status variables that validate_password provides to enable its operation to be configured and monitored. This applies only when changing an existing password, and has no effect when setting a user account's ...
https://dev.mysql.com/doc/refman/8.4/en/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 10.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/refman/8.4/en/views.html
Views are stored queries that when invoked produce a result set. The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Additional Resources You may find the MySQL User Forums ...
https://dev.mysql.com/doc/refman/8.4/en/windows-create-option-file.html
To initialize a MySQL installation by creating the data directory and populating the tables in the mysql system database, initialize MySQL using either --initialize or --initialize-insecure. If you need to specify startup options when you run the ...