LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 07-22-2008, 11:31 PM   #1
prolfe
LQ Newbie
 
Registered: Feb 2008
Posts: 10

Rep: Reputation: 0
Does Mysql InnoDB tales use Key Buffer?


I have a Mysql 5.0.51a server running a reasonable amount (approx 100 tables accross 9 databases) of InnoDB tables. No other storage engines are used.

In Mysql Administrator, under Health, the Key buffer usage is only 27,648. I have allocated 300mb of key buffer. This shows up in Administrator.

As a result, the hitrate is almost always on zero, with a running server. I would like to see eome key caching, as some statements are probalbly costing more than needed.

My tables all have keys, foreign keys and indexes configured. Many of the tables have over 100,000 records in them.

I have been anaylising the Slow query log and making key/ index adjustments as needed. But I still cant get my key buffer to work.

If I added up all of the indexes, it is several GB.

Using a simple exlain select statement with a where, I can see I am using an index. However continually executing the instruction does not make the hitrate go up.

Is it possible that InnoDB does not use this buffer?

The only tables that are not innodb is the Mysql database. I use international timezones and the key usage looks like Mysql is caching the keys only for the mysql database.
 
Old 07-23-2008, 10:44 AM   #2
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 256Reputation: 256Reputation: 256
The more advanced engines like InnoDB allocate their own global memory areas that are completely separate from MySQL’s key buffer, table cache, etc.

InnoDB buffer setting will look something like this:

Code:
set-variable = innodb_buffer_pool_size=256M
Because the buffer caches both record and index data, it’s likely that you’ll need to choose a buffer pool setting which is larger than the key buffer that you might have used for MyISAM or have used for that matter.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Innodb troubles Baltasar Linux - Software 1 04-20-2005 09:01 AM
MySQL & InnoDB riluve Linux - Software 0 03-13-2005 09:19 PM
Help mysql innodb recovery from .frm pig.2003 SUSE / openSUSE 0 11-10-2004 03:25 AM
Help mysql innodb recovery from .frm pig.2003 Linux - Software 0 11-10-2004 02:35 AM
InnoDB problem with MySQL jerry_redhat Linux - Software 2 07-09-2003 12:20 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 04:47 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration