Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
Warning Changing privileges and permissions improperly on MySQL can potentially cause your server installation to have non-optimal security properties. This section explains the symptoms and resolutions for the most commonly encountered issues with ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
SchedulerResponsiveness: Set NDB scheduler response optimization 0-10; higher values provide better response time but lower throughput. ApiFailureHandlingTimeout: Maximum time for API node failure handling before escalating. Arbitration: How ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-autotune.html
autotune [--dryrun] [--sequential-restart] [--writeload=writeload] template cluster_name writeload: {low|medium|high} template: {web|realtime|test} The command autotune a number of parameters for the cluster according to the specified values for ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-client-commands.html
These commands are issued to the management agent using the mysql client program included with the MySQL NDB Cluster distribution (for information about the mysql client not specific to using MySQL Cluster Manager, see mysql — The MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log-setting.html
Warning When using statement-based logging for replication, it is possible for the data on the source and replica to become different if a statement is designed in such a way that the data modification is nondeterministic; that is, it is left up to ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/9.7/en/check-table.html
option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views for problems, such as tables that are referenced in the view definition that no longer exist. To ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-options-variables.html
clone_autotune_concurrency Command-Line Format --clone-autotune-concurrency System Variable clone_autotune_concurrency Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON When clone_autotune_concurrency is enabled (the ...
https://dev.mysql.com/doc/refman/9.7/en/comparison-operators.html
If no type conversion is needed for the values in the IN() list, they are all non-JSON constants of the same type, and expr can be compared to each of them as a value of the same type (possibly after type conversion), an optimization takes place.
https://dev.mysql.com/doc/refman/9.7/en/counting-rows.html
See Section 14.19.1, “Aggregate Function Descriptions” for information about COUNT(expr) behavior and related optimizations. Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-secondary-indexes.html
It is also possible to create an index on a JSON column using the JSON_VALUE() function with an expression that can be used to optimize queries employing the expression. A secondary index defined on a virtual column is sometimes referred to as a ...