Help with extremely slow queries - PLEASE!

2001-02-14 Thread Neil Streeter
Hi all, I've a bit of an issue with mysqld -- errr is it? Here's the configuration Dell PowerEdge 6300 - 1GB ram (actually 2GB but no bigmem support at the moment - I'll get to that) - RH linux 6.1 running 2.2.12-smp (needs updating, I know - but hard to find good 'down time') - 4 10gig

Re: Help with extremely slow queries - PLEASE!

2001-02-14 Thread Steve Ruby
You may be looking too far for your problem... Your join_buffer and sort_buffer are probably a little large if you have man concurrent users. Must you use an old version of mysql? You should analyize or post EXPLAIN of your query so that you/we can see that it is properly indexed.. you should