Re: PHP and mySQL getting smashed...
| From: | Jochem Maas | Date: | Wed, 17 May 2006 14:31:07 +0000 |
| Subject: | Re: PHP and mySQL getting smashed... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-236347@lists.php.net to get a copy of this message | ||
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 information my bet would be that none of your tables are indexed properly.and/or that the OP is using some killing JOINS in his queries - these often have a detremental effect regardless of indexes.