… by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6… data set MySQL 5.1 could only complete 10 out of 22 queries within 3hours run time allowed for each query and MySQL 6.0… 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: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read only workloads. Workloads which … I have compared Percona Server 5.1.56-12.7 and Percona Server 5.5.11-20.2 with …can’t get use of more than 8 cores effectively (which would correspond to single CPU socket these …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…MySQL 5.1 or aren’t using RBR, then it is possible to set up a dedicated MySQL slave which has log_slave_updates=1… 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…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… 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 16 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: 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: 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…
