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/rewriter-query-rewrite-plugin-usage.html
If a rule cannot be loaded due to some error, calling flush_rewrite_rules() produces an error: mysql> CALL query_rewrite.flush_rewrite_rules(); ERROR 1644 (45000): Loading of some rule(s) failed. When this occurs, the plugin writes an error message ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). If an ON UPDATE CASCADE or ON DELETE CASCADE subclause is only defined for one FOREIGN KEY clause, cascading operations fail with an ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
A namespace or lock name specified as NULL, the empty string, or a string longer than 64 characters results in an ER_LOCKING_SERVICE_WRONG_NAME error. If the timeout is reached without successful lock acquisition, an ER_LOCKING_SERVICE_TIMEOUT error ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
User-Defined Variable Assignment Parameter and Local Variable Assignment System Variable Assignment SET Error Handling Multiple Variable Assignment System Variable References in Expressions User-Defined Variable Assignment User-defined variables are ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
For example, on Ubuntu Linux, use: sudo apt-get install libevent-dev If you installed MySQL from a source code release, libevent 1.4.12 is bundled with the package and is located at the top level of the MySQL source code directory. get BB VALUE BB ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
Within the server, the set of lock-related objects changes with implementation of new features and code refactoring for performance improvements. If the _trace_ variable is enabled, an error is printed to the logs. If lock_order is enabled, an error ... The MySQL server is a multithreaded application that uses numerous internal locking and lock-related primitives, such as mutexes, rwlocks (including prlocks and sxlocks), conditions, and ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-troubleshooting.html
$> systemctl start mysql.service Job for mysqld.service failed because the control process exited with error code. If you configure the MySQL Server to use a non-default port, such as port 3307, and do not update the policy to reflect the change, ...
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html
If the server tries to create a shutdown thread and cannot (for example, if memory is exhausted), it issues a diagnostic message that appears in the error log: Error: Can't create thread to kill server The server stops accepting new connections. To ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-prerequisites.html
On Unix-like systems, including Linux, you can check your system's version of make like this: $> make --version GNU Make 4.2.1 As of MySQL 8.0.26, MySQL 8.0 source code permits use of C++17 features. If you encounter build errors such as internal ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | ...| ...