MySQL Performance: MySQL => key_buffer

Members

Help

Home

Home » Performance » MySQL » key_buffer_size > indexes' size?

Show: Today's Messages :: Show Polls :: Message Navigator

key_buffer_size > indexes' size? [message #1711]

Sun, 02 September 2007 11:47

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

[Message index]

Read Message key_buffer_size > indexes' size?
By: jcn50 on Sun, 02 September 2007 11:47

Re: key_buffer_size > indexes' size?
By: Peter on Mon, 03 September 2007 08:26

Re: key_buffer_size > indexes' size?
By: allworknoplay on Sat, 08 September 2007 14:20

Previous Topic: Insert performance question

Next Topic: Tuning table indexes with large datasets and frequent index updates

Goto Forum:

-=] Back to Top [=-

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

]

Current Time: Fri Jul 10 04:09:36 EDT 2009

Total time taken to generate the page: 0.02724 seconds

.:: Contact :: Home ::.

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.