PHP 7.4
$CONFIG['dbtype'] = 'mysqli'; // Your database type
PHP memory limit is 500 MB -- I am increasing to 900 MB for now to see if that helps.
Our database uses InnoDB, I used optimize in phpmyadmin after changing the this setting in the link you provided: innodb_optimize_fulltext_only=1
It may have improved slightly, but it's still taking 11 seconds to load the main page while other pages load much quicker. Why is it only the main album list page loading slowly?
USER:
------------------
Array
(
[ID] => c40414937cd212dc10ab6f3a11b08d33
[am] => 1
[lang] => english
[liv_a] => Array
(
- => 17863
[1] => 8082
[2] => 17875
)
[liv] => Array
(
)
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 0
[user_name] => Guest
[groups] => Array
(
)
[group_quota] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 0
[can_post_comments] => 0
[can_upload_pictures] => 0
[can_create_albums] => 0
[pub_upl_need_approval] => 1
[priv_upl_need_approval] => 1
[access_level] => 3
[disk_max] => 0
[disk_min] => 0
[has_admin_access] => 0
[group_name] => Guests
[can_create_public_albums] => 0
[can_see_all_albums] => 0
[group_id] => 3
[allowed_albums] => Array
(
)
)
==========================
Queries:
------------------
Array
(
- => SELECT name, value FROM kyt_config [include/init.inc.php:177] (0.49 ms)
[1] => SELECT * FROM kyt_plugins ORDER BY priority
[include/plugin_api.inc.php:48] (0.28 ms)
[2] => SELECT user_id, time FROM `u7297900_newgal`.kyt_sessions WHERE session_id = '6b681e14982006dcc044aedf33a5270b' [bridge/coppermine.inc.php:241] (0.19 ms)
[3] => SELECT MAX(group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX(can_send_ecards) AS can_send_ecards, MAX(can_post_comments) AS can_post_comments, MAX(can_upload_pictures) AS can_upload_pictures, MAX(can_create_albums) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS priv_upl_need_approval FROM kyt_usergroups WHERE group_id in (3) [bridge/udb_base.inc.php:357] (0.24 ms)
[4] => SELECT group_name FROM kyt_usergroups WHERE group_id= 3 [bridge/udb_base.inc.php:362] (0.15 ms)
[5] => SELECT COUNT(*) FROM kyt_categorymap WHERE group_id in (3) [bridge/udb_base.inc.php:375] (0.16 ms)
[6] => SELECT aid FROM kyt_albums WHERE moderator_group IN (3) [include/init.inc.php:271] (0.23 ms)
[7] => SELECT lang_id FROM kyt_languages WHERE enabled='YES' [include/init.inc.php:334] (0.31 ms)
[8] => DELETE FROM kyt_banned WHERE expiry < '2022-05-26 02:26:28' [include/init.inc.php:448] (0.28 ms)
[9] => SELECT null FROM kyt_banned WHERE ('216.169.12.78' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:464] (0.19 ms)
[10] => SELECT aid FROM kyt_albums WHERE (1 AND visibility != 0 AND visibility != 10000 AND visibility NOT IN (3)) [include/functions.inc.php:1110] (0.3 ms)
[11] => SELECT cid, lft, rgt, name, description, thumb, depth AS level, '0' AS alb_count, '0' AS subalb_count
FROM kyt_categories
WHERE depth BETWEEN 0 + 1 AND 0 + 1
ORDER BY lft [index.php:299] (0.49 ms)
[12] => SELECT COUNT(DISTINCT(p.aid)) AS alb_count, COUNT(*) AS pic_count
FROM kyt_albums AS r
INNER JOIN kyt_pictures AS p ON p.aid = r.aid
WHERE r.category > 10000
AND approved = 'YES'
AND r.aid NOT IN (7346, 5077, 5078, 5079) [index.php:313] (5.16 ms)
[13] => SELECT aid, title, r.description, keyword, alb_hits, category, visibility, r.thumb, r.owner, depth AS level, lft, '0' AS pic_count
FROM kyt_categories AS c
INNER JOIN kyt_albums AS r ON r.category = c.cid
WHERE c.depth >= 0 + 1
AND r.aid NOT IN (7346, 5077, 5078, 5079)
ORDER BY r.pos ASC, r.aid ASC [index.php:335] (238.7 ms)
[14] => SELECT c.cid, r.aid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload, depth AS level, lft
FROM kyt_categories AS c
INNER JOIN kyt_albums AS r ON r.category = c.cid
INNER JOIN kyt_pictures AS p ON p.aid = r.aid
WHERE c.depth >= 0 + 1
AND approved = 'YES'
AND r.aid NOT IN (7346, 5077, 5078, 5079)
GROUP BY r.aid
ORDER BY NULL [index.php:362] (5562.04 ms)
[15] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163991 AND p.aid NOT IN (7346, 5077, 5078, 5079) [index.php:409] (0.32 ms)
[16] => SELECT extension, mime, content, player FROM kyt_filetypes [include/functions.inc.php:5952] (0.42 ms)
[17] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163992 AND p.aid NOT IN (7346, 5077, 5078, 5079) [index.php:409] (0.16 ms)
[18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163993 AND p.aid NOT IN (7346, 5077, 5078, 5079) [index.php:409] (0.13 ms)
[19] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163994 AND p.aid NOT IN (7346, 5077, 5078, 5079) [index.php:409] (0.18 ms)
[20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163995 AND p.aid NOT IN (7346, 5077, 5078, 5079) [index.php:409] (0.18 ms)
[21] => SELECT COUNT(*)
FROM kyt_pictures AS r
INNER JOIN kyt_albums AS a ON a.aid = r.aid
WHERE (1) AND r.aid NOT IN (7346, 5077, 5078, 5079)
AND approved = 'YES'
GROUP BY r.aid [include/functions.inc.php:1959] (685.25 ms)
[22] => SELECT r.aid, a.thumb, a.keyword, a.alb_hits, a.title, MAX(ctime) AS ctime
FROM kyt_pictures AS r
INNER JOIN kyt_albums AS a ON a.aid = r.aid
WHERE (1) AND r.aid NOT IN (7346, 5077, 5078, 5079)
AND approved = 'YES'
GROUP BY r.aid
ORDER BY ctime DESC
LIMIT 0 ,7 [include/functions.inc.php:1971] (4853.81 ms)
[23] => SELECT pid FROM kyt_pictures WHERE ((aid = '17879' AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.95 ms)
[24] => SELECT pid FROM kyt_pictures WHERE ((aid = '17875' AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.7 ms)
[25] => SELECT pid FROM kyt_pictures WHERE ((aid = '17878' AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.3 ms)
[26] => SELECT pid FROM kyt_pictures WHERE ((aid = '17877' AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.33 ms)
[27] => SELECT pid FROM kyt_pictures WHERE ((aid = '17876' AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.44 ms)
[28] => SELECT pid FROM kyt_pictures WHERE ((aid = '17874' AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.55 ms)
[29] => SELECT pid FROM kyt_pictures WHERE ((aid = '17873' AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.38 ms)
[30] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id
FROM kyt_pictures AS r
WHERE approved = 'YES'
AND r.pid IN (1190261,1190205,1190181,1190157,1190139,1190129,1189959) [include/functions.inc.php:2030] (0.3 ms)
[31] => SELECT count(aid) FROM kyt_albums as a WHERE category = '0' AND a.aid NOT IN (7346, 5077, 5078, 5079) [index.php:663] (0.93 ms)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
COOKIE :
------------------
Array
(
[cpg15x_data] => YTo1OntzOjI6IklEIjtzOjMyOiJjNDA0MTQ5MzdjZDIxMmRjMTBhYjZmM2ExMWIwOGQzMyI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJlbmdsaXNoIjtzOjU6Imxpdl9hIjthOjM6e2k6MDtpOjE3ODYzO2k6MTtpOjgwODI7aToyO2k6MTc4NzU7fXM6MzoibGl2IjthOjA6e319
[f7d9a22c729013ede6c529cfd58f8b0e] => 542837ab4dbc0cafef74833792228db5
[PHPSESSID] => f00fc4fe31a8f4eb93e8e05245512f6f
)
==========================
SESSION :
------------------
Array
(
)
==========================