mysql> SHOW GLOBAL STATUS LIKE 'Open%tables'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Open_tables | 400 | | Opened_tables | 70123 | +---------------+-------+ mysql> SHOW GLOBAL VARIABLES WHERE variable_name = 'max_connections' OR variable_name = 'table_open_cache'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | max_connections | 151 | | table_open_cache | 400 | +------------------+-------+