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.
MySQL On Multi-Core Machines
User contributed tags for this post:
mysql multicore (81) - mysql multi core (69) - mysql multiprocessor (24) - mysql multi processor (21) - multicore mysql (11) - mysql (11) - mysql on multicore machines (9) - multi-core mysql (8) - mysql multi cpu (8) - F (8) - mysql multi-core (7) - mysql multi core performance (7) - mysql multicpu (6) - mysql multicore support (5) - mysql on multicore (5) - mysql multi thread (5) - mysql multi-core cpu (5) - mysqL multi core support (4) - mysql windows multicore (3) - mysql multiprocessing (3) - mysql multicore performance (3) - mysql multiple processor (3) - mysql multithread (3) - apache multi core (3) - mysql on multi core (3) - 123 cilips (3) - mysql CPU support (2) - true (2) - apache multi-core performance (2) - mysql multi processing (2) - mysql on multi-core processor (2) - MYSQL multi-core performance (2) - mysql threads core (2) - mysql use multiprocessors (2) - mysql AND (multicore OR multi-core") AND (problem OR performance) (2) - mysql use multi processor (2) - mysql on multi processor (2) - apache on multi-core machines (2) - mysql multi core processor (2) - mysql multicore processor (2) - multi-thread mysql (2) - mysql multi (2) - core machines (2) - mysql multiprocessor support (2) - mysql on multicore cpu (1) - apache support multicore (1) - multicore and mysql (1) - mysql use multiple cpus (1) - mysql performance multi core (1) - Sear ???? ?? (1) - mysql multicore cpu (1) - execute mysql query multicore (1) - mysql and mutli threading (1) - mysql with multicore (1) - mysql multithread windows 2003 (1) - mysql windows multiple cores (1) - mysql performance on multi-core processors (1) - mysql with 8 cpus (1) - multiple cpu windows mysql (1) - mysql 8 cores (1) - mysql multithreading single query (1) - mysql multiple processors (1) - multicore lock (1) - mysql optimisation multicore (1) - how to multicore mysql (1) - multicore mac mysql (1) - mysql cpu use (1) - MySQL multiple cores CPU threads (1) - mysql multiple cores Windows 2003 (1) - mysql multithreaded core (1) - mysql multiprocessors (1) - threads in multi core machines (1) - mysql problem with multicore (1) - debian mysql multicore (1) - mysql 4.1 multicore support (1) - mysql multi-core settings (1) - mysql multi-core options (1) - limits mysql multiple core (1) - mysql multi-core 4.1 (1) - mysql multi core machine (1) - gentoo mysql multi core (1) - multicore support server mysql (1) - mysql enable multicore (1) - mysql and multicore processor (1) - mysql 8-core (1) - mysql running on multicore (1) - mysql and multicore (1) - mysql support multicore (1) - mysql multicore locks (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 performance multiprocessing (1) - multiprocessing mysql single query (1) - Mysql на многоядерных машинах (1) - mysql server multicore how to (1) - mysql multiple core (1) - mysql processor core (1) - mysql mac multiple cpu (1) - mysql variables multicore (1) - mysql query multicore (1) - 2008 multi core mysql (1) - multicore unterstützung mysql (1) - multicore table (1) - multi core e mysql (1) - mysql on multi-core (1) - apache core processor (1) - mysql and multiple processors (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) - mysql performance multicore (1) - cleveland addy (1) - Mysql performance 8 cores (1) - multi CPU mysql (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) - childrens recipe (1) - qunioa (1) - good ideas for library and information science papers (1) - ???? ?? (1) - wep finder (1) - mysql thread 8 core (1) - mysql 5.0 CPU multicore threads (1) - mysql multicore? (1) - flickr api (1) - mysql performance issue multicore (1) - mysql multi core optimization (1) - mysql multi processor core (1) - performance machine mysql (1) - php performance multi cpu OR multi processor OR multi c (1) - melon (1) - akron civic theater (1) -
Recently Commented