Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » key_buffer_size > indexes' size?
icon3.gif  key_buffer_size > indexes' size? [message #1711] Sun, 02 September 2007 11:47 Go to next message
jcn50
Messages: 44
Registered: September 2007
Member
Hello all,


First of all: thanks for this great forum! Very Happy

I was wondering if the key_buffer_size should always be superior to the total size of all indexes?...

For example, let's say all my indexes takes a 16M space, should I tweak the key_buffer_size to 17M?


Thanks!

[Updated on: Sun, 02 September 2007 12:05]

Enjoy the Net!
Report message to a moderator
Re: key_buffer_size > indexes' size? [message #1724 is a reply to message #1711 ] Mon, 03 September 2007 08:26 Go to previous messageGo to next message
Peter is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
It depends on a lot of factors.

If your key buffer is bigger than index it means all your index will fit in key cache, which is good. This is however impossible for large databases.

Plus you need to think about other needs - innodb buffer pool, memory for OS to cache MyISAM table data etc.

If you have memory for all of these sure go ahead and do it.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Report message to a moderator
Re: key_buffer_size > indexes' size? [message #1767 is a reply to message #1711 ] Sat, 08 September 2007 14:20 Go to previous message
allworknoplay is currently offline allworknoplay
Messages: 58
Registered: September 2007
Location: New York
Member
I wish my indexes only totaled up to 16megs!!!

Very Happy Very Happy Very Happy Very Happy
Report message to a moderator
Previous Topic:Insert performance question
Next Topic:Tuning table indexes with large datasets and frequent index updates
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 03:51:36 EDT 2009

Total time taken to generate the page: 0.01570 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.