…). Results: First of all, we used a smaller dataset for this … PowerEdge R720 box and varied cpu combinations with taskset. The … SELECT has to scan about 100 update transactions to create a…99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…load of data size of datadir ~10GB). We used this dataset to check server behavior when …_LRU_free_block(buf_page_t*, unsigned long) | | | |–100.00%– buf_LRU_scan_and_free_block(…MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… I am going to use new the Dell PowerEdge R420 with two Intel(R) Xeon(R) CPU E5-2450 0 …sbtest$I_r1000, with roll-up sum for 10, 100, 1000 records in the main table. and transactions … myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should…) Kernel | 3.2.0-35-generic Architecture | CPU = 64-bit, OS = 64-bit Threading | …number of innodb_data_reads (values over 100 second intervals) | Innodb_data_reads | 54561 | | Innodb_…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…. So how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query… provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log… #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is pretty idle…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… number of cores. If you would not only run MySQL plugin but also use new “Barracuda” Innodb format you see just 1… about CPU usage in this condition. Here is the graph: The CPU usage is normalized to match number of CPU cores used, so 100% in 2 cores case is 100% of two cores…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… Load – MySQL Replication goes in single thread so it is really vulnerable to the server load. If you get 100 active queries running on the slave overloading it, slave thread will most likely will not get CPU or Disk… slaves used for long reporting queries can have queries running for hours which stalls replication progress for this time. As MySQL Replication…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… guesswork. The key is to use a logical approach and good tools…> we want to tolerate. THRESHOLD=${THRESHOLD:-100} # This is the thing to check…snapshots of waiting (stack traces) and CPU consumption (oprofile). That’s important … that can cause a stall in MySQL, and they usually begin microscopically …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of the benchmarks posted about MySQL 5.6 use… afterwards: mysql> select sq.*, pages / (@@innodb_buffer_pool_size / 16384) * 100 pct_buffer_…p2.duration, p1.cpu_user + p1.cpu_system p1_cpu, p2.cpu_user + p2.cpu_system p2_cpu, p1….
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There were two cases considered CPU- and IO…. This is the highest rate observed. IO-bound case – 100 warehouses Database size 10GiB # of connections No logging, NOTPM Logging… logged. In general logging all queries can hurt MySQL and you should consider the load while using it, especially in CPU-bound case.
