Well I recompiled with Linuxthreads with the same result. I ran explain on both queries and the only difference is innodb looks at 31 rows where myisam looked at 23. Both are of type range. Is there anything else I can do before giving up on innodb?
----- Original Message ----- From: "Chris Nolan" <[EMAIL PROTECTED]> To: "Sasha Pachev" <[EMAIL PROTECTED]> Cc: "Cliff" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, March 09, 2004 7:14 PM Subject: Re: InnoDB tables using 90% cpu > Sasha Pachev wrote: > > > Cliff wrote: > > > >> The query is running dramatically slower than the MyISAM query, > >> sometimes > >> even causing mysql to freeze for a while. I searched this list and > >> found a > >> few people saying that on FreeBSD mysql should be compiled using linux > >> pthreads if you are using InnoDB or else I would get this exact > >> problem. Has > >> this been resolved or is should I recompile? I am using native freebsd > >> threads. > > > > > > Compare the output of EXPLAIN for both MyISAM and InnoDB. Also, if you > > have a Linux or even Windows system around, test the same query on > > them to see if there is any difference. > > > > I am not that familiar with FreeBSD, but from what I've seen, I would > > tend to use the approach "when in doubt, use LinuxThreads". The advice > > you've got does make sense - InnoDB runs a number of background > > threads, so if your thread implementation is lacking, it would hurt > > InnoDB more than MyISAM. > > > FreeBSD's thread library is a user-space setup. This can result in major > performance issues when doing things that block. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
