1
FaYsSaL
my xoops consume too much ressources!
  • 2006/9/13 15:58

  • FaYsSaL

  • Not too shy to talk

  • Posts: 115

  • Since: 2006/1/2 2


hi there,today my hosting have contacted me, they says that my site have tooo many conexions to the MySQL databases and it makes server load
is there some1 who can help me with this
thx in advance!

2
Swain
Re: my xoops consume too much ressources!
  • 2006/9/13 16:31

  • Swain

  • Not too shy to talk

  • Posts: 198

  • Since: 2006/6/27


Are you using the cache on everything so that XOOPS does not have to query the database everytime???

3
davidl2
Re: my xoops consume too much ressources!
  • 2006/9/13 16:41

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


Also 2.0.14 upwards apparently uses less resources, so this may also help. *

*Standard advice on backing up site & data applies naturally!

4
Xman04
Re: my xoops consume too much ressources!
  • 2006/9/13 17:09

  • Xman04

  • Not too shy to talk

  • Posts: 180

  • Since: 2004/7/12


Some shared hosting plans have very severe limitations on how many simultaneous database connections can be opened at any one time. Unfortunately, this is rarely ever mentioned when they are promoting their plans. They promote the plentiful drive space and bandwidth, which is very appealing if you have at least a moderate traffic site. However, increasing traffic means an increasing need for more available MySQL connections.

You may want to ask your hosting service about how many concurrent database connections they allow, and if they have an upgraded plan that allows more connections. Although, they my try to sell you on a semi-dedicated, dedicated, or virtual server option. Those are good options for many reasons, but they become more costly.

You may also consider moving to another shared hosting service that is more generous with their database connections. Hosting services do vary quite a bit regarding how my connections they will allow.

On the other hand (as others mentioned), using more of the caching features and upgrading to at least 2.0.14 my solve your problem (temporarily at least). Although, there still may come a point where your traffic becomes so heavy that you need to move to a dedicated or other option.

Dave

5
Will_H
Re: my xoops consume too much ressources!
  • 2006/9/13 17:18

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


General rule of thumb.

100+ users = VPS+

6
FaYsSaL
Re: my xoops consume too much ressources!
  • 2006/9/13 17:39

  • FaYsSaL

  • Not too shy to talk

  • Posts: 115

  • Since: 2006/1/2 2


thx for the answers
Quote:
Page chargée en 1.05 Seconds | 88 Queries

isnt tooo much?
@Biteronboard actually 200visits @ the sametime and its ok with a shared plan :-p
@davidl2 im planing a migrating to 2.0.15 but im not sure about it :-s im affraid of that version .
@swain im using cache for someblocks.

7
Will_H
Re: my xoops consume too much ressources!
  • 2006/9/13 18:35

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


....if you say so.

8
davidl2
Re: my xoops consume too much ressources!
  • 2006/9/13 22:17

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


I'd suggest if you're weary about upgrading to test locally, using something like XAMPP, to give you an idea if everything will behave properly.

9
FaYsSaL
Re: my xoops consume too much ressources!
  • 2006/9/14 9:44

  • FaYsSaL

  • Not too shy to talk

  • Posts: 115

  • Since: 2006/1/2 2


Quote:

davidl2 wrote:
I'd suggest if you're weary about upgrading to test locally, using something like XAMPP, to give you an idea if everything will behave properly.

thx davidl2 for the answer :)
i've a test server !

on the yaxs i've found this site :http://www.et-main.com/

what about this connections is it true?

0.489 Seconds | 1 Queries

10
Will_H
Re: my xoops consume too much ressources!
  • 2006/9/14 12:31

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


lol, no.

Read

That page timer does not work unless debug is on in 2.0.15

The time is right but I actually do around 40Q a page.

Login

Who's Online

201 user(s) are online (106 user(s) are browsing Support Forums)


Members: 0


Guests: 201


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits