Search Results
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
timeout must be greater than or equal to 0; when running in strict SQL mode, a negative timeout value is immediately rejected with an error (ER_WRONG_ARGUMENTS); otherwise the function returns NULL, and raises a warning. gtid_mode cannot be changed ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-indexes-table.html
Any other number represents a table created with a separate .ibd file in file-per-table mode. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_INDEXES table has these ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
TRX_AUTOCOMMIT_NON_LOCKING A value of 1 indicates the transaction is a SELECT statement that does not use the FOR UPDATE or LOCK IN SHARED MODE clauses, and is executing with autocommit enabled so that the transaction contains only this one ... The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
When the server is in read_only, super_read_only, transaction_read_only, or innodb_read_only mode. Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. To write queries for these tables most efficiently, use the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
Notes MySQL permits different sql_mode settings to tell the server the type of SQL syntax to support. For example, you might use the ANSI SQL mode to ensure MySQL correctly interprets the standard SQL concatenation operator, the double bar (||), in ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
Consistent read is the default mode in which InnoDB processes SELECT statements in READ COMMITTED and REPEATABLE READ isolation levels. A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-understanding-innodb-locking.html
If a second transaction wants to update a row or lock a table already locked by a prior transaction in an incompatible mode, InnoDB adds a lock request for the row to the corresponding queue. When a transaction updates a row in a table, or locks it ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
$> cd BASEDIR/data/#innodb_temp $> ls temp_10.ibt temp_2.ibt temp_4.ibt temp_6.ibt temp_8.ibt temp_1.ibt temp_3.ibt temp_5.ibt temp_7.ibt temp_9.ibt In statement based replication (SBR) mode, temporary tables created on a replica reside in a single ... InnoDB uses session temporary tablespaces and a global temporary ...
https://dev.mysql.com/doc/refman/8.4/en/invoking-programs.html
Options typically indicate the type of connection a program should make to the server or affect its operational mode. To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-encrypted-file-component.html
Any configuration file that stores a password should have a restrictive mode and be accessible only to the account used to run the MySQL server. Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a ...