Search Results
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-information-schema.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-plugin-usage.html
Suppose that a file named de_cities.txt contains these city names in Germany: Berlin Munich Bremen Also suppose that a file named us_cities.txt contains these city names in the United States: Chicago Houston Phoenix El Paso Detroit Assume that the ...In that case, copy the dictionary files to that directory so that the MySQL server can access ... Before using MySQL Enterprise Data Masking, install it according to the ...
https://dev.mysql.com/doc/refman/9.7/en/delete-optimization.html
To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete all ...
https://dev.mysql.com/doc/refman/9.7/en/drop-procedure.html
(If the automatic_sp_privileges system variable is enabled, that privilege and EXECUTE are granted automatically to the routine creator when the routine is created and dropped from the creator when the routine is dropped. See Section 27.2.2, ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-distributed-recovery-securing.html
Group members offer their standard SQL client connection to joining members for distributed recovery, as specified by MySQL Server's hostname and port system variables, and may (also) advertise an alternative list of distributed recovery endpoints ... Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied not just to distributed recovery connections, but to group communications between members in ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-plugins-table.html
This file is located in the directory named by the plugin_dir system variable. The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. PLUGIN_STATUS The plugin ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-deadlocks-handling.html
If frequent deadlock warnings cause concern, collect more extensive debugging information by enabling the innodb_print_all_deadlocks variable. Use EXPLAIN SELECT to determine which indexes the MySQL server regards as the most appropriate for your ...
https://dev.mysql.com/doc/refman/9.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-pitr.html
Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was made. Clear the data node file systems (using ndbd ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldm-queries.html
There are two sets of queries, one run once at the start of the diagnostics, and another run iteratively for the defined number of iterations and the defined delay between each iteration.