PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-characteristics.html
Some of the setup tables have columns that can be modified to affect Performance Schema operation; some also permit rows to be inserted or deleted. Generally, the effect is to reset the summary columns to 0 or NULL, not to remove rows. The name of ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
DELETE Enables rows to be deleted from tables in a database. INSERT Enables rows to be inserted into tables in a database. SELECT Enables rows to be selected from tables in a database. UPDATE Enables rows to be updated in tables in a database. The ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
If columns d1 and d2 had been defined as DECIMAL rather than DOUBLE, the result of the SELECT query would have contained only one row—the last one shown above. Floating-point numbers sometimes cause confusion because they are approximate and not ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. Column Value Table The table name Op Always repair Msg_type status, error, info, note, or warning Msg_text An ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
Adding an AUTO_INCREMENT column to a table with ALTER TABLE might not produce the same ordering of the rows on the replica and the source. This occurs because the order in which the rows are numbered depends on the specific storage engine used for ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-temptables.html
In MySQL 8.0, when binlog_format is set to ROW or MIXED, statements that exclusively use temporary tables are not logged on the source, and therefore the temporary tables are not replicated. For more information about row-based replication and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
SELECT statement is recorded in the binary log as one transaction with one GTID, but if ROW format is used, the statement is recorded as two transactions with two GTIDs. If a source used STATEMENT format and a replica used ROW format, the replica ...
https://dev.mysql.com/doc/refman/8.0/en/show-plugins.html
row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/8.0/en/sys-processlist.html
By default, rows are sorted by descending process time and descending wait time. rows_examined The number of rows read from storage engines by the current statement. The MySQL process list indicates the operations currently being performed by the ...
https://dev.mysql.com/doc/refman/8.0/en/update-optimization.html
Another way to get fast updates is to delay updates and then do many updates in a row later. For a MyISAM table that uses dynamic row format, updating a row to a longer total length may split the row. An update statement is optimized like a SELECT ...