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/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 5.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/doc/refman/5.7/en/no-matching-rows.html
Select only those columns that are used in the WHERE clause. Issue a SELECT for the column that should have matched a row against the table that was last removed from the query. Open the file in an editor, remove some insert lines (if there are more ... If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously ...
https://dev.mysql.com/doc/refman/5.7/en/option-defaults-equals.html
mysql> SELECT USER(); +---------------+ | USER() | +---------------+ | jon@localhost | +---------------+ 1 row in set (0.00 sec) This is not the same behavior as with the command line, where the equal sign is not required: $> mysql --user jon --host ...Due to this behavior, problems can occasionally arise when no value is provided for an option that expects ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
To provide a hint about the table join order, use STRAIGHT_JOIN; see Section 13.2.9, “SELECT Statement”. MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends.
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
The following limitations apply to the use of storage engines with user-defined partitioning of tables. Partitioning of FEDERATED tables is not supported; it is not possible to create partitioned FEDERATED tables. Partitioned tables using the CSV ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
Such hashes look like this: mysql> SELECT PASSWORD('mypass'); +--------------------+ | PASSWORD('mypass') | +--------------------+ | 6f8c114b58f2ce9e | +--------------------+ To store account passwords, the Password column of the user table was at ... Note The information in this section applies fully only before MySQL 5.7.5, and only for accounts that use the mysql_native_password or mysql_old_password authentication ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
You can determine what the thread is waiting for: SELECT * FROM performance_schema.events_waits_current WHERE THREAD_ID = thread_1; Say the query result identifies that the thread is waiting for mutex A, found in ... The Performance Schema is a tool ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering-names.html
For example, to select all file I/O instruments, it is better to use a pattern that includes the entire instrument name prefix: ... To check which instrument or consumer names a pattern matches, perform a simple test: SELECT NAME FROM ... Names ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-queries.html
By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event information to select from the events available after pre-filtering has been applied. Pre-filtering ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-timers-table.html
The setup_timers.TIMER_NAME value can be changed to select a different timer. The value can be any of the values in the performance_timers.TIMER_NAME column. For an explanation of how event timing occurs, see Section 25.4.1, “Performance Schema ...