CMS Made Simple Forums

Hi,

We are currently managing around 5 CMSMS sites and one Joomla site (our own). All sites are located on the same webprovider. 4 of our pages runs CMSMS 1.8.2 and one newly installed runs latest version (1.9.1). The 1.8.2- pages are slightly modified, mostly back-end interface and some of the modules..

Theres some background facts, now to the actual problem.

I experience some kind of freezing / lag, both back and front- end. When I access a page it could take up to 1-2 minutes before processing any data OR it returns time out. As I said, this happens both back and in front.

So, the next funny thing is when this happens I try ping the host. No problemo, it responds.
I also tried to connect to the host FTP.. and guess what, it didnt work. I recieved a time out.

This actually COULD be a coincidence since the host says they had some network issues that day.

I dont really know where I should start since the webprovider aint that helpful. Usually their support is really good. Dunno what happend. Is there any kind of performence tests I could run? Im really confused. All kind of help is useful.

Thanks in advance, cheers.

John

As a webhosting provider I would be interested in the following information:

- Does the page always freeze? Or was it just an incident that day?
- Did the joomla website also freeze? Other website on that server?

If it was just that one time, it was a hickup on the server of in the network somewhere.

Thanks for your reply.

- Does the page always freeze? Or was it just an incident that day?
- Did the joomla website also freeze? Other website on that server?

1) It always, sometimes freeze if you understand. This problem has be going on for months.
Sometimes everything works great for 1 hour and for the next 2 hours of work I get like
20 "hickups", "Freezes" etc.

2) The Joomla website also freezes. Last month we re-designed the whole Joomla page
and oh boy, it took a while.

Sorry, forgot to mention these things in my first post.

Thanks again

Inexpensive host promising unlimited hosting/sites/bandwidth on a shared server?...

Nope,

This is a "expensive" host. Voted Swedens best host for 3 years in a row. Hosting
a large amount of popular and big Swedish sites.

NOTE:

Just sent a error report to the host support and waiting for a reply. Will get with feedback here.

