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-processlist-table.html
The processlist table contains a row for each server process: mysql> SELECT * FROM performance_schema.processlist\G *************************** 1. row *************************** ID: 10 USER: me HOST: localhost:58834 DB: test COMMAND: Query TIME: 0 ... The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
All columns in the following example return NULL: mysql> SELECT NULL, 1+NULL, CONCAT('Invisible',NULL); To search for column values that are NULL, you cannot use an expr = NULL test. The following statement returns no rows, because expr = NULL is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html
Example: SELECT asynchronous_connection_failover_add_managed('channel2', 'GroupReplication', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '127.0.0.1', 3310, '', 80, 60); ... The following functions, which are available from MySQL 8.0.22 for standard ...
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. Because GTID-based replication is dependent on transactions, some features ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
Only those statements are written to the binary log where the default database (that is, the one selected by USE) is db_name. To specify more than one database, use this option multiple times, once for each database; however, doing so does not cause ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
The highest value present in the col column prior to the INSERT is 31, and the next available value in the AUTO_INCREMENT series is 35, so the inserted values for col begin at that point and the results are as shown for the SELECT query. This ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
SELECT requires a greater number of row-level locks than with row-based replication. SELECT, a CREATE statement is generated from the table definition and replicated using statement-based format, while the row insertions are replicated using ...For ...
https://dev.mysql.com/doc/refman/8.0/en/searching-on-two-keys.html
The one tricky case is that of searching on two different keys combined with OR: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' OR field2_index = '1' This case is optimized. You can also solve the problem efficiently by ... An OR using a single key is well optimized, as is the handling of ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
Connection_errors_select The number of errors that occurred during calls to select() or poll() on the listening port. If this value is high, it suggests that the server is doing a lot of full index scans (for example, SELECT col1 FROM foo, assuming ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-view.html
row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select 1 AS `a`,2 AS `b` character_set_client: utf8mb4 collation_connection: utf8mb4_0900_ai_ci ... SHOW ...