Basic Information

April 29, 2024, 11:12:17 AM
Operating System: CentOS release 6.10 (Final)
Processor: Intel® Core(TM) i7-2600 CPU @ 3.40GHz (3401.000MHz)
Load averages: 3.85, 3.36, 3.57
Current processes: 310 (303 sleeping, 6 running, 1 zombie)
Processes by CPU: mysqld (1) 246.0%, php-cgi (9) 86.5%, nginx (10) 8.1%, httpd (7) 6.5%, ps (1) 2.0%, (other) (113) 0.7%
Memory usage: 71.836% (23558572k / 32795016k)
Swap: 0.12% (19640k / 16383996k)

MySQL processes

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

Running processes

State Time Query
Sending data 2s 
SELECT
	m.id_media, m.id_member, m.title, m.views, m.downloads, m.time_added, m.type, m.num_comments, m.voters, m.weighted AS rating, m.embed_url,
	IFNULL(lm.time, IFNULL(lm_all.time, 0)) < m.log_last_access_time AS is_new, mem.real_name AS real_name, m.member_name,
	ft.id_file AS id_thumb, ft.directory AS thumb_dir, ft.filename AS thumb_file, (pt.width && pt.height) AS has_preview,
	f.id_file, f.width, f.height, f.height AS thumb_height, f.filename, f.directory, m.approved, m.description, a.id_album, a.name, a.hidden
FROM smf_aeva_media AS m
	INNER JOIN smf_aeva_albums AS a ON (a.id_album = m.album_id)
	LEFT JOIN smf_aeva_files AS f ON (f.id_file = m.id_thumb)
	LEFT JOIN smf_aeva_files AS ft ON (ft.id_file = m.id_thumb)
	LEFT JOIN smf_aeva_files AS pt ON (pt.id_file = m.id_preview)
	LEFT JOIN smf_aeva_log_media AS lm ON (lm.id_media = m.id_media AND lm.id_member = 0)
	LEFT JOIN smf_aeva_log_media AS lm_all ON (lm_all.id_media = 0 AND lm_all.id_member = 0)
	LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)
WHERE FIND_IN_SET(-1, a.access) AND (a.hidden = 0) AND (CHAR_LENGTH(a.passwd) = 0) AND (m.approved = 1 OR m.id_member = 0)
ORDER BY RAND()
LIMIT 5
Sending data 1s 
SELECT
	m.id_media, m.id_member, m.title, m.views, m.downloads, m.time_added, m.type, m.num_comments, m.voters, m.weighted AS rating, m.embed_url,
	IFNULL(lm.time, IFNULL(lm_all.time, 0)) < m.log_last_access_time AS is_new, mem.real_name AS real_name, m.member_name,
	ft.id_file AS id_thumb, ft.directory AS thumb_dir, ft.filename AS thumb_file, (pt.width && pt.height) AS has_preview,
	f.id_file, f.width, f.height, f.height AS thumb_height, f.filename, f.directory, m.approved, m.description, a.id_album, a.name, a.hidden
FROM smf_aeva_media AS m
	INNER JOIN smf_aeva_albums AS a ON (a.id_album = m.album_id)
	LEFT JOIN smf_aeva_files AS f ON (f.id_file = m.id_thumb)
	LEFT JOIN smf_aeva_files AS ft ON (ft.id_file = m.id_thumb)
	LEFT JOIN smf_aeva_files AS pt ON (pt.id_file = m.id_preview)
	LEFT JOIN smf_aeva_log_media AS lm ON (lm.id_media = m.id_media AND lm.id_member = 0)
	LEFT JOIN smf_aeva_log_media AS lm_all ON (lm_all.id_media = 0 AND lm_all.id_member = 0)
	LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)
WHERE FIND_IN_SET(-1, a.access) AND (a.hidden = 0) AND (CHAR_LENGTH(a.passwd) = 0) AND (m.approved = 1 OR m.id_member = 0)
ORDER BY RAND()
LIMIT 5
Sending data 1s 
SELECT
	m.id_media, m.id_member, m.title, m.views, m.downloads, m.time_added, m.type, m.num_comments, m.voters, m.weighted AS rating, m.embed_url,
	IFNULL(lm.time, IFNULL(lm_all.time, 0)) < m.log_last_access_time AS is_new, mem.real_name AS real_name, m.member_name,
	ft.id_file AS id_thumb, ft.directory AS thumb_dir, ft.filename AS thumb_file, (pt.width && pt.height) AS has_preview,
	f.id_file, f.width, f.height, f.height AS thumb_height, f.filename, f.directory, m.approved, m.description, a.id_album, a.name, a.hidden
