Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-debugging-profiling.html
Default Value 1024 Since Version 8.0.31 profileSQL Trace queries and their execution/fetch times to the configured 'profilerEventHandler'. logger The name of a class that implements 'com.mysql.cj.log.Log' that will be used to log messages to.
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
Run the server with change buffering disabled (innodb_change_buffering=0) and do a slow shutdown. You might use this technique to avoid bottlenecks that can occur with a heavily loaded MySQL instance, or you might use different configuration options ... You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
This includes defining custom file paths for the error log, general log, slow query log (including the configuration of seconds it requires to execute a query), and the binary log. The Logging Options step enables you to define custom file paths for ... MySQL Configurator performs the initial configuration, a reconfiguration, and also functions as part of the uninstallation ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-format.html
This ID indicates which part of the server produced the message, and is consistent with general query log and slow query log messages, which include the connection thread ID. If no fatal error occurs but startup is excessively slow prior to ... Each ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview-requirements.html
NDB Cluster requires communication between data nodes and API nodes (including SQL nodes), as well as between data nodes and other data nodes, to execute queries and updates. Communication latency between these processes can directly affect the ...
https://dev.mysql.com/doc/mysqld-version-reference/en/options-variables.html
The following table shows all the options and variables available in MySQL Server. Intr: The version or versions in which the item was introduced. Depr: The version or versions in which the item was deprecated. Removed: The version or versions in ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
Compared to fully synchronous replication, semisynchronous replication is faster, because it can be configured to balance your requirements for data integrity (the number of replicas acknowledging receipt of the transaction) with the speed of ... In ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-faq.html
C.7: Why does monitoring a MySQL instance with FEDERATED tables cause extra connections, and decreased performance? When the agent starts, it executes a discovery process that performs a number of INFORMATION_SCHEMA queries that gather table ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Slow_queries The number of queries that have taken more than long_query_time seconds. If this value is high, it is a good indication that your tables are properly indexed for your queries. This value is high if you are doing a lot of queries that ...
https://dev.mysql.com/doc/refman/8.4/en/using-log-files.html
You can find the queries that take a long time to execute by starting mysqld with the slow query log enabled. If this works, you should also test all complicated queries that did not complete. If this happens, you should check all your tables with ... Note that before starting mysqld with the general query log enabled, you should check all your tables with ...