…especially if you are planning to write on multiple nodes. Have PRIMARY KEYS If you still … PK imposes an additional overhead, and because cluster performance is somewhat dependent on the slowest node – this… affecting async replication like if your workload is CPU or IO bound. Peter wrote some good …
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… from performance_log_081221 where page_type=’search’ and wtime>1; +———-+—————–+——————+——————+——————+——————+ | count(*) | avg(wtime) | cpu_ratio | … components (like sphinx and MySQL) or multiple MySQL Servers because in these cases …
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…is IO bound workload – disks are moving and CPU sits idle. With such terminology there is …(from replication thread for example). When update is performed first problem is actually reading the data. If…by the thread and so can result in multiple outstanding requests to the disk. Though this does…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… data. In the real life applications performance is likely to be lower due to less CPU cache usage efficiency larger object size… was done on my home test box (2Ghz AMD Sempron CPU) using MySQL 4.1 and PHP 5.0. For memcached… multiple query results) MySQL Query Cache may improve performance of your application. Multiple layers of caching may do well Same as CPUs have multiple…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… queries/sec with multiple threads. So Innodb took very high hit supplied with high performance IO subsystem. But not only performance was poor… box in question so I could not investigate where exactly CPU is wasted. My first obvious quess was Innodb checksumming (innodb… some CPU cycles handling them without taking large performance hit. I really hope this would be one of the Items besides CPU scaling…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
…, and indeed previously it did not even scale with one CPU as global lock was held during IO duration, In MySQL…) So going through complex or not multiple key cache creation exercise you probably wonder how much performance gains should you expect. In fact it can be very significant. For CPU bound workload with 16…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…’ll see where this leads us but I believe on multiple CPU systems you need some spinning done, at least for some… are great. Huge indexes is where large portion of Innodb performance problems come however. We should however see how “compact” they… it can be the problem – if transaction spawns multiple databases you need multiple log flushes on commit, plus ether you use XA…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… understanding of Frequency != Performance. My expectation for performance per clock cycle was – it should be increasing with each new CPU family, This was… family. This article also has very interesting observation on MySQL Multiple CPU scalability . As you can see MySQL could be slower on…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
… in the queue starts. If you have fully CPU bound workload which is rather parallel (ie many … drive instead), and the fact disks can optimize multiple outstanding requests a bit better compared to requests … it will perform well as soon as you need to do a lot of queuing performance starts to suffer…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… – allocating resources to different storage engines and performance tuning becomes more complicated. Now what is …fact people already do not love to mix multiple storage engines very actively because of potential …not matter). We could save a lot of CPU cycles by having storage format same as …
