One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … are overloading the system causing user experience to degrade. The first thing you need to know it is not MySQL problem, might… too much system resources. Here are some specific techniques to use. Do push concurrency too high Many developers will test script with…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… a standard de facto filesystem for many modern Linux system, I am getting a lot of question if this … 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for ext4 is a … MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in Linux. Let’s test…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… performance improvement you see your performance being worse. What should you do ? First if you followed MySQL upgrade best practices such as testing…and new MySQL Server version and observing the difference. Sometimes though it might not show performance difference ran alone on idle system – in…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… your system check out Thinking Clearly About Performance by Cary Millsap. So how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query and compare it to estimated (or benchmarked) system performance to… and user CPU usage of MySQL process in 1/100 of the second. (This is pretty idle test system). So 347 and 5303…
Post: Performance or Stability ???
April 1, 2011 By 16 Comments
…performance if it is performance bursts rather than stalls, for example if my system performs…performance depends of response time your application can tolerate. In the MySQL…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… of what you should expect from the system. What I usually look for MySQL is performance in random reads and random writes. Sequential…–file-test-mode=rndwr cleanup sysbench v0.4.8: multi-threaded system evaluation benchmark Removing test files… [root@DB10 sysbench]# ./sysbench –test=fileio –max…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql-password=msandbox –mysql… test on virtualized system in this case so we would not be able to measure small variances in performance …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…system I’m working with. System performance Next I investigate what the system is doing, in terms of performance…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… afterwards. Or we might have a test server to run on. It varies …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 2
October 16, 2009 By 8 Comments
…-up our “test“ application and looked at boosting performance of the application by buffer MySQL with memcached. Our test application is simple…, test and make sure it fits your application. So adding Memcached on top of MySQL for our test application can significantly boost performance. But… well on one system may not work well on another. Because of this people often leave lots of performance on the table…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
…test as our concern is general IO performance in this case – it is not something MySQL related. I tested…and I would expect any system doing writes to experience the “performance shock” when LVM snapshot… reads). If you’ve done some LVM performance tests yourself or will be repeating mine (parameters …
