… path in the XFS code – it’s put a lot more pressure on an exclusive lock by removing other bottlenecks. Hence when we hit contention on it, it degrades more quickly than it used to. This was brought to my… million 4k overwrite IOPS to a single file when completely CPU bound… So, basically, XFS is still the filesystem you want…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… well as adding features to make it better suited to more environments. The 2.0.0 release contains no changes from… can be done in a parallel way, thus utilizing multiple CPU cores if needed. In previous versions, compression was only possible…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… the more cores we get the more idle CPU we’re getting. It is also very interesting to see the corellation between CPU usage… uses less CPU with 8 cores and has less performance – this usually shows synchronization is the issue. Barracuda format uses more CPU while delivering better performance so it is probably better with latching too though it is hard to say anything about CPU…
Post: XtraDB in CPU-bound benchmark
December 18, 2008 By Leave a Comment
… XtraDB and Innodb storage engines. Innodb has generally higher CPU usage and more uniform while it has a huge dip in the… CPU usage…. which is more than the measurement error. So we think in workload which can utilize CPU more fully XtraDB will show more gains, though not 1.5x as for IO bound workload. One may ask why CPU is…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 4 Comments
… 4 can be light if it is CPU bound – because the system can execute much more CPU bound tasks in parallel or High…) and loadavg is 16 for CPU bound workload it often means requests should take 4 times more to complete than they would… starts to suffer. Let us clarify last point – how much more load the box can handle before it overloads, loadavg skyrockets…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… second MySQL Consulting work or even more frequently. IO Bound workload is quite different from CPU bound one, which happens when your… at least 5-10 second, or more under the load which is already way more than you should target for web applications… application as CPU bound and when it scales so much you can’t afford to get enough memory any more, you might…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… a lot of CPU time running “loops” as part of spinlock implementation. In many cases busy wait is indeed more efficient than… a lot of threads waiting and the more CPU cores you have available the less CPU utilization you can have. Sometimes though you… limited and can be used to buy a little bit more time while you’re upgrading to Percona Server or newer…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… a single thread. MySQL never takes advantage of more than a single CPU when aggregating data and fetching rows from the buffer… query becomes CPU bound at that point. If I needed more performance I could divide the data between two or more shards, or if possible, I could add more CPU cores. Regardless…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… peak performance to use CPU and IO resource more effectively. To avoid mutex/lock contentions are good to use more CPU resource of many… now.
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
… of buf_get_latched_pages_number being responsible for most CPU usage. It did not look right. The close look revealed…. Another function which we’ve seen being responsible for high CPU usage is ha_print_info which also may traverse large… same time however there were virtually no disk IO and CPU being loaded less than 20% (out of 4 Cores) in…
