Kevin Minnick
My life, my career, my interests....
Friday, August 03, 2007
MySQL Performance Tuning Tip
Set these values in my.cnf:
innodb_buffer_pool_size=128M
key_buffer_size=128M
query_cache_size=32M
I've seen big performance boosts by setting these values.
Newer Post
Older Post
Home
About Me
Kevin Minnick
View my complete profile
Books I'd Recommend
The Nine: Inside the Secret World of the Supreme Court
The Kite Runner
Now, Discover Your Strengths
Differentiate or Die
The Tipping Point
Trout on Strategy
Peopleware
The Pragmatic Programmer
Summer of '49
The Ultimate Question
Inside Intuit
Martha Stewart's Homekeeping Handbook
User Interface Design for Programmers
First, Break All the Rules
How to Win Friends and Influence People
High Performance MySQL
Purple Cow
Moneyball
Version Control with Subversion
Rapid Development
Who Moved My Cheese?
One Minute Manager
The Mythical Man-Month
Blog Archive
►
2009
(1)
►
July
(1)
►
2008
(2)
►
January
(2)
▼
2007
(31)
►
December
(2)
►
November
(1)
►
October
(2)
►
September
(1)
▼
August
(6)
Book Review: The Tipping Point
Flow
How much memory is free?
vmstat
MySQL Performance Tuning Tip
Outlook 2003 + Vista - Outlook 2007 Trial = DLL Hell
►
July
(4)
►
June
(2)
►
May
(2)
►
April
(2)
►
March
(4)
►
February
(3)
►
January
(2)
►
2006
(92)
►
December
(5)
►
November
(11)
►
October
(9)
►
September
(17)
►
August
(6)
►
July
(8)
►
June
(6)
►
May
(8)
►
April
(5)
►
March
(4)
►
February
(4)
►
January
(9)
►
2005
(29)
►
December
(1)
►
November
(3)
►
October
(2)
►
September
(2)
►
August
(4)
►
July
(3)
►
June
(4)
►
May
(4)
►
April
(2)
►
March
(4)