PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
Rewriting Prepared Statements Prepared statements are rewritten at parse time (that is, when they are prepared), not when they are executed later. If a rule cannot be loaded due to some error, calling flush_rewrite_rules() produces an error: mysql> ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io.html
io_latency The total wait time of timed file I/O events for the host. By default, rows are sorted by descending total file I/O latency. The host_summary_by_file_io and x$host_summary_by_file_io views have these columns: host The host from which the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io.html
io_latency The total wait time of timed file I/O events for the user. By default, rows are sorted by descending total file I/O latency. The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name.
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. --wait, -w Command-Line Format --wait Type Boolean Default Value false Instead of terminating with an ... The options described in this section can be used for any type of table maintenance operation performed by ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-table-problems.html
Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You ...
https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html
In this case, error 1964 Multiple channels exist on the slave. When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
Otherwise, an error occurs: ERROR 1123 (HY000): Can't initialize function 'keyring_key_generate'; The user is not privileged to execute this function. Attempts to use the functions without the keyring_udf plugin result in an error. Otherwise, an ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
If you are using this option to repair tables, it runs an extended repair that may not only take a long time to execute, but may produce a lot of garbage rows also! --default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint ...If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long ...
https://dev.mysql.com/doc/refman/5.7/en/table-corruption.html
If you get a lot of these errors, without mysqld having died unexpectedly just before, then something is wrong and needs to be investigated further. When the server detects MyISAM table corruption, it writes additional information to the error log, ... If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-elements.html
MySQL Enterprise Firewall is based on a plugin library that includes these elements: A server-side plugin named MYSQL_FIREWALL examines SQL statements before they execute and, based on the registered firewall profiles, renders a decision whether to ...Server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST implement INFORMATION_SCHEMA tables that provide views into the registered ...