Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
max_relay_log_size: If nonzero, relay log is rotated automatically when its size exceeds this value. If zero, size at which rotation occurs is determined by value of max_binlog_size. replica_checkpoint_group: Maximum number of transactions processed ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
Some examples of queries that are very fast: SELECT COUNT(*) FROM tbl_name; SELECT MIN(key_part1),MAX(key_part1) FROM tbl_name; SELECT MAX(key_part2) FROM tbl_name WHERE key_part1=constant; SELECT ... This section discusses optimizations that can ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-list-warnings.html
list warnings [--max=n] Using this command, you can check important warnings issued across the whole site during the executions of MySQL Cluster Manager client commands since the agent was started (or restarted). Use the --max option to specify the ...It provides additional information that is not exposed by the show warnings ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-table-search.html
Find data across a MySQL connection by using the text search feature on any number of tables and schemas. From the schema tree, select the tables, schemas, or both to search and then right-click the highlighted items and click Search Data Table ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html
This section provides configuration options that affect the modeling functionality in MySQL Workbench (see the figure that follows). Force use of software based rendering for EER diagrams MySQL Workbench uses OpenGL for rendering when available.
https://dev.mysql.com/doc/internals/en/autotools-configure-support.html
As shorthand, GROUP is a configuration group name such as none (select no plugins), all (select all plugins), or max (select all plugins used in a mysqld-max server). configure --help shows the following information pertaining to plugins: The ...
https://dev.mysql.com/doc/internals/en/autotools-plugin-macros.html
This macro is roughly equivalent to: MYSQL_PLUGIN(name, 'long-name, description) MYSQL_PLUGIN_DEFINE(name, WITH_NAME_STORAGE_ENGINE) Example: MYSQL_STORAGE_ENGINE(berkeley, berkeley-db, [BerkeleyDB Storage Engine], [Transactional Tables using ...
https://dev.mysql.com/doc/internals/en/limitations.html
While the overall exchange of data is free-form there are limitations in the initial handshake of the amount of data that can be exchanged: the auth_plugin_data field in Initial Handshake Packet can only carry 255 bytes max (see ...
https://dev.mysql.com/doc/internals/en/notes-on-mtr2.html
You must also use let $MYSQLD_DATADIR= `SELECT @@datadir`; New options max-test-fail: The number of test cases that can fail before the test run aborts. If the number of failing tests == max-test-fail, then the test run will abort. MTR2 has brought ...
https://dev.mysql.com/doc/internals/en/preventing-use-of-optimizer-trace.html
If for some reason, as DBA of a MySQL Server, you wish to prevent all users from seeing traces of their queries, start the server with these options: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum ...