MySQL On Multi-Core Machines February 6, 2008 – 7:11 am The DevShed technical tour explains that MySQL can spawn new threads, each of which can execute on a different processor/core. What it doesn’t say is that a single thread can only execute on a single core, and if that thread locks a table, then no other threads that need that table can execute until the locking thread/query is complete. Short answer: MySQL works well on multi-core machines until you lock a table. Related:Easy MySQL Per

Original post by MaisonBisson.com » A bunch of stuff I would have emailed you about. and syndicated here by SEM