PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/resource-group-statements.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. This section describes the SQL ...
https://dev.mysql.com/doc/refman/8.0/en/searching-on-two-keys.html
An OR using a single key is well optimized, as is the handling of AND. Each SELECT searches only one key and can be optimized: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' UNION SELECT field1_index, field2_index FROM ...The one tricky case is that of searching on two different keys combined with OR: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' OR field2_index = '1' This case is ...
https://dev.mysql.com/doc/refman/8.0/en/server-administration.html
MySQL Server (mysqld) is the main program that does most of the work in a MySQL installation.
https://dev.mysql.com/doc/refman/8.0/en/server-status-variable-reference.html
Please see the corresponding item descriptions for details on setting and using the variables. The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variable-reference.html
The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in one unified list, with an indication of where each option or variable is ... The following table lists all system variables applicable within ...
https://dev.mysql.com/doc/refman/8.0/en/show-open-tables.html
SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. The FROM clause, if present, restricts the tables shown to those present in the db_name ...
https://dev.mysql.com/doc/refman/8.0/en/show-privileges.html
The privileges displayed include all static privileges, and all currently registered dynamic privileges. row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/show-slave-hosts.html
From MySQL 8.0.22, SHOW SLAVE HOSTS is deprecated and the alias SHOW REPLICAS should be used instead. The statement works in the same way as before, only the terminology used for the statement and its output has changed. Both versions of the ...
https://dev.mysql.com/doc/refman/8.0/en/show-slave-status.html
From MySQL 8.0.22, SHOW SLAVE STATUS is deprecated and the alias SHOW REPLICA STATUS should be used instead. The statement works in the same way as before, only the terminology used for the statement and its output has changed. Both versions of the ... SHOW {SLAVE | REPLICA} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.0/en/shutdown.html
SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command or the mysql_shutdown() C API function. A successful SHUTDOWN sequence consists of checking the privileges, validating the arguments, ...Another way to stop the server is to send it a SIGTERM signal, which can be done by root or the account that owns the server ...