Slow admin area

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Post Reply
johnboyuk1
Forum Members
Forum Members
Posts: 152
Joined: Mon Nov 26, 2018 3:09 pm

Slow admin area

Post by johnboyuk1 »

Hi all

I'm having some issues with a couple of sites I have running CMSMS where the backend/admin has become extremely slow. For example, clicking on a page in the 'content manager' it sometimes takes about 15 seconds to load the admin page, likewise for trying to save a change. The front end of the site seems to be running ok.

My host has recently upgraded various things on the servers so suspect its some how connected - but they arent very helpful. They suggested it might be something to to with a Perl upgrade? Is there any issue/incompatibility I need to be aware of with CMSMS? I cant see any errors on my web hosting error log so not sure what/where the issue would be.

Thanks for any advice...
User avatar
Jo Morg
Dev Team Member
Dev Team Member
Posts: 1836
Joined: Mon Jan 29, 2007 4:47 pm

Re: Slow admin area

Post by Jo Morg »

johnboyuk1 wrote: Thu Nov 18, 2021 12:12 pm My host has recently upgraded various things on the servers so suspect its some how connected - but they arent very helpful. They suggested it might be something to to with a Perl upgrade? Is there any issue/incompatibility I need to be aware of with CMSMS? I cant see any errors on my web hosting error log so not sure what/where the issue would be.
There is no Perl dependency or use on CMSMS core neither there is on any of the modules I know of. Not to say that I know all of them, but I have, one way or another, tried or seen some of the code of most of them. Even if there was a module dependent on Perl it's not likely that it would slow the site down as much as you are experiencing, at least not to my knowledge. Being two different technologies they don't bridge with each other other than by external means usually CURL or similar. In any case not very probable.
What I recommend is to try to see if there is different behaviors in different backend pages and which, use debug mode (see config.php documentation) to display some extra information too, and try to see which step(s) of the loading process are taking too long. Then go from there.
"There are 10 types of people in this world, those who understand binary... and those who don't."
* by the way: English is NOT my native language (sorry for any mistakes...).
Code of Conduit | CMSMS Docs | Help Support CMSMS
My developer Page on the Forge
GeekMoot 2015 in Ghent, Belgium: I was there!
GeekMoot 2016 in Leicester, UK: I was there!
johnboyuk1
Forum Members
Forum Members
Posts: 152
Joined: Mon Nov 26, 2018 3:09 pm

Re: Slow admin area

Post by johnboyuk1 »

Thanks for the info Jo. How do i see which steps of the loading process are taking the time? Ive taken a look in the dev tools of Safari, and not sure if i'm reading to correctly, or its meaningful, but in the timeline it shows these to things as talking a long time:

cms_js_setup.php
module interface.php

It seems all back-end admin pages are slow to load, and slow to save changes etc.
User avatar
Jo Morg
Dev Team Member
Dev Team Member
Posts: 1836
Joined: Mon Jan 29, 2007 4:47 pm

Re: Slow admin area

Post by Jo Morg »

https://docs.cmsmadesimple.org/troubles ... debug-mode
When you enable it there will be some verbose display of the steps CMSMS takes to render a page, at least to some extent. Usually useful data in debugging bottlenecks in a server or in the code. Also mind you that forms submission will take an extra step to allow for more data to be displayed. DB may take some time for instance in case of DB server software not being in the same physical server and poorly configured. There are a number of causes to a slow backend including firewall settings etc... It may not be easy to trace it but it's not also a typical one solution fits all kind of situation.
"There are 10 types of people in this world, those who understand binary... and those who don't."
* by the way: English is NOT my native language (sorry for any mistakes...).
Code of Conduit | CMSMS Docs | Help Support CMSMS
My developer Page on the Forge
GeekMoot 2015 in Ghent, Belgium: I was there!
GeekMoot 2016 in Leicester, UK: I was there!
User avatar
DIGI3
Dev Team Member
Dev Team Member
Posts: 1292
Joined: Wed Feb 25, 2009 4:25 am
Location: Victoria, BC

Re: Slow admin area

Post by DIGI3 »

I've had this issue with a few hosts adding a limit on the number of processes/iops. Sometimes there are clues in the error or access logs, like DENY due to rate limit etc. If you have cPanel or similar you may be able to see the limits, typically the problems start occurring if they limit it to 100 or fewer operations (I've seen hosts set it to 50 and the backend became unusable - solution was to find a better host).

The admin area isn't particularly efficient regarding number of processes or database requests, but it shouldn't be an issue on a decent host.
Not getting the answer you need? CMSMS support options
scooper
Forum Members
Forum Members
Posts: 242
Joined: Fri Dec 09, 2005 12:36 pm
Location: Marlow, UK

Re: Slow admin area

Post by scooper »

Are you up to date on your CMSMS versions?

We had an issue on older versions of the admin template where there was a dropdown list of directories that took an age to generate on our cloud server.

Discussion of that here:
viewtopic.php?f=8&t=73938&p=325575
johnboyuk1
Forum Members
Forum Members
Posts: 152
Joined: Mon Nov 26, 2018 3:09 pm

Re: Slow admin area

Post by johnboyuk1 »

yeah, all up to date. Must be a hosting issue but having trouble getting it resolved. odd thing is I have quite a few CMSMS sites hosted with the same host and only some of them are having the problem
johnboyuk1
Forum Members
Forum Members
Posts: 152
Joined: Mon Nov 26, 2018 3:09 pm

Re: Slow admin area

Post by johnboyuk1 »

The hosting company are suggesting its an issue with CMSMS not running correctly with newer versions of Apache/PHP etc.. saying CMSMS latest version is over a year old so considered 'legacy' ?!