Since I dont know if it could be anything with CMSMS (Tho', I think not.) I still want to keep this thread open for feedback.

Thanks

Just got some info. Would this cause any known troubles?

Current PHP Version: 5.2.14

PHP Configuration:
Maximum Post Size: 48M
Maximum Upload Size: 48M
PHP Memory Limit: 64M
PHP Safe Mode: Off
Maximum Execution Time: 60 seconds
Session Save Path: /storage/configuration/php_session_path
MySQL Server Version: 5.0.51a-3ubuntu5.4-log

Server Software: LiteSpeed
Server API: LITESPEED
Server OS: Linux v 2.6.32-25-server on x86_64 architecture

My best guess is that it's a server problem. Maybe to many customers on a server or one of the customers is causing a big load on the server.

Do you have shell access? If you do, try to access the server and check what the load on the server is.

Turn on debug mode... The report will tell you what actions are taking what time.

Thanks, here it is. The queries take some time..

Note, this happens on all of my pages. And this aint no heavy site. Not at all. Its
mainly a logo, menu, 4-6 rows of text and maybe.. maybe a picture.

Generated in 4,554916 seconds by CMS Made Simple using 27 SQL queries and 10540176 bytes of memory (peak memory usage was 11036112)
Debug: (0.224383) - (997912)
loading smarty
Debug: (0.291381) - (1435808)
loading adodb
Debug: (0.345721) - (1580408)
loading page functions
Debug: (0.375962) - (1908472)
loading content functions
Debug: (0.426358) - (2229064)
loading pageinfo functions
Debug: (0.497141) - (2283504)
loading translation functions
Debug: (0.546196) - (2381648)
loading events functions
Debug: (0.575319) - (2516128)
loading php4 entity decode functions
Debug: (0.623392) - (2843520)
done loading files
Debug: (1.046363) - (3964208)
(mysql): SET NAMES 'utf8'
Debug: (1.471699) - (3991000)
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs
Debug: (2.034431) - (4108688)
(mysql): SELECT * FROM cms_userplugins
Debug: (2,234653) - (4792032)
(mysql): SELECT * FROM cms_modules WHERE admin_only = 0 AND active = 1 ORDER by module_name
Debug display of 'End of include':(3,261418) - (7118224)
Debug: (3,364512) - (7354368)
(mysql): SELECT sitepref_value from cms_siteprefs WHERE sitepref_name = 'pseudocron_lastrun'
Debug: (3,365325) - (7356888)
(mysql): UPDATE cms_siteprefs SET sitepref_value = '1290666449' WHERE sitepref_name = 'pseudocron_lastrun'
Debug display of 'Load Content Operations':(3,365406) - (7310880)
Debug display of 'End Load Content Operations':(3,413103) - (8227624)
Debug: (3,457401) - (8231704)
(mysql): SELECT content_id FROM cms_content WHERE default_content = 1
Debug: (3,513121) - (8231208)
(mysql): SELECT c.content_id, c.content_name, c.content_alias, c.menu_text, c.titleattribute, c.hierarchy, c.metadata, c.id_hierarchy, c.prop_names, c.create_date AS c_create_date, c.modified_date AS c_date, c.cachable, c.last_modified_by, t.template_id, t.encoding, t.modified_date AS t_date FROM cms_templates t INNER JOIN cms_content c ON c.template_id = t.template_id WHERE (c.content_alias = '15' OR c.content_id = '15') AND c.active = 1
Debug: (3,513972) - (8234856)
(mysql): SELECT MAX(modified_date) AS thedate FROM cms_content c
Debug display of 'Start Loading Hierarchy Manager':(3,514267) - (8230240)
Debug display of 'starting tree':(3,514293) - (8231192)
Debug: (3,550794) - (8457336)
file needs loading
Debug display of 'ending tree':(3,559103) - (8496048)
Debug display of 'End Loading Hierarchy Manager':(3,55914) - (8490440)
Debug: (3,559162) - (8490952)
start findNodeByTag
Debug: (3,559198) - (8491312)
end findNodeByTag
Debug: (3,560127) - (8497456)
(mysql): SELECT * FROM cms_content WHERE content_id = '15'
Debug: (3,576713) - (8790560)
load from data is loading properties
Debug: (3,598464) - (8796024)
(mysql): SELECT * FROM cms_content_props WHERE content_id = '15'
Debug: (3,688175) - (8982272)
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '23'
Debug: (3,807002) - (10026744)
(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
        INNER JOIN cms_events e ON e.event_id = eh.event_id
        ORDER BY eh.handler_order ASC
Debug: (4,049665) - (10107664)
start findNodeByTag
Debug: (4,049726) - (10107992)
end findNodeByTag
Debug display of 'Start of Menu Manager Display':(4,179512) - (10321104)
Debug: (4,181218) - (10336128)
(mysql): SELECT * FROM cms_content WHERE content_id = '56'
Debug: (4,181433) - (10367856)
load from data is loading properties
Debug: (4,192728) - (10373408)
(mysql): SELECT * FROM cms_content_props WHERE content_id = '56'
Debug: (4,19365) - (10374248)
(mysql): SELECT * FROM cms_content WHERE parent_id = '56' ORDER BY hierarchy
Debug: (4,195108) - (10466536)
(mysql): SELECT * FROM cms_content WHERE content_id = '61'
Debug: (4,195308) - (10497936)
load from data is loading properties
Debug: (4,20342) - (10503256)
(mysql): SELECT * FROM cms_content_props WHERE content_id = '61'
Debug: (4,204467) - (10504216)
(mysql): SELECT * FROM cms_content WHERE parent_id = '61' ORDER BY hierarchy
Debug: (4,206068) - (10658280)
(mysql): SELECT * FROM cms_content WHERE content_id = '67'
Debug: (4,206264) - (10689648)
load from data is loading properties
Debug: (4,221684) - (10694968)
(mysql): SELECT * FROM cms_content_props WHERE content_id = '67'
Debug: (4,222668) - (10697552)
(mysql): SELECT * FROM cms_content WHERE content_id = '68'
Debug: (4,223026) - (10728952)
load from data is loading properties
Debug: (4,223984) - (10734272)
(mysql): SELECT * FROM cms_content_props WHERE content_id = '68'
Debug: (4,301772) - (10870808)
(mysql): SELECT content from cms_module_templates WHERE module_name = 'MenuManager' and template_name = 'BeautifulNight : BeautifulNight-MainMenu'
Debug: (4,335979) - (10869112)
(mysql): SELECT module_name,template_name,modified_date
                            FROM cms_module_templates
Debug display of 'End of Menu Manager Display':(4,367577) - (10814712)
Debug: (4,367825) - (10754872)
start findNodeByTag
Debug: (4,36786) - (10755200)
end findNodeByTag
Debug display of 'Start of Menu Manager Display':(4,392502) - (10819312)
Debug: (4,392625) - (10821672)
start findNodeByTag
Debug: (4,392683) - (10822000)
end findNodeByTag
Debug: (4,3935) - (10827728)
(mysql): SELECT content_id FROM cms_content WHERE hierarchy = '00001'
Debug: (4,393566) - (10823376)
start findNodeByTag
Debug: (4,393599) - (10823704)
end findNodeByTag
Debug display of 'End of Menu Manager Display':(4,393642) - (10823912)
Debug: (4,536929) - (10767272)
(mysql): SELECT DISTINCT A.css_id,A.media_type,B.assoc_order
                      FROM cms_css A, cms_css_assoc B
                    WHERE A.css_id = B.assoc_css_id
                      AND B.assoc_type = 'template'
                      AND B.assoc_to_id = '23'
                    ORDER BY B.assoc_order
Debug: (4,53722) - (10702760)
calling module TinyMCE from event ContentPostRender

Ran the site once more with Debug mode. Now suddenly its quicker.. Took about 0,9 sec to load the page.

Even though the SQL queries are taking a bunch of time, it seems that the entire server is slow.. 1.47 seconds before the first query just isn't right...

Do you have SSH access? If so, run the command 'uptime' which will tell you the current load on your server.

% uptime
22:50:05 up 13 days,  6:18,  1 user,  load average: 0.22, 0.30, 0.24

The output above indicates that my server has a 22% load.

Sadly I dont have SSH access.

Tried doing this with php, using both passthru() and system(). Both is Disabled.

Is there another way?

Just recieved a mail from the webhost support. They want me to traceroute the domains.
In first place they don't think its something wrong on their side..

And If I recall it right. Using debug has nothing to do with me as client. Since the debug is executed when accessing the page and counts from that moment? Am I right?

The traceroute will only tell you the crazy path it took to deliver the web page from their servers to your house. The debug information tells you how long their servers took to generate a page before delivering it.

It shouldn't take a full second to do a simple query such as the one below from your output.
That same query on my host took 2 thousanths of a second. (on inexpensive shared hosting)
http://teamwishbone.com/1.9/?debug=1


4.5 seconds isn't rediculously intolerable, though it should be less than 0.5 seconds. I used to have an issue with my previous host (GoDaddy) when my pages took 20-30 seconds to load. Support was useless: "You need to optimize your queries, etc" even though I pointed out to them that simple queries were taking over a second each.

Thanks alot Wishbone,

I've now sent a fully detailed mail to the host provider. So they don't have much of a choice other than try fix the problem. My company purchase ~ 15 sites at their service so..

Again, thanks alot.