… SSD, in my last post I mentioned that SATA SSD performance is getting closer to PCIe cards. It really makes sense… under MySQL workload, but before getting to that, let me review the same workload on Fusion-io ioDrive PCIe card. This…
Post: Tools to use for MySQL Performance Review
May 31, 2008 By 3 Comments
There are some tools we commonly use doing performance review and optimization and we often ask each other where that … public instead. So now you can find our favorite MySQL Performance Review Tools on the site. This is just list of tools… on Open Source tools which are helpful for “in time” performance audit – for example you see no graphing software in this…
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
… their goals to distinguish themselves from their competitors: Stability of performance: That is to minimize variations in throughput Better response times… is very important for database performance and I appreciate that Virident has made this a priority. Performance at full capacity: As we… consulting practice for which we compensated by Virident. However, this review was written independently of Virident, and reflects our opinion of…
Post: How we work on High Performance MySQL Second Edition
November 12, 2007 By 12 Comments
… to write most of chapters which get further in depth review by me and examples benchmarks and further details added by… progress and getting close to technical review. This is another interesting part. Book needs good reviewers and reviewers with different backgrounds both to… much money in the book budget which is spent on review process. Anyway it is exciting to book getting close and…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… decide on couple few questions on how to tackle application performance. These questions are: Should we Optimize Application or get more… and you probably do not want to need consultants to review every simple query you design. Getting low hanging fruit is… – even if your local resources have created the system which performing well getting experts which may have ideas how to optimize…
Post: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
… working on major rewrite of High Performance MySQL book – the most famous book about MySQL Performance on the market… which is getting… another competent point of view. Baron has a experience in performance optimization for MySQL and other databases which gives a very…. We also will be looking for reviewers. Let us know if you’re interested in reviewing one or more chapters. We’ll…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…Note: Review was done as part of our consulting practice, but is … at a given incoming data rate, enabling much higher query performance. Beside iiBench we run benchmarks of SELECT queries again one… can be from simple apache logs put into mysql, application performance logs to more complex log like clicks, user movements and…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
… for relationship building. It is great for architecture design and review as you can sit down with the team and use… valuable as a kick off to do application redesign, for performance review or for starting long term Remote DBA or support relationships…
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
… systems, typically web sites, which means we help customers with performance, scalability, high availability as the whole, not just MySQL related… services we are able to help to deliver great performing web sites whatever performance limiting factors are. P.S As this is… a note and we’ll pick couple of sites to review free of charge.
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well… default as transaction-isolation=READ-COMMITTED. This option has some performance benefits, especially in locking in 5.0 and even more… performance. Next if your application has any writes be prepared to handle deadlocks which may happen. Third you would like to review…
