One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … first thing you need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… or downtime. As you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER without any locking… tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever delayed a project…’ll show how to use it to forecast scalability and performance The new Percona Toolkit release is available for download today…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… important to know is that, just increasing the join_buffer_size is not going to provide the best possible query performance. As… for the best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but you need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have an impact on MRR performance…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… from the fact how MySQL‘s Transactions work with DDL, In particular ALTER TABLE. When ALTER TABLE is Performed in many cases… | +——————–+ | A | | B | | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A; +———-+ | count(*) | +———-+ | 2359296 | +———-+ 1 row in set… empty tables in your mysqldump –single-transaction backups you will know the potential cause for it. What are potential solutions for…
Comment: Introducing new type of benchmark
February 26, 2012 By 16 Comments
… a bit smoke and mirrors. You dont know your 9x percentile response time performance until you use it against your work load… along so I think the value proposition is more around knowing the cost benefit immediately in terms of those incremental schema… have a sharded datastore. A possible solution is to use mysql proxy and an alterate server with a snapshotted dataset and…
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… be used. Your tpcc-mysql for example doesn’t use JOINs, something we know is expensive in the MySQL world, yet Oracle and to some extent SQL Server handle better. JOIN has long been something MySQL… emphasising benchmarks that benchmark performance across the board? With the increasing emergence of drop-in replacements for MySQL like Percona and MariaDB…
Comment: Percona white paper: Forecasting MySQL Scalability
April 17, 2012 By 6 Comments
…, Your first paper – Forecasting MySQL Scalability with the Universal Scalability Law was really very …see you gave one session on – Extracting Scalability and Performance Metrics from TCP Traffic in Surge Conference 2011. …/presentation you made to demonstrate? Please let me know. Thanks in advance. …
Post: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
…’re working on major rewrite of High Performance MySQL book – the most famous book about MySQL Performance on the market… which is getting old… MySQL Performance topic to the market. Me and Vadim have great internals insight and a lot of practical experience in MySQL Scaling and Performance… application. We also will be looking for reviewers. Let us know if you’re interested in reviewing one or more chapters…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
For a long time I’ve wanted to know how MySQL scales as you add more memory to the server. Vadim … possible, limiting the system complexity, and lowering the price-to-performance ratio. The outcome of the research, which was sponsored by… — has more bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price-to-performance ratio and increase the utilization…
Post: Speaking at MySQL Meetup in Charlotte,NC
February 6, 2012 By Leave a Comment
… learn basics MySQL configuration as well as for Advanced MySQL DBAs to learn a trick or two they did not know. As an extra treat for attendees I will bring exclusive discount to MySQL Conference and Expo as well as some signed High Performance MySQL 2nd Edition books to give…
