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/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/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/mysql-cluster-online-operations.html
row *************************** Level: Warning Code: 1478 Message: Converted FIXED field 'c2' to DYNAMIC to enable online ADD COLUMN 1 row in set (0.00 sec) Columns are not converted from FIXED to DYNAMIC column format by renaming operations. Tells ... MySQL NDB Cluster 7.5 and 7.6 support online table schema changes using ALTER TABLE ...
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/privileges-provided.html
Summary of Available Privileges Privilege Descriptions Privilege-Granting Guidelines Summary of Available Privileges The following table shows the privilege names used in GRANT and REVOKE statements, along with the column name associated with each ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
This option can be combined with other ALTER TABLE options such as those used to add, drop, or rename columns or indexes. To upgrade a KEY partitioned table that was created in MySQL 5.1, first execute SHOW CREATE TABLE and note the exact columns ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
An event is not migrated or dropped as a result of renaming or dropping the user who created it. Users' EVENT privileges are stored in the Event_priv columns of the mysql.user and mysql.db tables. In both cases, this column holds one of the values ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%#sql%'; To remove an orphan intermediate table, perform the following steps: In the database directory, rename the #sql-*.frm file to match the base name of the orphan intermediate ... Information about table definitions is stored both in the .frm files, and in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
The table has these columns: USER The user name part of an account. If encryption is enabled, the function performs a log file rotation operation that renames the current log file, and begins a new log file encrypted with the password. For details ...Unless those objects are installed, the audit_log plugin operates in legacy ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
You can atomically rename a log table (to perform log rotation, for example) using the following strategy: USE mysql; DROP TABLE IF EXISTS general_log2; CREATE TABLE general_log2 LIKE general_log; RENAME TABLE general_log TO general_log_backup, ...