Mysql overload - several eZp site on a server ?

Previous topic

Setup & design

Next topic

Author	Message
laurent le cadet	Friday 12 May 2006 5:29:52 am Hi, I have about 20 site running on the same server. This server is Intel(R) Xeon(TM) CPU 2.40GHz 2388.566 MHz with 2Go RAM. Actually I have to faced a regular Mysql High Threads : Uptime: 92063 Threads: 146 Questions: 1429589 Slow queries: 3 Opens: 92752 Flush tables: 1 Open tables: 64 Queries per second avg: 15.528 The threads curve grows up regulary (sometime till crash) a go down abruptly. Is there a fine tunning I messed ? Regards. Laurent.
Karl Latiss	Sunday 14 May 2006 12:32:39 am You will find a good performance increase when separating out your web and database servers. One of my web servers (2 x 3 GHz Xeon) has 50 - 60 eZ sites with load at around 1.0. A separate database server is under not much load and so could handle another web server without too much trouble. Atvert Systems http://www.atvert.com.au

Author

Message

laurent le cadet

Friday 12 May 2006 5:29:52 am

Hi,

I have about 20 site running on the same server.
This server is Intel(R) Xeon(TM) CPU 2.40GHz 2388.566 MHz with 2Go RAM.

Actually I have to faced a regular Mysql High Threads :

Uptime: 92063
Threads: 146
Questions: 1429589
Slow queries: 3
Opens: 92752
Flush tables: 1
Open tables: 64
Queries per second avg: 15.528

The threads curve grows up regulary (sometime till crash) a go down abruptly.

Is there a fine tunning I messed ?

Regards.

Laurent.

Karl Latiss

Sunday 14 May 2006 12:32:39 am

You will find a good performance increase when separating out your web and database servers. One of my web servers (2 x 3 GHz Xeon) has 50 - 60 eZ sites with load at around 1.0. A separate database server is under not much load and so could handle another web server without too much trouble.

Atvert Systems
http://www.atvert.com.au