Tuesday, February 3, 2015

Useful mysql debugging commands

Total tables:
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE';
show global status  like 'open%';
SHOW VARIABLES LIKE '%max%'

No comments:

Post a Comment