Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
The data in this column is interpreted from the tablespace flag information that resides in the data file. The data in this column is interpreted from the tablespace flags information that resides in the .ibd file. The data in this column is ... The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
The INNODB_TRX table has these columns: TRX_ID A unique transaction ID number, internal to InnoDB. To obtain details about the lock, join this column with the ENGINE_LOCK_ID column of the Performance Schema data_locks table. To obtain details about ... The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
It can also be employed to obtain the types of the result columns within applications that use a MySQL API that makes result set metadata available. With the mysql client program, you can use the --column-type-info option to display result column ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-select-all.html
--delimiter=character, -D character Causes the character to be used as a column delimiter. The column is nonempty only for Disk Data tables having nonindexed columns. --gci Adds a GCI column to the output showing the global checkpoint at which each ... ndb_select_all prints all rows from an NDB table to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-table-insert.html
The insert() method accepts individual columns or all columns in the table. Insert a Complete Record To insert a complete record, pass to the insert() method all columns in the table. Then pass to the values() method one value for each column in the ... You can use the insert() method with the values() method to insert records into an existing relational ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-insert.html
The insert() method accepts individual columns or all columns in the table. Insert a Complete Record To insert a complete record, pass to the insert() method all columns in the table. Then pass to the values() method one value for each column. You ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-worker-table.html
All error codes and messages displayed in the columns relating to errors correspond to error values listed in Server Error Message Reference. When a replica is restarted by a START REPLICA statement, the columns beginning APPLYING_TRANSACTION are ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-histogram-summary-tables.html
Within a given histogram, the BUCKET_NUMBER column indicates the bucket number. The BUCKET_NUMBER column indicates the bucket number within this global histogram. A histogram consists of N buckets, where each row represents one bucket, with the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-filtering.html
For foreground threads (resulting from client connections), the initial values of the INSTRUMENTED and HISTORY columns in threads table rows are determined by whether the user account associated with a thread matches any row in the setup_actors ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
Each wait event summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event instruments in the setup_instruments table: events_waits_summary_by_account_by_event_name has EVENT_NAME, ... The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary ...