PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
INSERT INTO t2 VALUES (1), (2), (3); -- Update nontransactional table 7. INSERT INTO t1 VALUES (4), (5), (6); -- Write to transactional table -- Transaction 2 START (implicit) 9. Within the event hierarchy, wait events nest within stage events, ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
A very common error is to insert a new row with Host='%' and User='some_user', thinking that this enables you to specify localhost to connect from the same machine. Because that row has a Host value 'localhost' that is more specific than '%', it is ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is done correctly, subject to the following exceptions: When using statement-based replication prior to MySQL 5.7.1, AUTO_INCREMENT columns in tables on the ...A ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
SELECT FROM memory_table may insert a different set of rows on the source and replica. When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the first time that the source ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
MySQL appends a statement to the transaction to insert the GTID into the table. Note that in MySQL 5.7, the operation to insert the GTID into the table is atomic for DML statements, but not for DDL statements, so if the server exits unexpectedly ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
Although these functions are not deterministic, they are treated as safe for purposes of logging and replication: CONNECTION_ID(), CURDATE(), CURRENT_DATE(), CURRENT_TIME(), CURRENT_TIMESTAMP(), CURTIME(), LAST_INSERT_ID(), LOCALTIME(), ... The ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
(The latter table contains no Shutdown_priv column, so there is no need to check it.) For database-related requests (INSERT, UPDATE, and so on), the server first checks the user's global privileges in the user table row. SELECT statement, you need ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/5.7/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-code.html
For each statement that is taken from source, there is a code word stmt followed by a type (9 means DROP, 5 means INSERT, and so on). SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Even if free space displays as 0, it may be possible to insert rows as long as new extents need not be allocated. Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...