I'm reviewing the slow log, and on one of my slaves the average time for SHOW GLOBAL STATUS is 914s. Any idea how to determine the cause of this?
What do I need to do to generate the slow logs file in MySQL? I did: log_slow_queries = C:\Program Files\MySQL\MySQL Server 5.1\mysql-slow.log long_query_time = 1 What more do I need to do ...
I am experiencing issue. Someone 'attacked' my server: simply by searching the same phrase with multiple requests. As it is text search request and database indices are not used, the engine searches ...