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/storage-engine-setting.html
You can set the default storage engine for the current session by setting the default_storage_engine variable: SET default_storage_engine=NDBCLUSTER; The storage engine for TEMPORARY tables created with CREATE TEMPORARY TABLE can be set separately ... When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
Timeout values must be integers indicating how many seconds to wait to acquire locks before giving up with an error. Lock acquisition calls take an integer timeout value that indicates how many seconds to wait to acquire locks before giving up. If ...Namespace and lock names must be non-NULL, nonempty, and have a maximum length of 64 ... MySQL distributions provide a locking interface that is accessible at two levels: At the ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
To execute RENAME TABLE, there must be no active transactions or tables locked with LOCK TABLES. If any errors occur during a RENAME TABLE, the statement fails and no changes are made. If a table has triggers, attempts to rename the table into a ...
https://dev.mysql.com/doc/refman/5.7/en/savepoint.html
In this case, the row lock is released in the undo.) Savepoints that were set at a later time than the named savepoint are deleted. If the ROLLBACK TO SAVEPOINT statement returns the following error, it means that no savepoint with the specified ...
https://dev.mysql.com/doc/refman/5.7/en/show-binlog-events.html
Note Issuing a SHOW BINLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the binary log (which includes all statements executed by the server ...
https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. You can check whether the MySQL server died and restarted by executing mysqladmin version and examining the server's uptime. By ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...
https://dev.mysql.com/doc/refman/5.7/en/server-loadable-functions.html
MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove capabilities. MySQL Enterprise Edition includes a ...For ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-hosts.html
SHOW SLAVE HOSTS should be executed on a server that acts as a replication source. This is the server ID of the server on which SHOW SLAVE HOSTS is executed, so this same value is listed for each row in the result. SHOW SLAVE HOSTS Displays a list ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-syntax.html
Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary tables. Trying either to create a temporary table that uses the NDB storage engine or to alter an ...Keys ...