… In general, each flight examines different time periods or different regions. The flights represent the type …when the database is cold, but uses less CPU time when the database is hot. I …set fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used:…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL…to assertion errors in the log parser or bad changed page data. Bug fixed #1108613 (…value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov)….
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL…to assertion errors in the log parser or bad changed page data. Bug fixed #1108613 (…value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov)….
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… Probably most readers of this blog know (or should know) about Linux swappiness setting, …you need to interleave the allocation of memory for the MySQL process using the numactl utility, …03:22 UTC 2013 procs ———–memory———- —swap– —–io—- –system– —–cpu—– Fri Mar 22 10:03:…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…. But it’s still significantly slower (and more CPU-intensive under high load) than PCIe flash For …not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD -… in memory (not actual RAM, that’s true, but much closer to memory speed than a regular SSD or …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… surely needs CPU cycles, it may need disk IO. You may also need other resources such as network IO or memory to store… estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query and compare it to estimated (or benchmarked) system… The #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory… means hundreds or may be thousands of IOs per system for the whole system which allows to waste some CPU cycles handling…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… performance bottlenecks as well as where CPU resources are spent. (Performance Schema does not accounts CPU usage directly but it is something… memory allocation and help to get MySQL on the memory diet. It would be easy to extend QA suite to check for peak memory… able to limit memory usage by individual MySQL users or even track how much these users are using. Now as MySQL 5.6 is…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
… your tickets to one or both MySQL workshops. Scaling and Optimization for MySQL on Monday & Tuesday, April 8 & 9 This MySQL workshop will cover… for MySQL: CPU, disks, memory, network; and how to use diagnostic tools in Linux. Investigate database trends via the counters exposed in MySQL‘s…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… almost 2x faster then combining memcached and MySQL, and about 20% slower then the all memory memcached approach. So for this… of threads, and data size increases how does performance differ or change? One knock on Tokyo -vs- Memcached is Tokyo… my CPU across the board. Also interesting is I started to hit bottlenecks in MySQL/Innodb when I had enough memory but…
