# key efficiency

**URL:** <https://forums.percona.com/t/key-efficiency/3702>\
**Category:** Other MySQL® Questions\
**Created:** [August 27, 2014, 8:46am UTC](https://forums.percona.com/t/key-efficiency/3702 "2014-08-27T08:46:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robin](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@Robin](https://forums.percona.com/u/Robin)\
**Post date:** [August 27, 2014, 8:46am UTC](https://forums.percona.com/t/key-efficiency/3702/1 "2014-08-27T08:46:59Z")

</div>

My key efficiency stays at 0%. We tried changing the innodb\_buffer\_pool\_size but that doen’t seem to help. The website itself runs smoothly but the 0% key efficiency has me worried.

Running ubuntu 14.04  
mysql 5.6

sql.cnf:  
​-------------------------------------------------------------------------------- [mysql]

# CLIENT

port = 3306  
socket = /var/run/mysqld/mysqld.sock

[mysqld\_safe]  
socket = /var/run/mysqld/mysqld.sock  
nice = 0

[mysqld]

skip-name-resolve  
skip-external-locking

# GENERAL

user = mysql  
default\_storage\_engine = InnoDB  
socket = /var/run/mysqld/mysqld.sock  
pid\_file = /var/run/mysqld/mysqld.pid

# MyISAM

key\_buffer\_size = 32M  
myisam\_recover = FORCE,BACKUP

# SAFETY

max\_allowed\_packet = 16M  
max\_connect\_errors = 1000000

# DATA STORAGE

datadir = /var/lib/mysql

# CACHES AND LIMITS

tmp\_table\_size = 32M  
max\_heap\_table\_size = 32M  
query\_cache\_type = 1  
query\_cache\_size = 16M  
max\_connections = 500  
thread\_cache\_size = 50  
open\_files\_limit = 65535  
table\_definition\_cache = 1024  
table\_open\_cache = 2048

# INNODB

innodb\_flush\_method = O\_DIRECT  
innodb\_log\_files\_in\_group = 2  
innodb\_log\_file\_size = 64M  
innodb\_flush\_log\_at\_trx\_commit = 2  
innodb\_file\_per\_table = 1  
innodb\_buffer\_pool\_size = 592M

# LOGGING

log\_error = /var/log/mysql/mysql\_error.log  
log\_queries\_not\_using\_indexes = 1  
slow\_query\_log = 1  
slow\_query\_log\_file = /var/log/mysql/mysql\_slow.log

!includedir /etc/mysql/conf.d/

* * *

All help is much appriciated

---

<div class="post-metadata">

**Author:** ![psong](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/psong/32/16894_2.png) [@psong](https://forums.percona.com/u/psong)\
**Post date:** [August 29, 2014, 1:27am UTC](https://forums.percona.com/t/key-efficiency/3702/2 "2014-08-29T01:27:17Z")

</div>

Hi Robin, did you get the Key efficiency from MySQL Workbench? That should be a measure of MyISAM key cache efficiency, calculated by Key\_reads/Key\_read\_requests. If you are not using MyISAM tables, you can safely ignore it.