Server Status

Basic Information

September 25, 2023, 09:02:38 PM

Operating System:	CentOS release 6.9 (Final)
Processor:	Intel® Core(TM) i7 CPU 920 @ 2.67GHz (2668.000MHz)
Load averages:	0.54, 0.58, 0.55
Current processes:	258 (257 sleeping, 1 running, 0 zombie)
Processes by CPU:	php-fpm (36) 27.0%, mysqld (1) 22.1%, nginx (7) 6.2%, ps (1) 1.0%, (other) (72) 0.0%
Memory usage:	99.185% (24529644k / 24731160k) Swap: 100% (2096060k / 2096060k)

MySQL processes

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

Running processes

State	Time	Query
Sending data	0s	SELECT mem.ID_MEMBER, mem.emailAddress, mem.notifyOnce, mem.notifyTypes, mem.notifySendBody, mem.lngfile, ln.sent, mem.ID_GROUP, mem.additionalGroups, b.memberGroups, mem.ID_POST_GROUP, t.ID_MEMBER_STARTED FROM (smf_log_notify AS ln, smf_members AS mem, smf_topics AS t, smf_boards AS b) WHERE ln.ID_TOPIC = 2440261 AND t.ID_TOPIC = 2440261 AND b.ID_BOARD = t.ID_BOARD AND mem.ID_MEMBER != 509 AND mem.is_activated = 1 AND mem.notifyTypes < 4 AND ln.ID_MEMBER = mem.ID_MEMBER GROUP BY mem.ID_MEMBER ORDER BY mem.lngfile

State

Time

Query

Sending data

SELECT
	mem.ID_MEMBER, mem.emailAddress, mem.notifyOnce, mem.notifyTypes, mem.notifySendBody, mem.lngfile,
	ln.sent, mem.ID_GROUP, mem.additionalGroups, b.memberGroups, mem.ID_POST_GROUP, t.ID_MEMBER_STARTED
FROM (smf_log_notify AS ln, smf_members AS mem, smf_topics AS t, smf_boards AS b)
WHERE ln.ID_TOPIC = 2440261
	AND t.ID_TOPIC = 2440261
	AND b.ID_BOARD = t.ID_BOARD
	AND mem.ID_MEMBER != 509
	AND mem.is_activated = 1
	AND mem.notifyTypes < 4
	AND ln.ID_MEMBER = mem.ID_MEMBER
GROUP BY mem.ID_MEMBER
ORDER BY mem.lngfile

MySQL Statistics

MySQL 5.7.x

Connections per second:	3.9531
Kilobytes received per second:	21.7556
Kilobytes sent per second:	1639.8132
Queries per second:	81.8696
Percentage of slow queries:	0
Opened vs. Open tables: (table_cache)	75.4459 (should be <= 80)
Key buffer read hit rate: (key_buffer_size)	0.0238 (should be <= 0.01)
Key buffer write hit rate: (key_buffer_size)	0.9977 (should be <= 0.5)
Thread cache hit rate: (thread_cache_size)	11114.9453 (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.2809 (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.6272 (should be <= 0.5)
Query cache prune rate: (query_cache_size)	0.0909 (should be <= 0.05)

Show more information...