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/innodb-persistent-stats.html
If innodb_stats_auto_recalc is disabled, you can ensure the accuracy of optimizer statistics by executing the ANALYZE TABLE statement after making substantial changes to indexed columns. When an index is added to an existing table, or when a column ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable column that exists in the table schema in the backup becomes part of the table's primary key in the database. Important ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
The B-tree index that represents an entire table is known as the clustered index, which is organized according to the primary key columns. The nodes of a clustered index data structure contain the values of all columns in the row. The nodes of a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html
A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use different data types, subject to certain conditions. (This is true even if both ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
Each grant table contains scope columns and privilege columns: Scope columns determine the scope of each row in the tables; that is, the context in which the row applies. Similarly, a db table row with Host, User, and Db column values of ... The ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initializated and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...Any of the synonyms for CURRENT_TIMESTAMP have the same meaning as ...