… MySQL Inc as Performance Engineer, working in Peters group working on MySQL Performance and Scalability issues. My primary tasks were benchmarks, profiling, finding bottlenecks. I’m an expert in multi threading programming and synchronization stuff. While working for MySQL I took part…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn… from your MySQL database. When you do, the limitations on the core counts and effective CPU speeds can be a bottleneck. My… activity you’re generating, whichever comes first. And you could find that you generate more I/O than you can push…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… you may decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server and place them on different… easier to analyze – Troubleshooting bottlenecks on shared boxes is more complicated compared to systems running only MySQL or only Web server. In… about sharing MySQL and Web server at all ? Well mostly it is for cheap guys. In many applications you will find database…
Post: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… lot of care. Instead, during the benchmarks I performed live bottleneck analysis, and observed data such as snapshots of the processlist…-working some machines and under-working others. We have to find something in the middle so that we can benchmark all…
Comment: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
Thank you Peter, Indeed “Practical MySQL Variable Tuning” suppose to show the numbers and tell you … again this year. Indeed too many people do not approach finding bottlenecks systematic enough. I did couple of presentations on benchmarking methodologies…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… top of the stack. If you look at MySQL log you may find some queries which are slow but it is hard… two great benefits. First we really understand what is the bottleneck. Second we know what performance gain potential is. For example… see if performance goals are met and where is the bottleneck this time. As a side note I should mention looking…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries,… OS version. In our tests, removing one bottleneck moves the contention to another place. Thus, … us greatly to spot scalability problems and find fixes for them. The work continues. I …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded and the more … and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS… and also you may need to adjust regular expression for finding users replication thread uses. 3) Processlist Polling This method is…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 12 Comments
… | 290 | | 6950 | 290 | +——+—–+ 10 rows in set (21.12 sec) mysql> select count(*) cnt from dt where slack like “a%”; +———+ | cnt… make much sense to me and I find it quite inconvenient whenever it is MySQL limitation or SQL Standard. This would be… is growing rapidly and use of MySQL for reporting quite expectedly starts to become the bottleneck. We use a lot of other…
Comment: MySQL VIEW as performance troublemaker
August 13, 2007 By 53 Comments
I actually had previously utilized MySQL‘s VIEWs in a project when they had just came … find was that it was one of the worst performance bottlenecks as my data set grew. What I came to find was that MySQL…
