Search Results
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html
Account Limits Tab The Account Limits tab defines the following limits on the selected user account: Max. The Administration - Users and Privileges tab provides a list of all users and privileges that relate to an active MySQL server instance. From ...
https://dev.mysql.com/doc/internals/en/optimizer-group-by-related-conditions.html
These are the main optimizations that take place for GROUP BY and related items (HAVING, COUNT(), MAX(), MIN(), SUM(), AVG(), DISTINCT()). For example, consider the query SELECT MAX(column1) FROM Table1 WHERE column1 < 'a'; If column1 is indexed, ...For the case GROUP BY x ORDER BY x, the optimizer will realize that the ORDER BY is unnecessary, because the GROUP BY comes out in order by ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-config-metric-sourcestatus-category.html
Replication Max Allowed Packet Maximum size of packets transmitted between source and replica. Max Relay Log Size Maximum size for a single relay log file. Relay Log Space Limit Maximum disk space allocated for relay logs. Pending Jobs Max Size ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-connection-category.html
Max Connect Errors If there are more than this number of interrupted connections from a host, that host is blocked from further connections. Max User Connections The maximum number of simultaneous connections permitted to any given MySQL user ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-replicationreplica-category.html
Checkpoint Group Sets the maximum number of transactions that can be processed by a multi-threaded replica before a checkpoint operation is called to update its status as shown by SHOW REPLICA STATUS. Checkpoint Period Sets the maximum time (in ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/agenthealth-advisor-ref.html
Memory Usage Thresholds (% of max allowed): enables you to define thresholds for RAM usage as a percentage of the maximum heap size allocated to the monitoring agent. Figure 21.3 Agent Health - Backlog Backlog Memory Usage Thresholds (% of max ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
The clone_max_concurrency variable defines the maximum number of threads that can be spawned. If clone_autotune_concurrency is disabled, clone_max_concurrency defines the number of threads spawned for a remote cloning operation. clone_buffer_size ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
To use the AUTO_INCREMENT mechanism with an InnoDB table, an AUTO_INCREMENT column must be defined as the first or only column of some index such that it is possible to perform the equivalent of an indexed SELECT MAX(ai_col) lookup on the table to ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
--ndb-batch-size=# Command-Line Format --ndb-batch-size System Variable ndb_batch_size Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 32768 Minimum Value 0 Maximum Value 2147483648 Unit bytes This sets the size ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-indexes.html
To find the MIN() or MAX() value for a specific indexed column key_col. In this case, MySQL does a single key lookup for each MIN() or MAX() expression and replaces it with a constant. For example: SELECT MIN(key_part2),MAX(key_part2) FROM tbl_name ... Indexes are used to find rows with specific column values ...