Re: [PHP] PHP and mySQL getting smashed...

2006-05-18 Thread Richard Lynch
On Wed, May 17, 2006 6:55 am, Russell Jones 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. It depen

Re: [PHP] PHP and mySQL getting smashed...

2006-05-17 Thread Jochem Maas
Jay Blanchard wrote: [snip] 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. [/snip] Without seeing any code or table

Re: [PHP] PHP and mySQL getting smashed...

2006-05-17 Thread Alister Bulman
On 17/05/06, Dave Goodchild <[EMAIL PROTECTED]> 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

RE: [PHP] PHP and mySQL getting smashed...

2006-05-17 Thread Jay Blanchard
[snip] 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. [/snip] Without seeing any code or table information my bet woul

Re: [PHP] PHP and mySQL getting smashed...

2006-05-17 Thread Angelo Zanetti
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 t

Re: [PHP] PHP and mySQL getting smashed...

2006-05-17 Thread Dave Goodchild
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) m