Hi All,
I am Using OpenHAB 1.8.1 and leveraging the MySQL Tuning Primer Script to optimize my OpenHAB mySQL database. All fine, however, it tells me
KEY BUFFER
No key reads?!
Seriously look into using some indexes
Current MyISAM index space = 9 K
Current key_buffer_size = 16 K
Key cache miss rate is 1 : 0
Key buffer free ratio = 87 %
Your key_buffer_size seems to be fine
Now my question, do you get the same message and has anyone of you created the indexes? How?