Re: PHP and mySQL getting smashed...
| From: | Angelo Zanetti | Date: | Wed, 17 May 2006 12:31:04 +0000 |
| Subject: | Re: PHP and mySQL getting smashed... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-236337@lists.php.net to get a copy of this message | ||
perhaps post some code so we can look at how you doing your queries...
HTH
Angelo Zanetti
Z Logic
www.zlogic.co.za
[c] +27 72 441 3355
[t] +27 21 469 1052
[f] +27 86 681 5885
Dave Goodchild wrote:
I have a site that is getting 30K+ traffic daily and it is smashing mySQL -any ideas on what to do to make the mysql connections more efficient, or anything in general. No bandwidth issue here, just the server getting killed. ...I may be wrong but using persistent connections (mysql_pconnect) mayhelp. Also, optimise your tables and use the explain command to see how efficient your queries are.