… What’s going on here? Where’s the bottleneck? The process is slow, and neither machine is…call that was hidden in the code, and timing out because of DNS issues. One of the best …application under a profiler (Google for “profiling
Post: To find the bottleneck, stop guessing and start measuring
August 4, 2008 By 8 Comments
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 …_on_disk There is a lot of interesting you can find out from this header but in relation to replication capacity – you… and also you may need to adjust regular expression for finding users replication thread uses. 3) Processlist Polling This method is…
Post: Election night
November 5, 2008 By Leave a Comment
… deal with it in advance. Considering the above, and reaching out to our client’s expectations, we offer the wide array… the challenge: “Comprehensive MySQL Performance Audit”- to help you find the bottlenecks, to assist with architecture design and to prepare systems for…
Comment: Returning to InnoDB scalability
November 27, 2006 By 42 Comments
Peter, Thanks for your immediate reply. If the bottleneck is System (HP-UX), How to find out the system factors which affects the MySQL performance? Please share your ideas…. Thanks in Advance, Prem
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… looking to see how you can get most out of your existing system, looking for consolidation or … benefits. First we really understand what is the bottleneck. Second we know what performance gain potential is. … causes the problem we have to go and find what queries exactly are causing it – this can …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… the OS version. In our tests, removing one bottleneck moves the contention to another place. Thus, no … helped us greatly to spot scalability problems and find fixes for them. The work continues. I believe …we are seeing individual 16KB paged I/O going out one at a time, that are esentially reads …
Comment: MySQL VIEW as performance troublemaker
August 13, 2007 By 53 Comments
… just came out. I figured that they would actually optimize how other databases would however what I came to find was that it was one of the worst performance bottlenecks as my data set grew. What I came to find was…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… it is not getting the documents which becomes bottleneck. Working with database instead of with web documents… – not all objects are public and so filtering out objects you can’t see can be expensive… text search. Such as finding the goods from the given group or Finding all Males looking for Females…
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… can’t 
. I’ll have to lab it out and see what I find. Its one of thoses cases though where I’m honestly curious. Usually I’m pretty good at figuring out where the bottleneck…
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… can’t . I’ll have to lab it out and see what I find. Its one of thoses cases though where I’m honestly curious. Usually I’m pretty good at figuring out where the bottleneck…
