…), table without PK imposes an additional overhead, and because cluster performance is somewhat dependent on the slowest node – this overhead can…, other factors affecting async replication like if your workload is CPU or IO bound. Peter wrote some good details about it…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It … 10:03:22 UTC 2013 procs ———–memory———- —swap– —–io—- –system– —–cpu—– Fri Mar 22 10:03:22 UTC 2013 r b…
Post: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
… scale from reasonable base to claim the good performance, and this is where T2000 performs subpar in many cases. I often hear… is hell a lot of difference ! Depending on your application performance with single thread may be important or non important for… active replication, if you’re running time sensitive long running CPU bound queries or if queries contribute significant time to generating…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… the corellation between CPU usage and performance. We can see Plugin 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… shows increased performance while decreased CPU usage. Note when I say CPU usage drop means concurrency issues it does not mean CPU increase does…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… 16GB to 32GB can improve performance order of magnitude by converting very IO bound load to CPU bound, it is well possible… be watched carefully. Performance does not always stays the same and the goal may not be optimizing average performance. It may be… years and load data for 5 years only to compare performance you may get misleading results if reports are typically done…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…)/wtime) lost_ratio from performance_log_081221 where page_type=’search’ and wtime>1; +———-+—————–+——————+——————+——————+——————+ | count(*) | avg(wtime) | cpu_ratio | mysql_ratio | sphinx… mention looking at performance statistics for the day overall is often not enough. Application performs as good as it performs during its worst…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… immediately a question arises how much logging impacts on performance. When we do performance audit often we log every query to find… from performance degradation caused by the microslow patch itself. Let’s do the same tests but logging to /dev/null. CPU-bound… bigger than a second without worry about performance impact in case of CPU-bound workload. The performance impact is negligibly small in IO…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… your concerns are at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? We also want… 25 /proc/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R) Xeon(R…. The changes Percona’s performance audits typically suggest can be really significant, and can completely change the performance profile and workload of…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
… of CPUs and Disks – system may be quite idle and performance still poor because application is not parallel enough. Similar situations… where waiting in the queue starts. If you have fully CPU bound workload which is rather parallel (ie many queries will… the box it will perform well as soon as you need to do a lot of queuing performance starts to suffer. Let…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… a bit better performance. Interesting enough utilization in iostat never went over few percents and load was mostly CPU bound. Next I… some CPU cycles handling them without taking large performance hit. I really hope this would be one of the Items besides CPU scaling… which did not seems to give any significant performance benefit, may be even reducing performance few percents. I also tried running with…
