Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-truncate-table-reclaim-space.html
Truncating tables that are stored in the system tablespace (tables created when innodb_file_per_table=OFF) or in a general tablespace leaves blocks of unused space in the tablespace. To reclaim operating system disk space when truncating an InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
If an online migration operation exits abnormally (for example, if it is forcibly terminated), it is possible for keyring_operations to remain disabled on the running server, leaving it unable to perform keyring operations. A keyring migration ...
https://dev.mysql.com/doc/refman/8.4/en/kill.html
KILL QUERY terminates the statement the connection is currently executing, but leaves the connection itself intact. KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. Thread processlist identifiers can be ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
Clients connect to the MySQL server by providing the MySQL user name and LDAP password, and by enabling the client-side mysql_clear_password plugin: $> mysql --user=betsy --password --enable-cleartext-plugin Enter password: betsy_ldap_password Note ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press Ok; in that case, root access to the server will be authenticated by Section 8.4.1.10, “Socket Peer-Credential Pluggable Authentication” ... This section provides guidance on installing MySQL using the MySQL APT ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-debian.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press OK; in that case, root access to the server is authenticated using the MySQL Socket Peer-Credential Authentication Plugin for connections ...
https://dev.mysql.com/doc/refman/8.4/en/local-variable-scope.html
The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those blocks that declare a variable with the same name. Because local variables are in scope only during stored ...
https://dev.mysql.com/doc/refman/8.4/en/midpoint-insertion.html
If you prefer to use the plain LRU strategy, leave the key_cache_division_limit value set to its default of 100. By default, the key cache management system uses a simple LRU strategy for choosing key cache blocks to be evicted, but it also ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
You might want to test a new MySQL release while leaving an existing production setup undisturbed. In some cases, you might want to run multiple instances of MySQL on a single machine. Or you might want to give different users access to different ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
LocationDomainId takes an integer value between 0 and 16 inclusive, with 0 being the default; using 0 is the same as leaving the parameter unset. The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL ...