[Solved] Suspended: B2Scs

[notallowed]

Account name: b2scs

Server. Stevie

Main domain: blender2scs.heliohost.org

 

My account got suspended today. I've been successfully using your free hosting service for 2 weeks now and I haven't changed anything. Also main usage of site was 2 weeks ago when I launched it. So I think that my site really wasn't the problem to server overload today. But if it was I really wanna see some data about my site load. Ah yes, I'm running Joomla 3.0 and installed few plugins which should not cause a major server load.

 

Thx for reply,

notallowed

[Shinryuu]

Your account was suspended for causing high MySQL load. I have unsuspended your account, but please try to limit the MySQL load you put on our servers as it slows down MySQL for not only your site, but MySQL for all of the other HelioHost users sharing your server.

 

If you still see the suspended page, please clear your cache.

[notallowed]

Thx for quick reply and fixing

 

But is there any chance for me to know what queries are taking most of my load?

[Krydos]

After seeing these two queries:

Count: 4  Time=365.80s (1463s)  Lock=0.01s (0s)  Rows=41.0 (164), b2scs[b2scs]@localhost
 SELECT folder AS type, element AS name, params
 FROM joomla_extensions
 WHERE enabled >= N AND type ='S' AND state >= N AND access IN (N,N,N)
--
Count: 1  Time=205.52s (205s)  Lock=0.00s (0s)  Rows=11.0 (11), b2scs[b2scs]@localhost
 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
 FROM joomla_modules AS m
 LEFT JOIN joomla_modules_menu AS mm ON mm.moduleid = m.id

it's no wonder you got suspended, but here are some other of your high load queries too:

Count: 17  Time=40.39s (686s)  Lock=0.34s (5s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 INSERT INTO `joomla_session`
 (`session_id`, `client_id`, `time`) VALUES
 ('S', N, 'S')
--
Count: 23  Time=29.61s (681s)  Lock=0.29s (6s)  Rows=0.3 (7), b2scs[b2scs]@localhost
 SELECT `data`
 FROM `joomla_session`
 WHERE `session_id` = 'S'
--
Count: 17  Time=26.71s (454s)  Lock=0.10s (1s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 UPDATE joomla_content SET hits = hits + N WHERE id = N
--
Count: 13  Time=34.71s (451s)  Lock=0.05s (0s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 INSERT INTO `joomla_updates`
 (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`detailsurl`,`infourl`) VALUES
 ('S','S','S','S','S','S','S','S','S','S')
--
Count: 16  Time=25.43s (406s)  Lock=0.32s (5s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 UPDATE `joomla_session`
 SET `data` = 'S'
 , `time` = 'S'
--
Count: 12  Time=33.21s (398s)  Lock=0.01s (0s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 DELETE
 FROM `joomla_session`
 WHERE `time` < 'S'
--
Count: 185  Time=1.82s (336s)  Lock=0.02s (3s)  Rows=25.6 (4744), b2scs[b2scs]@localhost
 SELECT `update_id`
 FROM `joomla_updates`
 WHERE element = 'S' AND type = 'S' AND client_id = 'S' AND folder = 'S'
--
Count: 10  Time=31.80s (317s)  Lock=0.11s (1s)  Rows=8.1 (81), b2scs[b2scs]@localhost
 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
 FROM joomla_modules AS m
 LEFT JOIN joomla_modules_menu AS mm ON mm.moduleid = m.id
--
Count: 4  Time=41.86s (167s)  Lock=0.16s (0s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 UPDATE joomla_categories
 SET hits = hits + N
 WHERE id = N
--
Count: 5  Time=28.03s (140s)  Lock=0.01s (0s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 SELECT `session_id`
 FROM `joomla_session`
 WHERE `session_id` = 'S' LIMIT N, N
--
Count: 3  Time=38.19s (114s)  Lock=0.00s (0s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 SELECT `extension_id`
 FROM `joomla_extensions`
 WHERE element = 'S' AND type = 'S' AND client_id = 'S' AND folder = 'S'
--
Count: 1  Time=56.90s (56s)  Lock=0.14s (0s)  Rows=1.0 (1), b2scs[b2scs]@localhost
 SELECT id, password
 FROM joomla_users
 WHERE username='S'
--
Count: 1  Time=53.11s (53s)  Lock=0.00s (0s)  Rows=1.0 (1), b2scs[b2scs]@localhost
 Select Distinct SQL_CALC_FOUND_ROWS record.* From joomla_facileforms_records As record   Order By record.submitted ASC Limit N, N
--
Count: 1  Time=40.48s (40s)  Lock=0.00s (0s)  Rows=1.0 (1), b2scs[b2scs]@localhost
 SELECT params
 FROM joomla_extensions
 WHERE folder = "S" AND element ="S"
--
Count: 1  Time=36.70s (36s)  Lock=0.00s (0s)  Rows=41.0 (41), b2scs[b2scs]@localhost
 SELECT folder AS type, element AS name, params
 FROM joomla_extensions
 WHERE enabled >= N AND type ='S' AND state >= N AND access IN (N,N,N,N)

 

[notallowed]

Woah thx for great report!

 

I changed sessions settings in Joomla now to None, so all queries related to sessions now should not be executed.

Still I would like too see after 24 hours what kind of quieries are now taking most of the load if possible

 

Thx notallowed

[Krydos]

Woah thx for great report!

Yeah, no problem. It is extra work for us to provide reports like this so we only provide the extra information if people ask. That said, I do wish more people were willing to try to fix things. Most users are just like "i suspnededed!!! k thanx luv u" and then they just get suspended again since they didn't change anything.

Still I would like too see after 24 hours what kind of quieries are now taking most of the load if possible

Create another post in customer service for inquiries related to load. If you tack it onto this topic that is already marked as [solved] we are less likely to notice it. We keep up to 48 hours of MySQL load data at any time.

[notallowed]

Thx for that tip. I will ask tommorow in customer service for new report.

[notallowed]

Unfortunately hi again,

I unlocked this topic as my account got suspended again. I assume that Joomla again took up too much resources in MySQL queries like last time. If that is true and there is no help for my site anymore then please unsuspend my site for at least 24 hours so I can make backup and then I will be gone. If not then thank you again for unsuspending ;)/&--#62;

Take care,

notallowed

 

EDIT: never mind, didn't checked my email before posting here. My webpage was suspended due to inactivity. So I am closing this topic again