Search Results
https://dev.mysql.com/doc/refman/9.7/en/information-schema-schemata-table.html
Caution Because any static global privilege is considered a privilege for all databases, any static global privilege enables a user to see all database names with SHOW DATABASES or by examining the SCHEMATA table of INFORMATION_SCHEMA, except ... A ...
https://dev.mysql.com/doc/refman/9.7/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. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. TABLE_CATALOG The name of ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-checkpoints.html
There is no need to flush the buffer pool in one single batch, which would disrupt processing of user SQL statements during the checkpointing process. Making your log files very large may reduce disk I/O during checkpointing. It often makes sense ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-examples.html
This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables. Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. The tables ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-files-table.html
The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if present). For more ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-internal-data.html
This is not like user tables, where the data changes only when application-initiated updates occur. The data exposed by the transaction and locking tables (INFORMATION_SCHEMA INNODB_TRX table, Performance Schema data_locks and data_lock_waits ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-schema.html
This type of tuning is primarily for expert users who evaluate optimization strategies to overcome performance bottlenecks. This section provides a brief introduction to InnoDB integration with Performance Schema. For comprehensive Performance ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-transaction-model.html
Typically, several users are permitted to lock every row in InnoDB tables, or any random subset of the rows, without causing InnoDB memory exhaustion. The InnoDB transaction model aims to combine the best properties of a multi-versioning database ...
https://dev.mysql.com/doc/refman/9.7/en/installing.html
This section describes how to secure the initial MySQL root user account, which has no password until you assign one. A summary of the procedure follows and later sections provide the details. If you plan to upgrade an existing version of MySQL to a ...
https://dev.mysql.com/doc/refman/9.7/en/internal-functions.html
CAN_ACCESS_COLUMN(ARGS) CAN_ACCESS_DATABASE(ARGS) CAN_ACCESS_TABLE(ARGS) CAN_ACCESS_USER(ARGS) CAN_ACCESS_VIEW(ARGS) GET_DD_COLUMN_PRIVILEGES(ARGS) GET_DD_CREATE_OPTIONS(ARGS) GET_DD_INDEX_SUB_PART_LENGTH(ARGS) INTERNAL_AUTO_INCREMENT(ARGS) ...