Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-member-stats-table.html
COUNT_TRANSACTIONS_ROWS_VALIDATING Number of transaction rows which can be used for certification, but have not been garbage collected. Can be thought of as the current size of the conflict detection database against which each transaction is ...The ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage-common-layer.html
From a technical perspective, what are some of the unique supporting infrastructure components that are in a storage engine? Some of the key feature differentiations include: Concurrency: Some applications have more granular lock requirements (such ... A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific application ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
Relay_Log_Space The total combined size of all existing relay log files. Last_IO_Error_Timestamp A timestamp in YYMMDD hh:mm:ss format that shows when the most recent I/O error took place. SHOW REPLICA STATUS [FOR CHANNEL channel] This statement ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-statement-avg-latency-histogram.html
Displays a textual histogram graph of the average latency values across all normalized statements tracked within the Performance Schema events_statements_summary_by_digest table. This procedure can be used to display a very high-level picture of ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-net.html
This section contains simple examples that demonstrate the use of Connector/ODBC drivers with ODBC.NET. 5.6.7.2.1 Using Connector/ODBC with ODBC.NET and C# (C sharp) The following sample creates a table my_odbc_net and demonstrates its use in C#.
https://dev.mysql.com/doc/internals/en/optimizer-index-merge-join-type.html
When doing Index Merge, MySQL retrieves rows for each of the keyscans and then runs them through a duplicate elimination procedure. This is actually a limitation, and can cause worse row retrieval strategy to be used. The Index Merge optimizer ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-locking.html
This enables you to control row locking to ensure safe, transactional document updates on collections and to avoid concurrency problems, for example when using the modify() method. Sets a shared mode lock on any rows that are read. Other sessions ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-locking.html
This enables you to control row locking to ensure safe, transactional document updates on collections and to avoid concurrency problems, for example when using the modify() method. Sets a shared mode lock on any rows that are read. Other sessions ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-locking.html
This enables you to control row locking to ensure safe, transactional document updates on collections and to avoid concurrency problems, for example when using the modify() method. Sets a shared mode lock on any rows that are read. Other sessions ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...