fpm-fcgi Server Status

Basic Information

April 18, 2024, 02:43:00 AM
Operating System: CentOS release 6.9 (Final)
Processor: Intel® Core(TM) i7 CPU 920 @ 2.67GHz (2668.000MHz)
Load averages: 0.34, 0.48, 0.57
Current processes: 254 (253 sleeping, 1 running, 0 zombie)
Processes by CPU: php-fpm (36) 45.6%, mysqld (1) 22.0%, nginx (7) 4.4%, ps (1) 1.0%, (other) (72) 0.0%
Memory usage: 99.18% (24528444k / 24731160k)
Swap: 19.774% (414468k / 2096060k)

MySQL processes

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

Running processes

State Time Query
Sending data 7s 
SELECT m.ID_MSG, m.ID_TOPIC, t.numReplies, t.numViews, m.ID_BOARD,
m.subject, mem.realName, t.ID_FIRST_MSG, b.name, m.posterName
FROM smf_messages as m, smf_topics as t, smf_boards as b, smf_members as mem
WHERE m.ID_MSG=t.ID_FIRST_MSG
AND mem.id_member = m.id_member
AND b.ID_BOARD = m.ID_BOARD
AND FIND_IN_SET(-1, b.memberGroups)
ORDER BY m.ID_TOPIC DESC
LIMIT 0,100

MySQL Statistics

MySQL 5.7.x
Connections per second: 3.7775
Kilobytes received per second: 20.9496
Kilobytes sent per second: 1576.936
Queries per second: 78.678
Percentage of slow queries: 0
Opened vs. Open tables:
(table_cache) 		82.1214 (should be <= 80)
Key buffer read hit rate:
(key_buffer_size) 		0.0214 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size) 		0.9978 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size) 		5556.2782 (should be >= 30 )
Thread cache usage:
(thread_cache_size) 		0.9375 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size) 		0.2735 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer) 		0.0001 (should be <= 0.001)
Query cache enabled:
(query_cache_type) 		1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit) 		0.6315 (should be <= 0.5)
Query cache prune rate:
(query_cache_size) 		0.0991 (should be <= 0.05)

Show more information...