PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html
Stalled statements generate a lot of extra overhead since they involve extra context switches and in some cases even extra thread creations. This section provides guidelines on setting thread pool system variables for best performance, measured ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
Note For statements that assign, modify, or generate account passwords (ALTER USER, CREATE USER, GRANT, and SET PASSWORD; statements that use PASSWORD(), the validate_password capabilities described here apply only to accounts that use an ... The ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
In this case, MySQL generates a warning and sets the algorithm to UNDEFINED. The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a statement that refers to the view and the view ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
Undo the XA transaction that generated the error message, then restart replication. XA transaction support is limited to the InnoDB storage engine. For “external XA,” a MySQL server acts as a Resource Manager and client programs act as ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index belongs. SEQ_IN_INDEX The column sequence number in the index, starting with 1. That is, the number of indexed characters if the ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-queries.html
Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical queries. Do ... To tune queries for InnoDB tables, create an appropriate set of indexes on each ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
When the optimizer can make use of partition pruning in performing this query, execution of the query can be an order of magnitude faster than the same query against a nonpartitioned table containing the same column definitions and data. The ...The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-summary-tables.html
Each file I/O summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event instruments in the setup_instruments table: file_summary_by_event_name has an EVENT_NAME column. Each file ... The Performance Schema maintains file I/O summary tables that aggregate information about I/O ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
The following sections describe each replication table in more detail, including the correspondence between the columns produced by SHOW SLAVE STATUS and the replication table columns in which the same information appears. At this time, there are no ...This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for programmatic ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...