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/server-configuration.html
To determine the default command option and system variable values used by the server, execute this command: $> mysqld --verbose --help The command produces a list of all mysqld options and configurable system variables. Its output includes the ...
https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html
A key cache structured variable has these components: key_buffer_size key_cache_block_size key_cache_division_limit key_cache_age_threshold This section describes the syntax for referring to structured variables. If this were not true (that is, if ... A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
In this case, the column has no automatic properties at all. In this case, the DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses that specify automatic initialization and updating are available, but are not assigned to any TIMESTAMP ... TIMESTAMP and DATETIME columns can be automatically initializated and updated to the current date and time (that is, the current ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
This limits the number of simultaneous connections that can be made by any given account, but places no limits on what a client can do once connected. An “account” in this context corresponds to a row in the mysql.user system table. In this ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
This plugin exposes a set of system variables that enable you to configure password policy. This applies to the ALTER USER, CREATE USER, GRANT, and SET PASSWORD statements, and passwords given as arguments to the PASSWORD() function. This is true ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
This section helps you diagnose and correct some of these errors. This situation can occur when MySQL is upgraded and installed to a new location, but the configuration file is not updated to reflect the new location. If you have installed MySQL to ... When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
The implementation of internal XA requires that a storage engine support two-phase commit at the table handler level, and currently this is true only for InnoDB. This was because an XA transaction that was in PREPARED state would be rolled back on ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
You should also read the OS-specific section in this manual for problems that may be unique to your environment. This command also provides some useful information even if you have not compiled MySQL for debugging! If the problem is that some tables ... If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. To execute RENAME TABLE, there must be no active ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-detection.html
If the LATEST DETECTED DEADLOCK section of InnoDB Monitor output includes a message stating, “TOO DEEP OR LONG SEARCH IN THE LOCK TABLE WAITS-FOR GRAPH, WE WILL ROLL BACK FOLLOWING TRANSACTION,” this indicates that the number of transactions on ... When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the ...