PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. Before ...This scenario can result in deadlocks as other transactions wait for the online DDL operation to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-statistics-estimation.html
Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or altered with STATS_PERSISTENT=0. Optimizer Statistics Updates Non-persistent optimizer statistics are updated when: Running ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
To create the replication metadata repositories as tables, specify master_info_repository=TABLE and relay_log_info_repository=TABLE at server startup. In that case, the replica's connection metadata repository is written to the slave_master_info ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. The trigger becomes associated with the table named tbl_name, which must refer to a permanent table. You cannot ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
Be warned that if you use them, your code is not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers do not: SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 ... MySQL Server supports some extensions that are likely not to be found in other SQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
These checks take place when the server is started, and when you first access a table. In general, a newer version of InnoDB may create a table or index that cannot safely be read or written with an older version of InnoDB without risk of crashes, ... InnoDB incorporates several checks to guard against the possible crashes and data corruptions that might occur if you run an old release of the MySQL server on InnoDB data files that use a newer file ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-schema.html
For example, you should know how enable instruments and consumers, and how to query performance_schema tables to retrieve data. To view InnoDB-related instruments, you can query the setup_instruments table for instrument names that contain 'innodb'.
https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html
Non-compressed, user-created temporary tables and on-disk internal temporary tables are created in a shared temporary tablespace. The innodb_temp_data_file_path variable defines the relative path, name, size, and attributes for temporary tablespace ...If no value is specified for innodb_temp_data_file_path, the default behavior is to create an auto-extending data file named ibtmp1 in the innodb_data_home_dir directory that is slightly larger than ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. The SQL statements used to grant and revoke privileges on NDB tables, databases containing ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used in creating a partitioned table. Using the SHOW TABLE STATUS statement to determine whether a table is ... This ...