…utilizing multiple CPU cores if needed. In previous versions, compression was only possible with …(e.g. could not be used with parallel file copying, it…feature were mutually exclusive, i.e. one couldn’t do streaming incremental … at the upcoming Percona Live MySQL Conference and Expo (register now!). …
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
…one CPU. To help completely demonstrate how Shard-Query makes parallel set operations work, I’ll operate in only one dimension for the first example, just like the MySQL client. This …operate on all the buckets and then use intelligent expression substitution to put the results…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… of production workload which focuses only on one query but yet mimics real…get use of more than 8 cores effectively (which would correspond to single CPU…mysql_select,handle_select,execu te_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_connection,handle_one…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… views. Most database servers have some spare CPU for binary log parsing. Run the setup script…is seen for that table. This is generally only useful if you have a small number of tables… automatically be captured. Insert data in one transaction (two rows): mysql> insert into test.demo values (NULL,…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption …memory for example is unlikely to help. One helpful way to use this information is to compare systems with …pretty IO bound load for me. But average is only average. It is a lot more interesting to …
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… this patch we only use this patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with… with number of cores. If you would not only run MySQL plugin but also use new “Barracuda” Innodb format you see just 1… to cause full CPU usage, or you may be waiting by spinning on the spinlock wasting CPU cycles. Detailed profiling tells which one.
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… MySQL 4.1, and indeed previously it did not even scale with one CPU as global lock was held during IO duration, In MySQL 4.1 the lock is held only when key…) To get accurate information about table usage I will use Percona Patches: mysql> select * from information_schema.table_statistics where table_schema…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… servers also on database boxes, might be only handling partial load etc. I would however only use it in last resort – placing some data crunching scripts on database server is often better use of their free CPU time… your application needs) is very good idea. One more benefit of local access to MySQL is latency. This was problem many years…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… of RAM which we used for testing. Even though box had 8 cores it is little use for MySQL as only one query is ran concurrently, same can be told about 8 hard drives which this box had. MySQL Also… for MySQL because CPUs just continue to add more cores. Having 2 CPUs and being able to use only half of system CPU resources…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… MySQL Replication goes in single thread it is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication executes queries one after another on… MySQL Replication runs in single thread (two threads, but only one of them executes the query) it is not able to use the CPU or…