I've enabled debug mode but not really sure what I'm looking for....

Code: Select all

Debug: (30.422502) - (net usage: 1005560) - (peak: 1401984) Initialize Database
Debug: (30.425743) - (net usage: 1301416) - (peak: 1697840) Done Initializing Database
Debug: (30.425768) - (net usage: 1301576) - (peak: 1698000) initialize internal global cache
Debug: (30.445839) - (net usage: 1766752) - (peak: 2228344) done initializing global cache
Debug: (30.445863) - (net usage: 1766216) - (peak: 2228344) Loading Modules
Debug: (30.459472) - (net usage: 4128448) - (peak: 4524872) SET @CG_ZEROTIME = NOW() - INTERVAL 150 YEAR,@CG_FUTURETIME = NOW() + INTERVAL 5 YEAR
Debug: (30.472248) - (net usage: 5068864) - (peak: 5465288) SELECT username, password, active, first_name, last_name, admin_access, email FROM cms_users WHERE user_id = 1
Debug: (30.531269) - (net usage: 5068776) - (peak: 5465312) SELECT preference,value FROM cms_userprefs WHERE user_id = 1
Debug: (30.552622) - (net usage: 6648200) - (peak: 7044624) End of Loading Modules
Debug: (30.553165) - (net usage: 6651216) - (peak: 7047640) Initialize Smarty
Debug: (30.553177) - (net usage: 6651376) - (peak: 7047800) Done Initialing Smarty
Debug: (30.557356) - (net usage: 7294064) - (peak: 7690488) SELECT group_id FROM cms_user_groups WHERE user_id = 1
Debug: (30.559039) - (net usage: 7303808) - (peak: 7700232) SELECT * FROM cms_locks WHERE type = 'content'
Debug: (30.559575) - (net usage: 7303736) - (peak: 7700232) SELECT user_id, username, password, first_name, last_name, email, active, admin_access
                      FROM cms_users ORDER BY username LIMIT 0, 10000
Debug: (30.560401) - (net usage: 7309056) - (peak: 7705480) SELECT * FROM cms_layout_designs ORDER BY name ASC
Debug: (30.563347) - (net usage: 7609200) - (peak: 8005624) SELECT SQL_CALC_FOUND_ROWS tpl.id FROM cms_layout_templates tpl
              LEFT JOIN cms_layout_tpl_type type ON tpl.type_id = type.id ORDER BY tpl.name asc LIMIT 0, 1000
Debug: (30.563623) - (net usage: 7628400) - (peak: 8024824) SELECT FOUND_ROWS() LIMIT  1
Debug: (30.564133) - (net usage: 7635376) - (peak: 8031800) SELECT tpl_id,design_id FROM cms_layout_design_tplassoc
                   WHERE tpl_id IN (15,30,2,18,31,26,23,25,21,37,39,38,35,36,33,34,27,29,14,13,10,12,20,19,24,22,32) ORDER BY tpl_id
Debug: (30.565167) - (net usage: 7738328) - (peak: 8134752) SELECT * FROM cms_layout_templates WHERE id IN (15,30,2,18,31,26,23,25,21,37,39,38,35,36,33,34,27,29,14,13,10,12,20,19,24,22,32)
Debug display of 'Fetch module_file_tpl:CMSContentManager;defaultadmin.tpl start':(30.56572) - (net usage: 8018368) - (peak: 8414824)
Debug display of 'Start Load Smarty Plugin cms_action_url/function':(30.597263) - (net usage: 9304024) - (peak: 9906160)
Debug display of 'End Load Smarty Plugin cms_action_url/function':(30.597297) - (net usage: 9305480) - (peak: 9906160)
Debug display of 'Fetch module_file_tpl:CMSContentManager;defaultadmin.tpl end':(30.654497) - (net usage: 9396536) - (peak: 9984360)
Debug: (1.0999999999983E-5) - (net usage: 9370648) - (peak: 9984360) before theme load
Debug: (2.599999999997E-5) - (net usage: 9370936) - (peak: 9984360) after theme load
Debug: (0.00062399999999996) - (net usage: 10018664) - (peak: 10473664) before populate admin navigation
Debug: (0.005757) - (net usage: 10747720) - (peak: 11144144) before menu items
Debug: (0.005899) - (net usage: 10765536) - (peak: 11161960) after menu items
Debug: (0.0059359999999999) - (net usage: 10769536) - (peak: 11165952) before system modules
Debug: (0.005976) - (net usage: 10775088) - (peak: 11171512) before non system module menu items
Debug: (0.006002) - (net usage: 10777992) - (peak: 11174416) after non system module menu items
Debug: (0.0067339999999999) - (net usage: 10801776) - (peak: 11198192) after populate admin navigation

User avatar
DIGI3
Dev Team Member
Dev Team Member
Posts: 1292
Joined: Wed Feb 25, 2009 4:25 am
Location: Victoria, BC

Re: Slow admin area

Post by DIGI3 »

Software doesn't just stop working or get slower because it's over 1 year old. What version of PHP are you running? What happens if you go back a version?
Not getting the answer you need? CMSMS support options
johnboyuk1
Forum Members
Forum Members
Posts: 152
Joined: Mon Nov 26, 2018 3:09 pm

Re: Slow admin area

Post by johnboyuk1 »

I know - i thought that was a stupid comment, I guess they were saying they've updated their systems so the CMSMS may not be compatible as its a bit older... sounds like BS though.

Ive got sites on both php 5.6 and 7.2 ,,, and different versions of CMSMS (2.2.X)
Post Reply

Return to “CMSMS Core”