PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-triggers-table.html
To see information about a table's triggers, you must have the TRIGGER privilege for the table. DEFINER The account named in the DEFINER clause (often the user who created the trigger), in 'user_name'@'host_name' format. Example The following ...The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-privileges-table.html
The USER_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the global level; see Section 15.7.1.6, “GRANT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html
(Even if a view is updatable, it might not be possible to insert into it; for details, refer to Section 27.5.3, “Updatable and Insertable Views”.) DEFINER The account of the user who created the view, in 'user_name'@'host_name' format. You must ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
Also, because the format is simpler, the chance for serious data corruption is smaller. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used directly ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
After the innodb_file_per_table option is configured, specify the ROW_FORMAT=COMPRESSED clause or KEY_BLOCK_SIZE clause, or both, in a CREATE TABLE or ALTER TABLE statement to create a compressed table in a file-per-table tablespace. If you specify ... Compressed tables can be created in file-per-table tablespaces or in general ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-doublewrite-buffer.html
(The number of buffer pool instances is controlled by the innodb_buffer_pool_instances variable.) Doublewrite file names have the following format: #ib_page_size_file_number.dblwr (or .bdblwr with the DETECT_ONLY setting). The doublewrite buffer is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
mysql> SELECT * FROM test.demo_test; Empty set (0.00 sec) InnoDB memcached Binary Log Notes Binary Log Format: Most memcached operations are mapped to DML statements (analogous to insert, delete, update). Since there is no actual SQL statement being ... Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would ...
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode. INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION ...