Category Archives: Common Mistakes

Be Wary of Large Log File Sizes

As some people have mentioned here and here Increasing the innodb log file size can lead to nice increases in performance. This is a trick we often deploy with clients so their is not anything really new here. However their … Continue reading

Posted in 5 minute dba, Common Mistakes, Matt, mysql, performance | 1 Comment

MySQL Connector J and the curse of Autocommit

In my travels I do a lot of analysis of the slow query and the general query logs. In many Java shops I end up seeing the most frequently called command is set autocommit=1; Sometimes this statement is called 300-400x … Continue reading

Posted in Common Mistakes, jdbc, Matt, mysql, performance | 3 Comments

MySQL Memory allocation & TMPDIR

A quick one here, we often talk about effectively utilizing memory to get the most of your MySQL Server.  I wanted to remind folks to not forget about allocating memory to a tmpfs for the tmpdir.  Certainly this is not … Continue reading

Posted in Common Mistakes, hardware, mysql, performance | 14 Comments

The importance of network latency in application performance – part 2

I harped on this earlier this month. The network is an often over looked, but vital component of every application. I have been in many shops content with running 100Mb/s between the application and database simply because they are no … Continue reading

Posted in Common Mistakes, mysql, performance | 1 Comment

The Importance of solid historical LAMP Statistics

An often overlooked and way underrated component to any site is the collection and reporting of solid historical performance metrics.   Don’t get me wrong, everyone collects some sort of web page stats, has access to mysql status variables, and uses … Continue reading

Posted in Common Mistakes, mysql, Other dbs, performance | Comments Off on The Importance of solid historical LAMP Statistics

The hidden performance bottleneck: Network

A quick note… As mentioned several times here, hardware can not be treated as a black box.  Every mysql professional who is charged with performance tuning has to understand where often overlooked bottlenecks can occur. This can occur anywhere in … Continue reading

Posted in Common Mistakes, mysql, performance | 1 Comment

A Word about Simple MySQL Problem Detection and Benchmarking

One of the services we (Sun/MySQL) offer is a Performance Tuning and Optimization consulting package. These consulting engagements generally take several different forms as each client has a specific need that must be resolved. But there is a commonality between … Continue reading

Posted in Common Mistakes, mysql, performance, rant | Comments Off on A Word about Simple MySQL Problem Detection and Benchmarking

Single Innodb Datafile vs Multiple datafiles

Over the past couple of months I have seen a few different clients with innodb setup to have multiple datafiles opposed to using file per table or a single datafile. While I generally do not think twice about a handful … Continue reading

Posted in Common Mistakes, mysql, performance | 3 Comments

Follow up to my Common Disk Issues

Ahh seems like a few people do take the time to read my blog:) Peter Z Commented here on my common disk performance mistakes post. He makes some great arguments, and you may want to give it a read. While … Continue reading

Posted in Common Mistakes, hardware, mysql, performance | 3 Comments

Common Performance Mistakes: Disk

  Over the past several years whether I am working with a small company or a fortune 500 client I have seen lots of issues and mistakes made around the configuration, setup, and ongoing maintenance of disk on Unix and … Continue reading

Posted in Common Mistakes, mysql, performance | 4 Comments