… CPU efficiently in TPC-C like Workload. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very recent, though… of this patch we only use this patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… way. But vanilla MySQL does have its limitations, it reports only a subset of stats…Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 655360 use test; SET timestamp=1325145746; select… pt-query-digest can be pretty CPU and memory consuming, so ideally you … # Rows sent 105.76k 0 1000 5.39 9.83 32.69 0 #…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…using the FlightDate column using the improved MySQL 5.5 partitioning options which work directly on columns without the need to use…Shard-Query16 worker24 worker32 worker.1 year4.5481.0440.8540….past 24. The query becomes CPU bound at that point. …so adding CPUs will help only until we run out of …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… So how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per …99 # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes 0 0 0 …means about 1 IO per 40 rows… which amounts to pretty IO bound load for me. But average is only average. …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should … | Ubuntu 12.04.1 LTS (precise) Kernel | 3.2.0-35-generic Architecture | CPU = 64-bit, … significant difference here as O_DIRECT only applies to operating system logic while …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… on MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61…it is likely that if other CPU cores will read this same variable…hash and LOCK_plugin. I have only shown and analyzed a small … Additionally, I’d consider backporting and using MySQL 5.5 atomic operation primitives with proper memory…
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
…only one of the gotchas. The second issue we ran into is number of Threads_Running being much higher for MySQL 5…MySQL 4.1 vs 40-60 for MySQL 5.0 At the same time however there were virtually no disk IO and CPU…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now there are plugable storage engines… use when such need arises but we still can’t deny – MySQL does not handle complex queries well, being able to use only one CPU…. For example Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and Most of other items are still open. Well…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… to cause stalls. Well only benchmarks can give us the…CPU with two cores, 8G of memory and a software RAID5 array consisting of 4 disks. The version of MySQL used…MySQL 5.5.24, and the version of Percona Server used for benchmarking Lazy Drop Table is Percona Server 5.5.24 (innodb_lazy_drop_table=1…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…: 32 sessions, RW=1, dbsize = 1000000, no thinktime XtraDB: (mysql-5.1.39 + XtraDB-1.0.4-current) innodb_io…use CPU and IO resource more effectively. To avoid mutex/lock contentions are good to use more CPU…= 0 (default 1) It skip the updating statistics which needs the lock. (it only affects for “…
