EE optimization and dedicated server optimatization
Development and Programming
Hello there,
We are running an incoming website on EE 2.5.1 who will need to have many mysql connections with the database in the same time (in part due to online voting during 4 hours).
I’m wondering if there are some optmizations to make in the EE Panel in order to avoid error memory messages or long queuing when the traffic raised if the website has many users in the same time.
This website may hold 15000 subscribers in the database, and for times when traffic raise, perhaps 200 (don’t know if it’s important) MySql simultaneous max users connections (in the same second or millisecond indeed). I just wondered if EE would handle it, or if i have to change something in the EE parameters ? if yes, what do i have to modify ?
For this project, we have a dedicated server only for this website (Hard Drive : 100Go, RAM memory : 4Go, Xeon QuadCore 64 bits, bandwith 25 Mb/s minimum up to 100 Mb/s) The server is running under Debian 6 Squeeze, Apache 2, Php 5.3.3, MySQL 5.1.6 Is it also risky to make a tuning mysql server side ?
Best Crem’
Anybody, here, to advise me on some EE optimizations for php requests and connections to database ?
Thanks Crem’
Hi Crem’,
How you optimize ExpressionEngine is dependent on the needs of the project. From your description, the most important thing you can do is have a dedicated database server as well.
If you are expecting periods of peak demand, you would want the database to be on separate hardware than the web server.
Performance tuning is a topic better suited to the Development and Programming forum, so I’ll move this discussion over there.
Cheers,