PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
CREATE TABLE t2 (a INT) ENGINE = MyISAM; -- Transaction 1 COMMIT -- (implicit; DDL forces commit) 6. COMMIT; -- Transaction 2 COMMIT From the perspective of the server, Transaction 1 ends when table t2 is created. These tables store transaction ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
Triggers must not have a missing or empty definer or an invalid creation context (indicated by the character_set_client, collation_connection, Database Collation attributes displayed by SHOW TRIGGERS or the INFORMATION_SCHEMA TRIGGERS table). To ...
https://dev.mysql.com/doc/refman/8.0/en/cost-model.html
The primary key for the server_cost table is the cost_name column, so it is not possible to create multiple entries for any cost estimate. The server recognizes these cost_name values for the server_cost table: disk_temptable_create_cost, ...These ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/8.0/en/memory-use.html
For MEMORY tables explicitly created with CREATE TABLE, only the max_heap_table_size system variable determines how large a table can grow, and there is no conversion to on-disk format. If you use a large number of tables, you can create a large ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...INNODB_BUFFER_PAGE_LRU: Holds information about the pages in the InnoDB buffer pool, in particular how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes ...
https://dev.mysql.com/doc/refman/8.0/en/request-access.html
This is where the privilege columns in the grant tables come into play. These privileges can come from any of the user, global_grants, db, tables_priv, columns_priv, or procs_priv tables. (You may find it helpful to refer to Section 8.2.3, “Grant ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
To move databases in a binary format from Unix to Windows or from Windows to Unix, create all databases and tables using lowercase names. In addition, MySQL Enterprise Backup can create compressed backup files, and back up subsets of tables. This ...MySQL Enterprise Backup The MySQL Enterprise Backup product lets you back up a running MySQL database with minimal disruption to operations while producing a consistent snapshot of the ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-close.html
Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed properly. If you get the following warning from CHECK TABLE or myisamchk, it means that this counter has gone out of sync: ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-lock-waits-table.html
The data_lock_waits table implements a many-to-many relationship showing which data lock requests in the data_locks table are blocked by which held data locks in the data_locks table. The table exposes not only which lock a session or transaction ...Held locks in data_locks appear in data_lock_waits only if they block some lock ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> ...Typically the first audit record written after plugin startup contains the server description and startup ...