On Thu, Jan 22, 2009 at 10:00 PM, Monty Taylor <mo...@inaugust.com> wrote: > MARK CALLAGHAN wrote: >> On Thu, Jan 22, 2009 at 6:10 PM, Brian Aker <br...@tangent.org> wrote: >>> Hi! >>> >>> Yes, that is what our core is. Early on I redid much of the IO handling code >>> to make better use of it. It is not perfect though... I need to move around >>> the IO code to tweak a bit more out of it. >>> >>> BTW I am surprised you found a multi-core benchmark where is was worse. Even >>> for MySQL whenever we tested it, it came out on top. Though... with 4 core >>> you set it to what, 2? The other threads, like Innodb's, are not counted in >>> that number. >>> >>> Cheers, >>> -Brian >>> >> >> I tested 1, 2, 4, 8 and 16 concurrent users in sysbench. The >> thread/connection pool had 20 threads. > > How many cores does your test machine have?
The results in the bug are measured on a 4 core server. I have results that are at least as bad from a 16 core server. When pool-of-threads is used _every_ command sent to the server for every connection goes through a pthread_mutex lock/unlock on LOCK_event_loop. > >>> On Jan 23, 2009, at 1:05 PM, MARK CALLAGHAN wrote: >>> >>>> Do you have the thread pool code in your tree >>>> (--thread_handling=pool-of-threads)? >>>> Have you done anything to make it efficient? >>>> >>>> For me, sysbench OLTP readonly is up to 3X faster using blackhole when >>>> pool-of-threads is not used -- http://bugs.mysql.com/bug.php?id=42288, >>>> and this is on a 4 core server so I assume the overhead gets much >>>> worse with more cores. >>>> >>>> -- >>>> Mark Callaghan >>>> mdcal...@gmail.com >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~drizzle-discuss >>>> Post to : drizzle-discuss@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~drizzle-discuss >>>> More help : https://help.launchpad.net/ListHelp >>> -- >>> _______________________________________________________ >>> Brian "Krow" Aker, brian at tangent.org >>> Seattle, Washington >>> http://krow.net/ <-- Me >>> http://tangent.org/ <-- Software >>> _______________________________________________________ >>> You can't grep a dead tree. >>> >>> >>> >>> >> >> >> > > -- Mark Callaghan mdcal...@gmail.com _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : drizzle-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
