Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables. This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. InnoDB tables are represented in this view if ...This information is derived from in-memory data structures rather than data stored on ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. Session temporary tablespaces are recreated each time the server is started. SLAVE indicates that ...The INNODB_SESSION_TEMP_TABLESPACES table has these columns: ID The process or session ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-formats.html
The third, compressed format, can be created only with the myisampack utility (see Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”). When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions ...The SET clause indicates which columns to modify and the values they should be ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-datafiles-table.html
If a file-per-table tablespace is created in a location outside the MySQL data directory, the path value is a fully qualified directory path. The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-mutex-instances-table.html
When some code creates a mutex, a row is added to the mutex_instances table. The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. The mutex_instances table has these columns: NAME The instrument ...A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
The preceding definition can be written like this: { "filter": { "class": [ { "name": [ "connection", "general", "table_access" ] } ] } } Logging Specific Event Subclasses To select specific event subclasses, use an event item containing a name item ...For information about using JSON data in MySQL, see Section 13.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. It is important to create good ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ROUTINES table does not include built-in (native) functions or loadable functions. The ROUTINES table has these columns: SPECIFIC_NAME The ...ROUTINE_CATALOG The name of the catalog to which the routine ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
This column has most of what you see in the Create Table column that SHOW CREATE VIEW produces. IS_UPDATABLE MySQL sets a flag, called the view updatability flag, at CREATE VIEW time. (Even if a view is updatable, it might not be possible to insert ...You must have the SHOW VIEW privilege to access this ...VIEW_DEFINITION The ...