Skip to content
QuasarByte Software Company
  • Home
  • Company
  • Blog

MySQL

Using the New MySQL Query Profiler

April 27, 2015April 29, 2015 siteadmin

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 […]

 MySQL  MySQL

How to monitor server

April 27, 2015 siteadmin

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 […]

 MySQL  MySQL

How to select first, last days of month and year

April 27, 2015 siteadmin

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 […]

 MySQL  MySQL

How to manage query cache

April 24, 2015April 27, 2015 siteadmin

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 […]

 MySQL  MySQL

How to select existing database list

April 24, 2015April 27, 2015 siteadmin

show databases where `Database` regexp ‘^some_name_[0-9]+$’

 MySQL  MySQL

Contact us

Connect with:

Subscribe on our newsletter

You've already signed up, Thanks!
Check your inbox now to confirm your subscription.

Subscribe to be the first to know about our articles.

Proudly powered by WordPress | Theme: Moesia by aThemes