Using the New MySQL Query Profiler
SELECT @@profiling; SET profiling = 1; SHOW PROFILES; SHOW PROFILE; SHOW PROFILE ALL; SHOW PROFILES; SHOW PROFILE FOR QUERY 1; SHOW PROFILE ALL FOR QUERY 1; SELECT * FROM information_schema.profiling […]
SELECT @@profiling; SET profiling = 1; SHOW PROFILES; SHOW PROFILE; SHOW PROFILE ALL; SHOW PROFILES; SHOW PROFILE FOR QUERY 1; SHOW PROFILE ALL FOR QUERY 1; SELECT * FROM information_schema.profiling […]
To monitor server, you can use following sql statements and os commands: mysqladmin extended -i100 -r SHOW PROCESSLIST SHOW VARIABLES SHOW INNODB STATUS vmstat 10 iostat -x 10 mpstat 10 […]
SELECT LAST_DAY(CURDATE()) + INTERVAL 1 DAY – INTERVAL 1 MONTH AS first_day_of_month, LAST_DAY(CURDATE()) AS last_day_of_month, MAKEDATE(YEAR(CURDATE()), 1) AS first_day_of_year, MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL 1 YEAR – INTERVAL 1 DAY AS […]
SET GLOBAL query_cache_type = OFF; SET GLOBAL query_cache_size = 0; SET SESSION query_cache_type = OFF; SHOW VARIABLES LIKE ‘query_cache%’; SHOW VARIABLES LIKE ‘%query_cache%’; #watch variables of cache status SHOW STATUS […]
show databases where `Database` regexp ‘^some_name_[0-9]+$’