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/plugin-loading.html
However, if a plugin is designed such that it must be loaded and initialized during server startup, attempts to load it at runtime using INSTALL PLUGIN produce an error: mysql> INSTALL PLUGIN myplugin SONAME 'somepluglib.so'; ERROR 1721 (HY000): ...
https://dev.mysql.com/doc/refman/5.7/en/string-collating.html
For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements within <collation> elements. If the sorting rules for your language are too complex to be handled with simple arrays, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...
https://dev.mysql.com/doc/refman/5.7/en/revoke.html
To revoke all privileges, use the second syntax, which drops all global, database, table, column, and routine privileges for the named user or users: REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... (GRANT does not create such rows when ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-crashing.html
If your keyboard is locked up, you may be able to recover by logging in to your machine from another machine and executing kbd_mode -a. If you have examined all other possibilities and concluded that the MySQL server or a MySQL client is causing the ...This can normally be checked by pressing the Caps Lock ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html
If deadlock detection is disabled using the innodb_deadlock_detect variable, InnoDB relies on the innodb_lock_wait_timeout setting to roll back transactions in case of a deadlock. If frequent deadlocks highlight a problem with transaction structure ... A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed by another ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
This is a one-time operation, which can be performed by installing an RPM provided by MySQL. A password for the superuser is set and stored in the error log file. Before You Start As a popular, open-source software, MySQL, in its original or ...
https://dev.mysql.com/doc/refman/5.7/en/load-data-local-security.html
To cause the server to refuse or permit LOAD DATA LOCAL statements explicitly (regardless of how client programs and libraries are configured at build time or runtime), start mysqld with local_infile disabled or enabled. Clients that make no ... The ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
If any tables named in the argument list do not exist, DROP TABLE behavior depends on whether the IF EXISTS clause is given: Without IF EXISTS, the statement drops all named tables that do exist, and returns an error indicating which nonexisting ...