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:

• MySQL Documentation
• Changes To WordPress Object Caching In 2.5
• Compress CSS & JavaScript Using PHP Minify
• Easy MySQL Performance Tips
• Catching Bugs Before They Catch You

Posted February 6, 2008 by Casey
Categories: Dispatches, Technology. Tags: multi-core performance, multiprocessing, mysql, performance, table locking.

No Comments

No comments yet.

Comments RSS TrackBack Identifier URI

Leave a comment

Name (required)

Mail (will not be published) (required)

Website

 

User contributed tags for this post:

mysql multi core (48) - mysql multicore (42) - mysql multiprocessor (20) - mysql multi processor (19) - F (8) - multicore mysql (8) - multi-core mysql (8) - mysql multi cpu (7) - mysql multicpu (6) - mysql multi-core cpu (5) - mysql multi thread (5) - mysqL multi core support (3) - mysql on multicore (3) - time passing quote (3) - mss (3) - 123 cilips (3) - mysql windows multicore (3) - mysql multicore processor (2) - mysql multi (2) - apache multi core (2) - apache multi-core performance (2) - mysql multiprocessor support (2) - multy sex.com (2) - mysql on multi processor (2) - mysql use multi processor (2) - mysql threads core (2) - mysql multicore support (2) - MYSQL multi-core performance (2) - apache on multi-core machines (2) - mysql multiprocessing (2) - true (2) - mysql multi-core (2) - mysql (2) - mysql multithread (2) - mysql use multiprocessors (2) - core machines (2) - mysql multi core processor (2) - mysql on multi-core processor (2) - mysql support multi-core processor (1) - mysql multi processor performance problems (1) - multi-processor mysql 2008 (1) - apache multicore optimization (1) - mysql multi processors top (1) - mysql multi core multi processor (1) - mysql where multi (1) - multy sex com (1) - mysql multi-core problems (1) - mysql 5 multi core cpu (1) - mysql5 multiple cpu cores (1) - multiprocessing mysql under windows (1) - mysql CPU support (1) - mysql multiprozessor (1) - apache multi core processors (1) - mysql multi processor Optimization (1) - mysql multiple processor (1) - apache multi-core support (1) - mysql 8core (1) - mysql using multiple processors windows (1) - mysql multithreaded multiprocessor (1) - mysql multicore cpu (1) - mysql multithread windows 2003 (1) - Sear ???? ?? (1) - apache support multicore (1) - multicore and mysql (1) - mysql performance multi core (1) - execute mysql query multicore (1) - mysql with multicore (1) - threads in multi core machines (1) - mysql problem with multicore (1) - mysql multi core performance (1) - mysql server multicore how to (1) - mysql multiple core (1) - mysql multicore performance (1) - mysql windows multiple cores (1) - mysql multiprocessors (1) - mysql cpu use (1) - mysql use multiple cpus (1) - mysql 8 cores (1) - mysql multiple cores Windows 2003 (1) - multicore mac mysql (1) - multiple cpu windows mysql (1) - mysql performance on multi-core processors (1) - mysql with 8 cpus (1) - mysql multithreaded core (1) - mysql multithreading single query (1) - mysql multiple processors (1) - multicore lock (1) - mysql optimisation multicore (1) - mysql multi processing (1) - mysql and multiple processors (1) - ?????? ???? (1) - myers school of art (1) - flickr photo rss (1) - good ideas for library and information science papers (1) - qunioa (1) - childrens recipe (1) - sears (1) - sudafed PE (1) - obama in akron (1) - 4 core VS 8 core mysql (1) - mysql cpu 1 core (1) - mysql multicore issue (1) - mysql windows multi core (1) - mysql with multi processors on windows (1) - ticket master (1) - akron civic theater (1) - ??? (1) - ???? ?? (1) - wep finder (1) - mysql thread 8 core (1) - mysql 5.0 CPU multicore threads (1) - mysql multicore? (1) - flickr api (1) - mysql multi core optimization (1) - mysql multi processor core (1) - performance machine mysql (1) - mysql performance multicore (1) - php performance multi cpu OR multi processor OR multi c (1) - melon (1) - cleveland addy (1) - Mysql performance 8 cores (1) - multi CPU mysql (1) - is mysql multicore performance (1) - how to multicore mysql (1) - mysql performance issue multicore (1) - mysql 8 Multi processor support (1) - multiprocessor windows mysql (1) - multi thread mysql (1) - mysql multi-cpu use (1) - 8 core machines (1) - mysql multy core (1) - mysql 8 core (1) - mysql multi prozessor windows (1) - multi core and apache (1) - mysql multiprocessor settings (1) - mysql 8 cpu cores (1) - multicpu PHP (1) - mysql multi-core performance threading (1) - mysql with multy cpu (1) - mysql performence multi-cpu (1) - mysql multi threaded multi cpu (1) - windows multi core (1) - mysql multicore threads (1) - mysql multi core multi thread (1) - mysql thread cpu core (1) - mysql single thread (1) - mysql multiprocessor optimization (1) - mysql CPU multi core (1) - mysql table lock multi machine (1) - mysql cores (1) -