Re: Help optimizing this query?

Hi, I would use a (source,stamp) index, and not a (stamp,source) index to solve the performance problem. Jocelyn Fournier www.mesdiscussions.net > Brian, can you post the output of EXPLAIN for your query? > I.e., > EXPLAIN ; > > > At first glance, your query should be able to use the 'stamp

Re: Issues with MySQL x86_64 crashing

Hi, How much memory do you have on your system ? (the current setting in your my.cnf could eat *a lot* of memory) Thanks, Jocelyn Fournier www.mesdiscussions.net > On 12/7/06, David Sparks <[EMAIL PROTECTED]> wrote: >> Kevin Old wrote: >> > Hello everyone, >> > >> > We have a 4 CPU master se

Re: Issues with MySQL x86_64 crashing

Hi, Do you use MySQL with a NPTL or a linuxthread glibc configuration ? Regards, Jocelyn Fournier www.mesdiscussions.net > Hello everyone, > > We have a 4 CPU master server running the 5.0.27 RPM x86_64 version of > MySQL with a mix of InnoDB and MyISAM tables. > > We normally run at 1500 qu