多项选择题
A.Execution of the FLUSH LOGS statement
B.Starting of the SQL thread
C.Reaching the slave_pendign _jobs_size_max limit
D.Execution of FULSH TABLES WITH READ LOCK
E.Starting of the I/O thread
单项选择题 You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. Some details are as follows: The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query: SELECT TABLE_SCHEMA, ENGINE, COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= BASE TABLE GROUP BY TABLE_SCHEMA, ENGINE ; Why is this query slow to execute?()
多项选择题 Which two are correct steps in taking a binary backup of MyISAM tables?()
单项选择题 Which statement is true about FLUSH LOGS command?()