MySQL On Multi-Core Machines

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.

Others also read:

Related:

Posted February 6, 2008 by Casey Bisson
Categories: Dispatches, Technology. Tags: , , , , .

No Comments Yet

No comments yet.

Comments RSS TrackBack Identifier URI

Leave a comment

 

User contributed tags for this post:

mysql multicore (63) - mysql multi core (56) - mysql multiprocessor (24) - mysql multi processor (21) - mysql (11) - multicore mysql (10) - multi-core mysql (8) - F (8) - mysql multi cpu (8) - mysql multi core performance (7) - mysql multi-core (6) - mysql multicpu (6) - mysql multi-core cpu (5) - mysql multi thread (5) - mysql on multicore (4) - mysql multi processor support (4) - mysqL multi core support (4) - mysql multicore support (4) - mysql multicore performance (3) - apache multi core (3) - mysql windows multicore (3) - mysql multiple core support (3) - 123 cilips (3) - mysql multiple processor (3) - mysql multithread (3) - mysql multiprocessing (3) - mysql on multi core (2) - mysql multicore processor (2) - apache multi-core performance (2) - multi-thread mysql (2) - mysql multiprocessor support (2) - mysql threads core (2) - mysql multi processing (2) - true (2) - mysql AND (multicore OR multi-core") AND (problem OR performance) (2) - mysql on multi processor (2) - apache on multi-core machines (2) - mysql use multiprocessors (2) - mysql on multi-core processor (2) - mysql use multi processor (2) - mysql cpu core (2) - mysql multiprocessor vs multicore (2) - mysql use one core only (2) - mysql multi (2) - how to use mysql multicore (2) - mysql 5.0 multi core (2) - mysql multi core processor (2) - core machines (2) - MYSQL multi-core performance (2) - mysql multithreaded core (1) - execute mysql query multicore (1) - mysql with multicore (1) - threads in multi core machines (1) - mysql problem with multicore (1) - mysql multi-processor (1) - multi core processor mysql server (1) - mysql server multicore how to (1) - mysql multiple core (1) - mysql performance multi-core windows (1) - mysql multi process (1) - mysql with 8 cores (1) - mysql performance multi core (1) - multicore and mysql (1) - multiple cpu windows mysql (1) - mysql performance on multi-core processors (1) - mysql with 8 cpus (1) - use sex cilips com (1) - mysql multithreading single query (1) - mysql multiple processors (1) - multicore lock (1) - mysql multi-thread (1) - mysql optimisation multicore (1) - MySQL On Multicore Machines (1) - multiprocessor mysql 5.0 (1) - mysql cpu use (1) - mysql multiprocessors (1) - mysql enable multicore (1) - mysql multithread windows 2003 (1) - Sear ???? ?? (1) - apache support multicore (1) - mysql windows multiple cores (1) - Mysql issue with 8 core machines (1) - mysql on single core (1) - mysql optimization multicore (1) - gentoo mysql multi core (1) - multicore support server mysql (1) - mysql and multicore processor (1) - configurer mysql multi core (1) - mysql pthread multi core (1) - mysql 8-core (1) - mysql running on multicore (1) - mysql and multicore (1) - apache on multi cpu (1) - php performance multi cpu OR multi processor OR multi c (1) - mysql multi-core 4.1 (1) - limits mysql multiple core (1) - mysql multi-core options (1) - mysql multithreading (1) - mysql query multicore (1) - 2008 multi core mysql (1) - multicore table (1) - multi core e mysql (1) - mysql 4 multiple cpu (1) - mysql on multi-core (1) - mysql multicore -inurl:(kelkoo|bizrate|pixmania|dealtime|pricerunner|dooyoo|pricegrabber|pricewatch|resellerratings|ebay|shopbot|comparestoreprices|ciao|unbeatable|shopping|epinions|nextag|buy|bestwebbuys) (1) - mysql multicore locks (1) - mysql multiple cpu windows (1) - mysql support multicore (1) - mysql 4.1 multicore support (1) - mysql multi-core settings (1) - apache core processor (1) - mysql CPU multi core (1) - Mysql performance 8 cores (1) - cleveland addy (1) - mysql with multi processors on windows (1) - mysql windows multi core (1) - mysql multicore issue (1) - mysql cpu 1 core (1) - 4 core VS 8 core mysql (1) - obama in akron (1) - multi CPU mysql (1) - mysql multi-core performance threading (1) - mysql with multy cpu (1) - mysql multiprocessor optimization (1) - mysql single thread (1) - mysql thread cpu core (1) - mysql multi core multi thread (1) - mysql multicore threads (1) - windows multi core (1) - mysql multi threaded multi cpu (1) - mysql performence multi-cpu (1) - sudafed PE (1) - sears (1) - childrens recipe (1) - mysql performance issue multicore (1) - flickr api (1) - mysql multicore? (1) - mysql 5.0 CPU multicore threads (1) - mysql thread 8 core (1) -
Top Tech Trends iPhone Strobe Light