Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-per-table-stats.html
Rows Inserted The total number of rows inserted into the table. Insert Latency The total wait time of timed insert I/O events for the table. By default, rows are sorted by descending total wait time (tables with most contention first). Table 5.10 ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-24.html
SELECT statements where the SELECT query is offloaded to MySQL HeatWave and the result set is inserted into a table on the MySQL Database Service instance. For example, the following query, where L_LINESTATUS is a VARLEN-encoded string column, can ... Functionality Added or Changed Comparison of different temporal type values is now ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-performance-extensions.html
Default Value 0 Since Version 3.1.9 dontCheckOnDuplicateKeyUpdateInSQL Stops checking if every INSERT statement contains the "ON DUPLICATE KEY UPDATE" clause. 'Statement.getGeneratedKeys()', for statements that are rewritten only works when the ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
Within an uncommitted transaction, all updates (UPDATE, DELETE, or INSERT) that change transactional tables such as InnoDB tables are cached until a COMMIT statement is received by the server. If you are using the binary log and row based logging, ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
For details, including the return value after a multiple-row insert, see Section 14.15, “Information Functions”. If no AUTO_INCREMENT value was successfully inserted, the SELECT statement returns no row. Table 14.4 Comparison Operators Name ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. The server reads the contents of the grant tables into memory when it starts. The mysql system database includes ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. The INNODB_FT_INDEX_CACHE table has these columns: WORD A word extracted from the text of a newly inserted row. Before querying it, set the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-physical-structure.html
When new records are inserted into an InnoDB clustered index, InnoDB tries to leave 1/16 of the page free for future insertions and updates of the index records. If index records are inserted in a sequential order (ascending or descending), the ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
If a parameter is an immediate member of a SELECT list that is part of an INSERT statement, the derived type of the parameter is the type of the corresponding column into which the parameter is inserted. If a parameter is an immediate member of a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
For example, to grant the priv_repl user account the INSERT privilege to add rows to the cust table in db1, issue the following statement: mysql> GRANT INSERT ON db1.cust TO 'priv_repl'@'%.example.com'; You assign the PRIVILEGE_CHECKS_USER account ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...