Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/show-parse-tree.html
SHOW PARSE_TREE select_statement SHOW PARSE_TREE displays a representation of the parse tree for the input SELECT statement, in JSON format. Example: mysql> SHOW PARSE_TREE SELECT * FROM t3 WHERE o_id > 2\G *************************** 1. Note This ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.4/en/statement-caching.html
Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do SELECT statements. Suppose that a client prepares this statement: PREPARE s1 FROM 'SELECT * FROM t1'; The SELECT * expands in the internal structure to the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...
https://dev.mysql.com/doc/refman/8.4/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...