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/replication-features-flush.html
In addition, if you use FLUSH TABLES when renaming a MyISAM table that is part of a MERGE table, you must issue FLUSH TABLES manually on the replicas. Some forms of the FLUSH statement are not logged because they could cause problems if replicated ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
Be sure to delete or rename any old configuration files when upgrading MySQL. When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. This section helps you diagnose and ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; For more information, see Section 13.1.18.3, “CREATE TABLE ... | ...
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/explain-output.html
When all tables are processed, MySQL outputs the selected columns and backtracks through the table list until a table is found for which there are more matching rows. EXPLAIN Output Columns EXPLAIN Join Types EXPLAIN Extra Information EXPLAIN Output ... The EXPLAIN statement provides information about how MySQL executes ...
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/mysql-cluster-replication-conflict-resolution.html
Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including ...
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/insert.html
If the ON DUPLICATE KEY UPDATE clause is used and a duplicate key causes an UPDATE to be performed instead, the statement requires the UPDATE privilege for the columns to be updated. For columns that are read but not modified you need only the ...