PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_users_size system ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. External locking is used in situations where a single process such as the MySQL server cannot be assumed to be the only ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
] HANDLER tbl_name CLOSE The HANDLER statement provides direct access to table storage engine interfaces. OPEN statement opens a table, making it accessible using subsequent HANDLER ... This table object is not shared by other sessions and is not ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case sensitivity of the underlying operating system plays a part in the case ... In ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-examples.html
The tables that contain information about InnoDB transactions and data locks enable you to determine which transaction is waiting for another, and which resource is being requested. (For descriptions of these tables, see Section 14.16.2, “InnoDB ... Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. TABLE filtering affects table I/O events (wait/io/table/sql/handler instrument) and table lock events (wait/lock/table/sql/handler ...The OBJECT_TYPE column indicates the type of object to which a row ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
The MySQL system table mysql.gtid_executed is used to preserve the assigned GTIDs of all the transactions applied on a MySQL server, except those that are stored in a currently active binary log file. The GTID for a transaction is shown in the ... A ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
In MySQL 5.7, all rows relating to employees working at stores in that region can be deleted with the query ALTER TABLE employees TRUNCATE PARTITION pWest, which can be executed much more efficiently than the equivalent DELETE statement DELETE FROM ...For more detailed syntactical information, see Section 13.1.18, “CREATE TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-column-privileges-table.html
The COLUMN_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 containing the column belongs. TABLE_SCHEMA ...The value can be any privilege that can be granted at the column level; see Section 13.7.1.4, “GRANT ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. For related usage information and examples, see Section 14.16.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”.