…: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-… on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows… threads each SELECT has to scan about 100 update transactions to create a read view:…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…_free_block(buf_page_t*, unsigned long) | | | |–100.00%– buf_LRU_scan_and_free_…MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL…cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… with two Intel(R) Xeon(R) CPU E5-2450 0 @ 2.10GHz, 48GB…r1000, with roll-up sum for 10, 100, 1000 records in the main table. … 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len…_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query and compare it to estimated…. How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc… #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is pretty idle…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query-digest can be pretty CPU…queries that you can use to gather more data about the underlying tables involved and the query execution plan used by MySQL…
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 resources… only one of them executes the query) it is not able to use the CPU or the Disks on the slaves as…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous…| 3.2.0-35-generic Architecture | CPU = 64-bit, OS = 64-bit …table scan and index scan queries, though this is really not …innodb_data_reads (values over 100 second intervals) | Innodb_data_reads | 54561 | |…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…query with only one join, I’ve tested performance of the query with the join in both directions. Explain for query Q1.1: mysql…afterwards: mysql> select sq.*, pages / (@@innodb_buffer_pool_size / 16384) * 100 pct_…duration, p1.cpu_user + p1.cpu_system p1_cpu, p2.cpu_user + p2.cpu_system p2_cpu, p1…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
… is that a single query executes in a single thread. MySQL never takes advantage of more than a single CPU when aggregating data…-color:white;font-family:arial,sans,sans-serif;font-size:100.0%;font-weight:normal;font-style:normal;color:#000000;text… could add more CPU cores. Regardless, even with a single server Shard-Query will perform much better than regular MySQL as the volume…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… problems are, the mysql process always use 1 cpu core at 1 time and it used 100% of the cpu resource. I’am not… cached PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND 11395 mysql 16 0 100 39700:41 2.2 706m…_cache_size = 8 query_cache_size = 32M log_queries_not_using_indexes = On log_slow_queries=/var/lib/mysql/log-slow-queries.log innodb_data…
