PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. If something ...In the latter case, you should run REPAIR TABLE on the ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
An existing stored object can become orphaned through execution of a DROP USER statement that drops the object DEFINER account, or a RENAME USER statement that renames the object DEFINER account. If you plan to drop or rename the account, consider ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
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/added-deprecated-removed.html
group_replication_auto_increment_increment: Determines interval between successive column values for transactions executing on this server. Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and ...
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-what-is-new-7-5.html
The config_params table has been made read-only, and has been enhanced with additional columns providing information about each configuration parameter, including the parameter's type, default value, maximum and minimum values (where applicable), a ... Major changes and new features in NDB Cluster 7.5 which are likely to be of interest are shown in the following list: ndbinfo ...
https://dev.mysql.com/doc/refman/5.7/en/query-log.html
To rename the file and create a new one, use the following commands: $> mv host_name.log host_name-old.log $> mysqladmin flush-logs general $> mv host_name-old.log backup-directory On Windows, use rename rather than mv. You can also rename the ...
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 ...