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/alter-instance.html
ENCRYPTION operations, and locks are taken to prevent conflicts that could arise from concurrent execution of these statements. ALTER INSTANCE actions are written to the binary log so that they can be executed on replicated servers. ALTER INSTANCE ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr DROP PARTITION p2; Query OK, 0 rows affected (0.03 sec) Note The NDBCLUSTER storage engine does not support ALTER TABLE ... You can see that this is the case by ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-save.html
ps_setup_save() takes a timeout parameter to indicate how many seconds to wait if the lock already exists (which indicates that some other session has a saved configuration outstanding). Parameters in_timeout INT: How many seconds to wait to obtain ...This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...This enables you to alter the configuration ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-definition.html
Note If neither the ExecuteOnComputer nor the HostName parameter is present, the default value localhost is assumed for both. ExecuteOnComputer Version (or later) NDB 7.5.0 Type or units name Default [...] Range ... maxsize: The maximum size (in ...
https://dev.mysql.com/doc/refman/5.7/en/key-cache-restructuring.html
A key cache can be restructured at any time by updating its parameter values. File system caching is not as efficient as using a key cache, so although queries execute, a slowdown can be anticipated. For example: mysql> SET GLOBAL ...
https://dev.mysql.com/doc/refman/5.7/en/crashing.html
You can check how long your mysqld server has been up by executing mysqladmin version. If mysqld has died and restarted, you may find the reason by looking in the server's error log. On some systems, you can find in the error log a stack trace of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
Failing to do so results in errors when starting the server and during InnoDB recovery. Each time the master encryption key is rotated, all tablespace keys in the MySQL instance are re-encrypted and saved back to their respective tablespace headers.
https://dev.mysql.com/doc/refman/5.7/en/conditions-and-parameters.html
If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of RESIGNAL pops the Diagnostics Area stack, thus signalling the exception (that is, the information that existed before entry into the handler).
https://dev.mysql.com/doc/refman/5.7/en/condition-handling-restrictions.html
In MySQL, this is not guaranteed, so to get the main error, you cannot do this: GET DIAGNOSTICS CONDITION 1 @errno = MYSQL_ERRNO; Instead, do this: GET DIAGNOSTICS @cno = NUMBER; GET DIAGNOSTICS CONDITION @cno @errno = MYSQL_ERRNO; . SIGNAL, ...
https://dev.mysql.com/doc/refman/5.7/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...