Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
UPDATE statements that require a table scan (because no index is used in the WHERE clause) must lock a greater number of rows than with row-based replication. If, however, you want to take advantage of the features specific to the statement-based or ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-showstatementactivity-category.html
Show Keys (Delta) The total number of SHOW KEYS | INDEX | INDEXES statements executed. Lists the Show Statement Activity metrics and provides a brief description of each. Table 6.29 Show Statement Activity Metrics NameDescriptionShow Authors ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
The prepared_statements_instances table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (STATEMENT_ID) Index on (STATEMENT_NAME) Index on (OWNER_THREAD_ID, OWNER_EVENT_ID) Index on (OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, ... The ...This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following ...
https://dev.mysql.com/doc/connectors/en/connector-python-multi.html
Connector/Python can execute either a single or multiple statements, this section references multiple statement and associated delimiter support. Note Before Connector/Python 9.2.0, the multi option was required to execute multiple statements. with ...DELIMITER: the word DELIMITER and any of its lower and upper case combinations such as delimiter, DeLiMiter, and so on, are considered reserved words by the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-multi.html
Connector/Python can execute either a single or multiple statements, this section references multiple statement and associated delimiter support. Note Before Connector/Python 9.2.0, the multi option was required to execute multiple statements. with ...DELIMITER: the word DELIMITER and any of its lower and upper case combinations such as delimiter, DeLiMiter, and so on, are considered reserved words by the ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
Index Handling To ignore foreign key constraints during the load operation, execute a SET foreign_key_checks = 0 statement before executing LOAD DATA. INTO Statement”.) To write data from a table to a file, use SELECT ... The syntax of the FIELDS ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
The CREATE FUNCTION statement is also used in MySQL to support loadable functions. To invoke a stored procedure, use the CALL statement (see Section 15.2.1, “CALL Statement”). IF NOT EXISTS succeeds with a warning indicating that it has the same ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
CHECK PARTITION to check one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of Partitions”. Column Value Table The table name Op Always check Msg_type status, error, ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
Options that you do not specify on a CHANGE REPLICATION SOURCE TO statement retain their value, except as indicated in the following discussion. The presence of such characters in these values causes the statement to fail with an error. The optional ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-ddlstatementactivity-category.html
Create Index (Delta) The total number of CREATE INDEX statements executed. Drop Index (Delta) The total number of DROP INDEX statements executed. Lists the DDL Statement Activity metrics and provides a brief description of each. Table 8.3 DDL ...