… So how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query…also see what the query in average examines 20 rows, which means about 1 IO per 40 rows… which amounts to …# Rows sent 21 1.57M 0 1 0.94 0.99 0.24 0.99 # Rows examine 4 1.57M 0 1 0.94 …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB data set which “…5.1 and MySQL 6.0 can complete all queries within an hour. We can also see MySQL 6.0 improving query 20 … MySQL because CPUs just continue to add more cores. Having 2 CPUs and being able to use only half of system CPU…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 4 Comments
…4 can be light if it is CPU bound – because the system can execute much more CPU…the server with MySQL, Load Average is likely to be close to 1 even if … waiting on one drive you can’t use another drive instead), and the fact …queuing started it may take just 10-20% extra load to overload system, so …
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
…MySQL 4.1 vs 40-60 for MySQL 5.0 At the same time however there were virtually no disk IO and CPU…using mysqladmin processlist | grep -v Sleep shows much smaller value which is close in MySQL 5.0 and 4.1…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… you aware of MySQL history you may think Key Cache scalability was fixed with new Key Cache in MySQL 4.1, and indeed previously it did not even scale with one CPU as global lock was held during IO duration, In MySQL 4.1… Inserting data to about 20 tables I’ve seen performance gains as much as 10x compared to using single shared key cache…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…using Full Text Search. [root@r27 sp]# mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL… TABLE `sptest` ( `id` bigint(20) unsigned NOT NULL, `site_…=1; +——+—+ | a | f | +——+—+ | NULL | NULL | +——+—+ 1 row in set (4…to scale almost linearly using multiple CPU cores and multiple…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
…load of about 10, and 8 CPU cores. The resulting mk-query-… solutions: use “mk-query-digest –filter ‘$event->{time} && $event->{time} > 1‘” to … (around 30% when filtering only 4 out of hundreds of active clients…to capture tcpdump data in seconds (1200 = 20 min) TMP=’/tmp’ LOCKFILE=”$self.lockfile”…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…Percona Server 5.1.56-12.7 and Percona Server 5.5.11-20.2 with former …can’t get use of more than 8 cores effectively (which would correspond to single CPU socket these …mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_conn ection,handle_one_connection,start_thread,clone 4…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
… to Improve MySQL Performance. For DBT2 benchmarks we’ve tried a while back MySQL 5.0 was about 10% slower than 4.1 without stored procedures but was 20% faster if Stored Procedures are used. And… language is slow at it but you’re also loading CPU on your Database Server, which is typically more expensive to…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
…) CPU 5150 @ 2.66GHz, 32GB RAM. There are 8 disks in RAID10(a mirror of 4+4 striped disks). Software It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There were two cases considered CPU… in terms of database size. The test was run with 1, 20 and 100 database connections Results To reduce random error the…
