… deal with. Stress Testing Running single stream of queries with good speed is not enough. You also need to perform stress testing to ensure… only happen at high load. You can do this in test/stress test envinronment or you can do it later when you setup…. Adding the slave with new version for testing is also a safe way to test things out – you can move read traffic…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… not work well (this is of course unless you always test all automated failure scenarios regularly). So if we’re designing… the same time it is of course important to QA/Stress test servers before you put the load on them. I’ve… the same problem. Proper QA/Stress test reduces the chance of this but you better to be testing with load similar to what…
Post: Is your MySQL Server Loaded ?
March 19, 2010 By 6 Comments
So you’re running the benchmark/stress test – how do you tell if MySQL server is really loaded ? …_running | 1 | This corresponds to what is expected to be stress load but we can see MySQL is getting only spikes… are cases when actually 32 queries are active (this is test with 32 connections) – but you can see most of the…
Comment: 7 Reasons why MySQL Quality will never be the same
December 11, 2008 By 15 Comments
…) process, resulting in more thorough and systematic testing, including specifically a focus on recovery testing. Many of the problems we have identified… kind of stress tests needed to identify timing problems (like race conditions) are not typical of early-adopter workloads. The performance testing we…
Post: Sample datasets for benchmarking and testing
February 1, 2011 By 18 Comments
Sometimes you just need some data to test and stress things. But randomly generated data is awful — it doesn’t … of data might help you benchmark and test under more realistic conditions. The venerable sakila test database: small, fake database of movies. The employees test database: small, fake database of employees…
Comment: How Percona Develops Open-Source Software
January 12, 2009 By 4 Comments
… are using mysql-test suite for everyday testing, and adding our own tests to suite. After significant changes we run stress-test as: sqlbench, sysbench… results. And criteria is simple – does it pass above mentioned tests or not. After that we setup release on some our…
Post: MySQL Quality of old and new features
October 4, 2007 By 24 Comments
… problem is serious lack of concurrent stress testing and the fact MySQL Test Suite does way too many tests only for MyISAM storage engine… application together with sample database and package it as a test suite to ensure queries which you’re using will not…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…: Further Scalability improvements Yasufumi Kinoshita did number of interesting benchmarks stress testing other areas in Innodb than buffer-pool which had it… has provided will be merged soon if not we should test them and make binaries with them available. With current MySQL… or parallel log recovery features, which he however needs to test properly before really enabling it. Innodb IO Tuning I should…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… based replication. I’m however yet to give it real stress tests to see how well it performs 
One more thing to… page no 33504 n bits 328 index `j` of table `test/sample` trx id 0 42304626 lock_mode X locks rec… 1794751, query id 6994931 localhost root Sending data insert into test select * from sample ——– As you can see INSERT… SELECT has…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 20, 2008 By 117 Comments
I found nice application stress test at spamassassin http://wiki.apache.org/spamassassin/BayesBenchmarkResults In this test MyISAM won, anyway quite interesting numbers.
