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/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If multiple rows have ... If ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-features-to-trace.html
Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond reason. Subqueries: A subquery in which the WHERE clause may be executed once per row. They are: Greedy ...
https://dev.mysql.com/doc/refman/5.7/en/replication-upgrade.html
If you use statement-based logging (binlog_format=STATEMENT), if a replica is upgraded before the source, the source executes statements which succeed there but which may fail on the replica and so cause replication to stop. To do this without ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-security-procedures.html
Without FLUSH PRIVILEGES, the changes do not take effect until the next time that the server is restarted. By default these are installed on Unix-style systems with the permissions wxr-xr-x (755), which means they can be executed by any user that ...
https://dev.mysql.com/doc/refman/5.7/en/call.html
When the procedure returns, a client program can also obtain the number of rows affected for the final statement executed within the routine: At the SQL level, call the ROW_COUNT() function; from the C API, call the mysql_affected_rows() function.
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/data-masking-usage.html
Thus, even though ssn is defined as VARCHAR(11), if the ssn column has a multibyte character set, it may appear to be longer than 11 bytes when passed to a loadable function, and an error occurs. Before using MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/5.7/en/making-trace-files.html
In a console window, use this command: C:\> mysqld-debug --debug --standalone After this, you can use the mysql.exe command-line tool in a second console window to reproduce the problem. The trace file can become very large! To generate a smaller ...
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, ...