MySQL Profiling

See what’s running inside engine
show engine innodb status;

Check slow logs
select * from slow_log;

See running process
show full processlist;

Get value of global variable
show variables like ‘innodb_lock_wait_timeout’;

Query Cache
SET GLOBAL query_cache_size = 1000000;

show profiles;
set profiling = 0;
show profile for query 21;

show global status;
show status;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s