FROM smf_aeva_media AS m
	INNER JOIN smf_aeva_albums AS a ON (a.id_album = m.album_id)
	LEFT JOIN smf_aeva_files AS f ON (f.id_file = m.id_thumb)
	LEFT JOIN smf_aeva_files AS ft ON (ft.id_file = m.id_thumb)
	LEFT JOIN smf_aeva_files AS pt ON (pt.id_file = m.id_preview)
	LEFT JOIN smf_aeva_log_media AS lm ON (lm.id_media = m.id_media AND lm.id_member = 0)
	LEFT JOIN smf_aeva_log_media AS lm_all ON (lm_all.id_media = 0 AND lm_all.id_member = 0)
	LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)
WHERE FIND_IN_SET(-1, a.access) AND (a.hidden = 0) AND (CHAR_LENGTH(a.passwd) = 0) AND (m.approved = 1 OR m.id_member = 0)
ORDER BY m.id_media DESC
LIMIT 5
Sending data 1s 
SELECT
	m.id_media, m.id_member, m.title, m.views, m.downloads, m.time_added, m.type, m.num_comments, m.voters, m.weighted AS rating, m.embed_url,
	IFNULL(lm.time, IFNULL(lm_all.time, 0)) < m.log_last_access_time AS is_new, mem.real_name AS real_name, m.member_name,
	ft.id_file AS id_thumb, ft.directory AS thumb_dir, ft.filename AS thumb_file, (pt.width && pt.height) AS has_preview,
	f.id_file, f.width, f.height, f.height AS thumb_height, f.filename, f.directory, m.approved, m.description, a.id_album, a.name, a.hidden
FROM smf_aeva_media AS m
	INNER JOIN smf_aeva_albums AS a ON (a.id_album = m.album_id)
	LEFT JOIN smf_aeva_files AS f ON (f.id_file = m.id_thumb)
	LEFT JOIN smf_aeva_files AS ft ON (ft.id_file = m.id_thumb)
	LEFT JOIN smf_aeva_files AS pt ON (pt.id_file = m.id_preview)
	LEFT JOIN smf_aeva_log_media AS lm ON (lm.id_media = m.id_media AND lm.id_member = 0)
	LEFT JOIN smf_aeva_log_media AS lm_all ON (lm_all.id_media = 0 AND lm_all.id_member = 0)
	LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)
WHERE FIND_IN_SET(-1, a.access) AND (a.hidden = 0) AND (CHAR_LENGTH(a.passwd) = 0) AND (m.approved = 1 OR m.id_member = 0)
ORDER BY m.id_media DESC
LIMIT 5
Sending data 0s 
SELECT m.id_media, m.title, t.id_file, t.directory, t.filename, t.width, t.height
FROM smf_aeva_media AS m
LEFT JOIN smf_aeva_files AS t ON (t.id_file = m.id_thumb)
WHERE m.album_id = 2 AND (approved = 1 OR id_member = 0)
ORDER BY m.id_media DESC
Sending data 0s 
SELECT COUNT(m.id_media)
FROM smf_aeva_media AS m
	INNER JOIN smf_aeva_albums AS a ON (m.album_id = a.id_album)
	LEFT JOIN smf_aeva_log_media AS lm ON (lm.id_media = m.id_media AND lm.id_member = 0)
	LEFT JOIN smf_aeva_log_media AS lm_all ON (lm_all.id_media = 0 AND lm_all.id_member = 0)
WHERE FIND_IN_SET(-1, a.access) AND (a.hidden = 0) AND (CHAR_LENGTH(a.passwd) = 0)
AND IFNULL(lm.time, IFNULL(lm_all.time, 0)) < m.log_last_access_time
AND a.id_album = 4
AND m.approved = 1
LIMIT 1

MySQL Statistics

MySQL 10.x
Connections per second: 7.2416
Kilobytes received per second: 113.5117
Kilobytes sent per second: 3446.4959
Queries per second: 232.5903
Percentage of slow queries: 0
Opened vs. Open tables:
(table_cache) 		1.1005 (should be <= 80)
Key buffer read hit rate:
(key_buffer_size) 		0 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size) 		0.5842 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size) 		2646.6308 (should be >= 30 )
Thread cache usage:
(thread_cache_size) 		0.85 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size) 		0.2664 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer) 		0.0004 (should be <= 0.001)
Query cache enabled:
(query_cache_type) 		0 (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...