Search Results
https://dev.mysql.com/doc/refman/8.4/en/restart.html
Because status variables are initialized for each server startup and do not persist across restarts, Com_restart normally has a value of zero, but can be nonzero if RESTART statements were executed but failed. One use for RESTART is when it is not ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
The lower_case_table_names setting can only be configured when initializing the server.) When successfully executed from the mysql program, REVOKE responds with Query OK, 0 rows affected. [IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
To set the initial plugin state explicitly, you can set the variable at server startup. Statements occurring within view definitions or stored programs are not subject to rewriting. To enable or disable the plugin, enable or disable the ...
https://dev.mysql.com/doc/refman/8.4/en/scheduler-component.html
For example, the audit_log server plugin calls the scheduler component at its initialization and configures a regular, recurring flush of its memory cache (see Enabling the Audit Log Flush Task). Note The scheduler component is included in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security mistakes. In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser doesn't seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-defaults.html
For non-Windows platforms, no default option file is created during either the server installation or the data directory initialization process. The MySQL server has many operating parameters, which you can change at server startup using ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
If you change a global system variable, the value is remembered and used to initialize the session value for new sessions until you change the variable to a different value or the server exits. variable: { user_var_name | param_name | local_var_name ...
https://dev.mysql.com/doc/refman/8.4/en/shared-key-cache.html
Multiple sessions can initiate requests that result in cache block replacements, as long as they do not interfere with each other (that is, as long as they need different index blocks, and thus cause different cache blocks to be replaced). Threads ...
https://dev.mysql.com/doc/refman/8.4/en/show-variables.html
These are the values used to initialize the corresponding session variables for new connections to MySQL. SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, ...