Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
MySQL Enterprise Monitor Agent requires a user configured within each MySQL instance that is being monitored with suitable privileges to collect information about the server, including variable names, replication, and storage engine status ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
To view the current MySQL HeatWave query history, query the performance_schema.rpd_query_stats table: mysql> SELECT query_id, LEFT(query_text,160) FROM performance_schema.rpd_query_stats; *************************** 1. row ... Auto Query Time ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-crash-recovery.html
If your tables become corrupted frequently, you should try to find the reason why. For an explanation of how MyISAM tables can become corrupted, see Section 18.2.4, “MyISAM Table Problems”. If you run mysqld with external locking disabled (which ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
By limiting the search, it is possible to expend much less time and effort in finding matching rows than by scanning all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the query ... The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
Use this option if you do not want to remove existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory. When the optional DATA DIRECTORY [=] 'clone_dir' clause is not used, a cloning operation ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
The following tables are separated by section, and summarize the MySQL Router options defined in a MySQL Router configuration file. Detailed information about each of these options, such as descriptions and allowed values, is documented below these ... When started, MySQL Router reads a list of configuration files that together make up the configuration of the ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
"Transactions are not enabled" Error The following error is reported when using transactions: Transactions are not enabled This error indicates that you are trying to use transactions with a MySQL table that does not support transactions. Verify ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-errors.html
"Transactions are not enabled" Error The following error is reported when using transactions: Transactions are not enabled This error indicates that you are trying to use transactions with a MySQL table that does not support transactions. Verify ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbeventoperation.html
NdbEventOperation Class Overview NdbEventOperation::clearError() (DEPRECATED) NdbEventOperation::execute() NdbEventOperation::getBlobHandle() NdbEventOperation::getEpoch() NdbEventOperation::getEventType() (DEPRECATED) ... This section provides ...