I am the server admin for this persons gallery. I can occasionally get the passwords to work for the update.php script but they never seem to work to login to the actual gallery.
The database is just over 300 MB - The main gallery page loads horribly slow, http://kardashianworld.net/gallery/
while most other pages on the gallery load quickly. http://kardashianworld.net/gallery/index.php?cat=639
My theory is something related to the database is causing the slow loading issue along with the password issue. Hopefully Ron or someone else has ran into this sort of problem before. As I am out of ideas on how to fix.
Currently my only guess to fix it is a more powerful server or splitting the gallery into multiple galleries to avoid the large database size.
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
(
- => 3
)
[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
(
)
==========================
You haven't provided any history about the situation. Was it functioning more smoothly with so many categories and albums at one point and then suddenly got very slow? Are the other galleries that you mentioned as large as this one, yet have decent performance?
Suggestions:
You can remove 'lastalb' from what is displayed on the home page.
Or if it is mainly a public facing gallery with no login, you can use my theme caching plugin (https://forum.coppermine-gallery.net/index.php/topic,80231.msg388275.html#msg388275). (which I see you have used before)
It's been getting worst over the last year or two. It didn't suddenly occur. The next largest account on our server has 550k photos and it doesn't have loading issues like this site. This gallery is over 1 million.
I've turned off everything on the front page except breadcrumb and album list and it still has the issues. Is it possible to turn off the photo count #'s and only display links to albums? It's got to be something causing the long SQL delays that is mostly related to the front page. That is the only thing the front page has that the subpages don't.
I highly doubt my client can afford a dedicated server, so what can we do to modify coppermine's main page? I've tried the cache plugin and it doesn't seem to help.
I have a hard time believing the theme cache plugin didn't help a great deal. Could you please install/enable it again so that I can see the results. Please tell me which theme(s) it is enabled for ... remember there must be a 'cache' folder in the theme directory. For only non-logged in use, after the home page is visited once, the next visit should be fast (within the cache expiration time).
I installed the 1.0 version of theme cache and it doesn't seem to be generating any files in the cache folder so I assume it is not working. I tested it on the default theme and the custom theme. The cache folder is chmod 755, I also tried it at 777 with no luck. Plugin enabled and set to 24 hours.
A file finally showed up in the cache folder, but I can't seem to get a cached page served to me as I am searching the source code for your CACHED hidden comment and cannot locate. I have logged out.
This is what is inside the temp file that did generate, it doesn't seem complete.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Pragma" content="no-cache" />
<title>Last additions - Kardashian World</title>
<link rel="stylesheet" href="css/coppermine.css" type="text/css" />
<link rel="stylesheet" href="themes/GD_KardashCPGv2/style.css" type="text/css" />
<link rel="shortcut icon" href="/wp-content/themes/GD_KardashWPv2/images/ico.png" />
<script type="text/javascript">
/* <![CDATA[ */
var js_vars = {"site_url":"http:\/\/kardashianworld.net\/gallery","debug":false,"icon_dir":"images\/icons\/","lang_close":"Close","icon_close_path":"images\/icons\/close.png"};
/* ]]> */
</script>
<script type="text/javascript" src="js/jquery-1.12.4.js"></script>
<script type="text/javascript" src="js/jquery-migrate-1.4.1.js"></script>
<script type="text/javascript" src="js/scripts.js"></script>
<script type="text/javascript" src="js/jquery.greybox.js"></script>
<script type="text/javascript" src="js/jquery.elastic.js"></script>
<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
<link href='https://fonts.googleapis.com/css?family=Playfair+Display:400,400italic,700,700italic|Source+Sans+Pro:400,300,300italic,400italic,700,700italic|Oswald:400,700,300|Lato:400,400italic,700,700italic' rel='stylesheet' type='text/css'>
<script>
$(document).ready(function() {
$('body').addClass('js');
var $menu = $('#menu'),
$menulink = $('.menu-link');
$menulink.click(function() {
$menulink.toggleClass('active');
$menu.toggleClass('active');
return false;
});});
</script>
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<script>
(adsbygoogle = window.adsbygoogle || []).push({
google_ad_client: "ca-pub-2251721893274244",
enable_page_level_ads: true
});
</script>
</head>
<div class="wrapper">
<div id="navigation">
<div align="center">
<a href="#menu" class="menu-link"><i class="fa fa-bars"></i></a>
<nav id="menu" role="navigation"><ul>
<li><a class="homepage" href="/">Home</a></li>
<li><a href="/kuwtk">KUWTK</a></li>
<li><a href="/about">About</a></li>
<li><a href="/gallery">Photo Gallery</a></li>
<li><a href="/interview-archive">Press Archive</a></li>
<li><a href="http://twitter.com/KUWTKWorld/"><i class="fa fa-twitter"></i></a></li>
</ul></nav>
</div>
</div> </div>
<div id="header">
</div>
<!-- start new FFH Google adcode -->
<br />
<!-- Google Auto-ads -->
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<script>
(adsbygoogle = window.adsbygoogle || []).push({
google_ad_client: "ca-pub-2251721893274244",
enable_page_level_ads: true
});
</script>
<!-- End Google Auto-ads -->
<center>
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- responsive-horizontal -->
<ins class="adsbygoogle"
style="display:block"
data-ad-client="ca-pub-2251721893274244"
data-ad-slot="9360852998"
data-ad-format="auto"
data-full-width-responsive="true"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</center>
<br />
<!-- FFH Ad Tracking code - shows stats for all sites combined-->
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-36190990-2"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'UA-36190990-2');
</script>
<!-- FFH Network Tracking Code - Shows what sites have ads-->
<script src="https://freefansitehosting.com/ads/track.js"></script>
<!-- end new FFH adcode -->
<body class=body><div id="container">
<div class="navigal" style="margin-bottom:5px;padding:5px;">
<center> <!-- BEGIN home -->
<a href="index.php" title="Go to the home page" >Home</a> ::
<!-- END home --> <!-- BEGIN login -->
<a href="login.php?referer=thumbnails.php%3Falbum%3Dlastupby%26cat%3D0%26uid%3D1%26page%3D9732" title="Log me in" >Login</a>
<!-- END login -->
</center> </div>
<div style="height: 10px;"></div>
<center>
<table width="950" border="0" cellpadding="5" cellspacing="5">
<tr>
<td valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<div style="height: 10px;"></div>
I don't think there is any more help that I can provide without getting access to your server.