https://dev.mysql.com/mysqladmin.html
You can use it to check the server's configuration and current status, to create and drop databases, and more. Invoke mysqladmin like this: shell> mysqladmin [options] command [command-arg] [command [command-arg]] ... Some of the commands take an ...
https://dev.mysql.com/myisam-maintenance-schedule.html
To start with, execute myisamchk -s each night on all tables that have been updated during the last 24 hours. It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. One way to check and repair MyISAM ...
https://dev.mysql.com/replication-features-functions.html
Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the slave unless row-based ...
https://dev.mysql.com/group-replication-configuring-consistency-guarantees.html
Transactions whose consistency level is not EVENTUAL hold execution until a timeout, configured by wait_timeout value is reached, which defaults to 8 hours. Although the Transaction Synchronization Points section explains that conceptually there ...
https://dev.mysql.com/innodb-information-schema-innodb_cmp.html
For example, if you archive the output of INNODB_CMP_RESET every 60 minutes, you see the statistics for each hourly period. The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which ...
https://dev.mysql.com/group-replication-performance-message-fragmentation.html
You can also use the system variable group_replication_member_expel_timeout to allow additional time (up to an hour) before a member under suspicion of having failed is expelled from the group. When an abnormally large message is sent between Group ...
https://dev.mysql.com/innodb-information-schema-innodb_cmpmem.html
For example, if every 60 minutes you archived the output of INNODB_CMPMEM_RESET, it would show the hourly statistics. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool.
https://dev.mysql.com/innodb-init-startup-configuration.html
Generally, the combined size of the log files should be large enough that the server can smooth out peaks and troughs in workload activity, which often means that there is enough redo log space to handle more than an hour of write activity. The ...
https://dev.mysql.com/statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/check-table.html
To avoid timeouts, the semaphore wait threshold (600 seconds) is extended by 2 hours (7200 seconds) for CHECK TABLE operations. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors.
