…to deal with. Stress Testing Running single stream of queries with good speed is not enough. You also need to perform stress testing to ensure both MySQL…testing is also a safe way to test things out – you can move read traffic to such slave to ensure new version stability and performance…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql…MySQL process in 1/100 of the second. (This is pretty idle test system). So 347 and 5303 correspond to…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
… not going to work and MySQL will need to scan keyblock from the start uncompressing keys to find… types. Also according to my tests it looks there is something special in how integer primary key … faster to do a bit of uncompression than to traverse large memory areas. Reverse index scan performance…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…to see performance and scalability in this simple cases. We also use CPU bound workload in this case (no disk IO) to see how… of RAM MySQL version We used MySQL 5.1.16-…to check PBXT performance on INSERT/UPDATE queries taking into account PBXT way to handle such queries, I hope I will be able to test…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
…: Error ‘FUNCTION test.this_year does not exist’ on query. Default database: ‘test‘. Query: … user-variables and then using it to perform writes. The issue is fixed …to take in account when we are working with statement based replication. Knowing in advances how MySQL works internally can help us to…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…how to properly build the server to use it (bug 61587). We at Percona regularly use Memcheck for our development and upstream testing…MySQL testsuite is not very practical due to 100x slowdown imposed by Helgrind). For this purpose, I have patched mysql-test-run.pl to…processor might perform the …
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
…the Expo Hall. I started to chat with them about their MySQL backup product. One …| 6 | root | localhost | test | Field List | 35 | Waiting for table | | | 7 | root | localhost | test | Query | 0 | NULL | show …use FLUSH TABLES WITH READ LOCK are performing a relatively short operation inside of the…
Post: MySQL and Sun - Oportunity for smaller companies ?
March 26, 2008 By 10 Comments
… days/weeks away. If you happen to have a repeatable test case you would likely get a fix… tend to joke about during early MySQL years is how much it would cost to approach Oracle and make them to… be faster to fix your MySQL issues – at Percona we do a lot of work with performance analyzes and …
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
…to the ones I had in MySQL Performance Landscape presentation – neither of them was match to Opteron performance in MySQL…MySQL but also Linux what has the problem. I had similar results in my tests and now happy to… with article authors advising them how to tune MySQL and what is the reason for…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
… Performance – We’re very good helping you to get the most performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL…time settings. Using Percona MySQL Server Development Services to do this work will ensure you get an optimal and tested build. We …
