Excesive Consume Of SQL Recurses

The time now is Sat 23 Aug, 2025 00:53 • All times are UTC + 1 Hour [DST enabled]

Excesive Consume Of SQL Recurses

Page 1 of 1

Zuker

Joined: August 2006
Posts: 2134
Location:

Excesive Consume Of SQL Recurses

My Hosting wrote:

your account has been suspended for excesive consume of sql recurses

+--------+----------------+-----------+---------------+---------+------+-------+------------------+
| Id     | User           | Host      | db            | Command | Time | State | Info             |
+--------+----------------+-----------+---------------+---------+------+-------+------------------+
| 291848 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 5864 |       |                  |
| 291849 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 5864 |       |                  |
| 292018 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 5660 |       |                  |
| 292019 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 5660 |       |                  |
| 292274 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 5459 |       |                  |
| 292275 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 5458 |       |                  |
| 292602 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 5256 |       |                  |
| 292603 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 5255 |       |                  |
| 292861 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 5052 |       |                  |
| 292867 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 5051 |       |                  |
| 295347 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 1791 |       |                  |
| 295348 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 1791 |       |                  |
| 295354 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 1782 |       |                  |
| 295355 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 1782 |       |                  |
| 295460 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 1589 |       |                  |
| 295572 | mh000086_zuker | localhost | mh000086_foro | Sleep   | 1388 |       |                  |
| 297879 | root           | localhost |               | Query   | 0    |       | show processlist |
+--------+----------------+-----------+---------------+---------+------+-------+------------------+

Does anyone got an idea of what can i do/tell to my hosting?
The Kuka told me in phpb-es that if i change some settings in the ACP, maibe i'll "fix" this problem, consuming less resources from de server. But i can't acces to my ACP, 've got only acces to my ddbb with phpmyadmin.

Thanks
Zuker

____________
? Zuker - EDDB - LPM - Sharefields

#1 Fri 11 Aug, 2006 17:09

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

difus Joined: August 2006 Posts: 763 Location:	Re: Excesive Consume Of SQL Recurses may be you have more databases? change the hosting ____________ *VOLVO CLUB*
#2 Fri 11 Aug, 2006 17:25

Zuker Joined: August 2006 Posts: 2134 Location: BA	Re: Excesive Consume Of SQL Recurses The easy fix is to chage my hosting. But i think that maibe are other ways of fixing it ____________ ? Zuker - EDDB - LPM - Sharefields
#3 Fri 11 Aug, 2006 17:27

Zuker Joined: August 2006 Posts: 2134 Location: BA	Re: Excesive Consume Of SQL Recurses i've got two ddbb, but the problem is in the one i've got my xs:S ____________ ? Zuker - EDDB - LPM - Sharefields
#4 Fri 11 Aug, 2006 17:28

Tom

Joined: August 2006
Posts: 230
Location:

Dresden

Re: Excesive Consume Of SQL Recurses

MG posted an article on XS.com a while ago on how to reduce database load. However, in order to set it up, you need access to the ACP.

Let's see if I can put it back together:

ACP -> Configuration -> Database

Disable Logins Recording: Yes
Database Optimize: No (can be done manually, if needed)
Site History: No (Extended statistics that should be disabled)
Caching of the board's Configuration: Yes

ACP -> Configuration -> XS

Protect Main Admin Account: No
Deactivate Force Topic Read: Yes

____________
No support via PM or E-Mail!
FAP 3, yeah baby, yeah!

#5 Fri 11 Aug, 2006 19:44

Hakkinen Joined: August 2006 Posts: 57 Location:	Re: Excesive Consume Of SQL Recurses Do what Tom has posted. Other thing...the portal is what cause overloading, deactivate, who's on line and statistics from the portal, just leave what is necessary... I did that and no problem so far.
#6 Fri 11 Aug, 2006 20:58

Tom Joined: August 2006 Posts: 230 Location: Dresden	Re: Excesive Consume Of SQL Recurses Or get another provider without those stupid restrictions... ____________ No support via PM or E-Mail! FAP 3, yeah baby, yeah!
#7 Fri 11 Aug, 2006 21:47

Hakkinen Joined: August 2006 Posts: 57 Location:	Re: Excesive Consume Of SQL Recurses Tom wrote: [View Post] Or get another provider without those stupid restrictions... is easy, bus the $$$$ is the problem sometimes All hosting companies have "stupid restrictions" the difference that some of that companies are not so bad likeZuker has
#8 Fri 11 Aug, 2006 22:43

Zuker Joined: August 2006 Posts: 2134 Location: BA	Re: Excesive Consume Of SQL Recurses Thanks Tom, i've just finish discussing with my provider and finally give me my web back. i've change what you told me before. If i noticed any changes i'll post them here ____________ ? Zuker - EDDB - LPM - Sharefields
#9 Sat 12 Aug, 2006 00:18

Mighty Gorgon

Luca Libralato

Joined: August 2006
Posts: 7192
Location:

Borgo San Michele

Re: Excesive Consume Of SQL Recurses

Zuker wrote: [View Post]
Does anyone got an idea of what can i do/tell to my hosting?
The Kuka told me in phpb-es that if i change some settings in the ACP, maibe i'll "fix" this problem, consuming less resources from de server. But i can't acces to my ACP, 've got only acces to my ddbb with phpmyadmin.

Thanks
Zuker

Do what Tom suggested you... and then disable anything you don't need in CONFIG section:

Shoutbox on Index and in Who Is Online
Statistics on Index
Birthdays on Index
Links on Index
Disable Thanks Topic
Disable Topics Ratings
Disable Topics Notifications
Disable Access to pages you're not using (this could save you enormous resources)
Disable Statistics page
In Portal use only the blocks you really need and CACHE all blocks that could be CACHED... such as text only blocks or rarely updated blocks.

I'll try to write another How To with all these suggestions.

Remember that most of XS recursive SQL are cached, so XS should be optimized to use a minimum amount of extra SQL... but of course there are so many features... you should explore ACP and try to turn off all that could be turned off.

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON

#10 Sat 12 Aug, 2006 11:26

Zuker Joined: August 2006 Posts: 2134 Location: BA	Re: Excesive Consume Of SQL Recurses Thanks again anywhere i am studyng moving from my actual server ____________ ? Zuker - EDDB - LPM - Sharefields
#11 Sun 13 Aug, 2006 02:47

Page 1 of 1

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Sat 23 Aug, 2025 00:53 • All times are UTC + 1 Hour [DST enabled]

Permissions List

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events