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/server-system-variables.html
It reverts to using a temporary table, copying over the data, and then renaming the temporary table to the original, as used by MySQL 5.0 and earlier. The MySQL server maintains many system variables that affect its operation. Most system variables ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. For certain statements that a client might execute multiple times during a session, the ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and applications. Changes marked as Incompatible change are incompatibilities with earlier versions of ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled when you install it (see Section 5.5.4.1, “Installing or Uninstalling the Rewriter Query Rewrite Plugin”). To ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. The in-memory tables become effective for access control at that point. If you modify the grant ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-summary-tables.html
COUNT_MISC, SUM_TIMER_MISC, MIN_TIMER_MISC, AVG_TIMER_MISC, MAX_TIMER_MISC These columns aggregate all other I/O operations, including CREATE, DELETE, OPEN, CLOSE, STREAM_OPEN, STREAM_CLOSE, SEEK, TELL, FLUSH, STAT, FSTAT, CHSIZE, RENAME, and SYNC.
https://dev.mysql.com/doc/refman/5.7/en/myisam-crash-recovery.html
It ends the repair stage by removing the old .MYD file and renaming the new file to the original file name. This section describes how to check for and deal with data corruption in MySQL databases. If your tables become corrupted frequently, you ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 MODIFY COLUMN c2 TINYINT GENERATED ALWAYS AS (c1 + 5) STORED; Generated columns can be renamed or dropped, if no other column refers to them. ALTER TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
The plugin ignores files that have been renamed manually and do not match the pattern, and files that were encrypted with a password no longer available in the keyring. The audit log plugin supports functions that provide an SQL interface for ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME USER, CREATE (all forms except CREATE TABLE ... The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or ...