Walt, Yup, we use Innodb with 3.23.46 on Linux 2.4.2. I can't tell you whether things are better than they were on 2.2 kernels but we're updating tables just about that quickly I'd say. Largest table we have is a log table which has 50 million rows in it so far. Thanks to Innodb row locking, we've significantly improved insert versus select query performance.
I've heard (I think I read this in a magazine) that prior to 2.4.4 kernel, there are some virtual memory issues with Mysql, so I'd be interesetd to know what kernel version you have... memory management changed a lot between 2.2 and 2.4, so that would probably account for the changes you're seeing. JOhn Weaver, Walt wrote: > Anyone else out there been playing with the new Linux 2.4 kernel? > > I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB > tests. The results were dramatic; updating a 600,000 row table went from 21 > minutes and change to 6 minutes and change. > > Haven't tried 2.4 and MyISAM tables yet; on 2.2 the same update ran in about > 8 minutes. > > This is obviously a big improvement, if my tests are valid. It's SUCH a big > improvement that I'm wondering if I messed something up. > > Any comments/statement of support/snide remarks will all be appreciated. > > Thanks, > > --Walt Weaver > Bozeman, Montana > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > . > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php