Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-virtual-table.html
The INNODB_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based. A row appears in the INNODB_VIRTUAL table for each column upon which a virtual generated column is based.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schemata-extensions-table.html
The SCHEMATA_EXTENSIONS table augments the SCHEMATA table with information about schema options. The SCHEMATA_EXTENSIONS table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. If the schema is read only, the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-st-spatial-reference-systems-table.html
Example mysql> SELECT * FROM ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID = 4326\G *************************** 1. The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tp-thread-group-state-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_GROUP_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_group_state; The TP_THREAD_GROUP_STATE table has one ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tp-thread-group-stats-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_GROUP_STATS; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_group_stats; The TP_THREAD_GROUP_STATS table reports ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tp-thread-state-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_state; The TP_THREAD_STATE table has one row per thread ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-user-attributes-table.html
The currently authenticated account has the UPDATE or SELECT privilege for the mysql.user system table. The USER_ATTRIBUTES table provides information about user comments and user attributes. The USER_ATTRIBUTES table has these columns: USER The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning-monitoring.html
Based on the information in the INNODB_CMP and INNODB_CMP_PER_INDEX tables and overall application performance and hardware resource utilization, you might make changes in your hardware configuration, adjust the size of the buffer pool, choose a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | +-------------------------+ For more information about file-per-table tablespaces, see Section 17.6.3.2, ... There are ...