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/comments.html
In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or tab. If you add a version number after the ! character, the syntax within the comment is ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
Metadata lock acquisition order can make a difference in operation outcome when multiple transactions execute concurrently, as the following example illustrates. Lock acquisition order results in the RENAME TABLE executing before the INSERT. In this ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
A newly created secondary index contains only the committed data in the table at the time the CREATE INDEX or ALTER TABLE statement finishes executing. Online DDL support for adding secondary indexes means that you can generally speed the overall ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server.html
(For Windows, see Section 2.3.4.5, “Starting the Server for the First Time”.) For some suggested commands that you can use to test whether the server is accessible and working properly, see Section 2.9.3, “Testing the Server”. Otherwise, you ... This section describes how start the server on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/5.7/en/connecting-disconnecting.html
For help with other problems often encountered when trying to log in, see Section B.3.2, “Common Errors When Using MySQL Programs”. To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-sql-statements.html
You can also query the tables in the ndbinfo information database for real-time data about many NDB Cluster operations. This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. It is always enabled and attempting to disable it (--skip-secure-auth, --secure-auth=0) produces an ... The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-build-configuration.html
One indication of this issue is the presence of messages such as the following in the error log: [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure [ERROR] Native table ...It is possible to exclude certain parts ...
https://dev.mysql.com/doc/refman/5.7/en/test-pluggable-authentication.html
MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. With this plugin-loading method, the option must be given each time the server starts. For example: mysql> SELECT PLUGIN_NAME, ...This ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
This provides more fine-grained control over optimizer selection of an execution plan for various phases of query processing. With statement-based binary logging, having different modes for the source and replicas might lead to replication errors.