Basic Information

April 28, 2024, 01:59:17 AM
Operating System: CentOS Linux release 7.9.2009 (Core)
Processor: Intel® Xeon® CPU E3-1231 v3 @ 3.40GHz (3711.694MHz)
Load averages: 1.26, 1.53, 1.58
Current processes: 253 (252 sleeping, 1 running, 0 zombie)
Processes by CPU: mysqld (1) 104.0%, httpd (40) 39.2%, sshd (8) 2.0%, named (1) 0.9%, fail2ban-server (1) 0.8%, (other) (142) 0.2%
Memory usage: 96.26% (31287760k / 32503284k)
Swap: 26.641% (279344k / 1048568k)

MySQL processes

Total processes: 2 (1 sleeping, 1 running, 0 locked)

MySQL Statistics

MySQL 5.5.x
Connections per second: 4.466
Kilobytes received per second: 39.1451
Kilobytes sent per second: 848.5032
Queries per second: 125.4873
Percentage of slow queries: 0
Opened vs. Open tables:
(table_cache)
229.025 (should be <= 80)
Key buffer read hit rate:
(key_buffer_size)
0.0045 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size)
0.594 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size)
1 (should be >= 30 )
Thread cache usage:
(thread_cache_size)
0 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size)
0.7367 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer)
0 (should be <= 0.001)
Query cache enabled:
(query_cache_type)
1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit)
1 (should be <= 0.5)
Query cache prune rate:
(query_cache_size)
0 (should be <= 0.05)

Show more information...