… some unique challenge to the database optimizer. The SSB benchmark consists of four…database is cold, but uses less CPU time when the database is hot…mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_…=32 table_open_cache_instances=8 sort_buffer_size=128k read_…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…tests on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows …. Even though the read-only transactions optimization in MySQL 5.6 virtually eliminates contention on the …1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… tested 10G and 100G data sets which was CPU bound and IO bound box on the Dell…MySQL as only one query is ran concurrently, same can be told about 8 hard drives which this box had. MySQL… be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
… merge, it means that MySQL is really looking at a search space closer to 8.5M rows, not … possibilities: A new version of MySQL is released that has some new optimizer functionality that you end up…” graph had dropped several orders of magnitude and CPU utilization on the machine had dropped by about…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…a single query is single threaded in MySQL, the new optimizations don’t really help with this …8332.2482.14327.5890979766854.83267164230352.24800109863282.1432509422302.8 year32.1485.6122.4472.49632.1476650238045.61204981803892…of workers past 24. The query becomes CPU bound at that point. If I needed…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6…duration, p2.duration, p1.cpu_user + p1.cpu_system p1_cpu, p2.cpu_user + p2.cpu_system p2_cpu, p1.context_voluntary… 0 | 3 | 3 | | 8 | optimizing | 0.000048 | 0.000048 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 8 | 8 | | 7 | System …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…8-core machine, two quad-core processors at 2GHz. I also know some things about the CPU…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… talk about optimizing application vs getting better hardware. With application optimization typically you …example right now you can get 8 core x86-64 box with … than throughput. If single user CPU bound query takes 30 seconds …he market offering services around MySQL and LAMP and MySQL is one of them…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… 24×1600.000 Models | 24xIntel(R) Xeon(R) CPU X5650 @ 2.67GHz Caches | 24×12288 KB # Memory…0-0) 2 2-2 64 Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size ========== ==== =======…, not different MySQL configurations, I didn’t try out different MySQL versions or….1 7.7 0% 3.8 8.2 12.1 87.0 …
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and … with increased concurrency even though we had 8 cores available for disposal. Unfortunately oprofile did … so I could not investigate where exactly CPU is wasted. My first obvious quess was Innodb…
