… it in every second MySQL Consulting work or even more frequently. IO Bound workload is quite different from CPU bound one, which happens when… application back to speed. The cases when going from CPU bound to IO bound hits the most is there a lot of rows… in CPU bound case – yes you will but it will happen with 100.000 messages not 100 messages as in IO bound case…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… ran few CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor : 23 vendor_id : GenuineIntel cpu family : 6 model : 29 model name : Intel(R) Xeon(R) CPU E7450… : 40 bits physical, 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…, which does not matter a lot in this case of CPU-bound benchmark. First stage – load data. Scripts for multi-table sysbench…=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql-user=root –report-interval=10 run this will report us… difference. As workload is clear read-only CPU bound, let’s check CPU stats: regular tables: —–cpu—— us sy id wa st 1 0…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc… The #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is… 1 IO per 40 rows… which amounts to pretty IO bound load for me. But average is only average. It is…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also had a… went over few percents and load was mostly CPU bound. Next I went on testing MySQL. My goal was to simulate as much… out at 16 threads. However even with MyISAM we got CPU bound before we could reach the system capacity – these 70K queries…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… different if load is CPU bound. I compared MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL… = 2G and innodb_flush_method=O_DIRECT to emulate IO bound load. InnoDB parameters: innodb_additional_mem_pool_size = 16M innodb…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… of their CPU efficiently in TPC-C like Workload. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5… patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just… be recognized by older Innodb versions. Note: These are completely CPU bound test conditions, data fits to buffer pool furthermore data and…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…. We tested 10G and 100G data sets which was CPU bound and IO bound box on the Dell 2950 box w 16G of… to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737… MySQL because CPUs just continue to add more cores. Having 2 CPUs and being able to use only half of system CPU…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
Backing up MySQL Database most people compress them – which can make a good … takes extra CPU resources on the source server in additional to IO resources which may not be available, especially for CPU bound MySQL Load… in compressed file size. Though in this example we used MySQL binary log file which often contains plenty of similar events…
Post: Scaling IO Bound Workloads Webinar
June 19, 2009 By 2 Comments
… for IO Bound Workloads in MySQL. My part of the presentation will be speaking about why switching from CPU bound workload to IO bound is… you’re interested in Schooner appliance offerings, flash or scaling MySQL in General. You can follow this url to register.
