Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a MySQL 5.0.77 instance running with three catalogs in it.

Two of the catalogs contain all InnoDB tables and are actively used.

The third is all MyISAM and is basically unused, and is only still in the server as a precaution. Basically, it is an old version of one of the other catalogs that used to be referenced to ensure that data migration was correct.

I have been running mysqltuner periodically so I can get a decent baseline configuration before I begin real profiling on whole system.

Even though I am not querying or even opening connections to the MyISAM catalog, is its presence throwing off the mysqltuner recommendations?

For example, can I truly ignore the warnings about key_buffer_size, or will bad values for this negatively impact the whole server even when I am not really using MyISAM?

Is having this unused catalog negatively impacting the memory footprint of the server? If so, is there any way to mitigate this, other than moving the catalog somewhere else and doing a DROP?

Thanks.

share|improve this question

migrated from serverfault.com Jan 3 '12 at 17:42

This question came from our site for professional system and network administrators.

1 Answer 1

up vote 1 down vote accepted

If you know that the MyISAM tables are not being actively queried, not only can you ignore recommendations for key_buffer_size, you could actually lower it.

What can you do with the extra RAM you just reclaimed? One or more of the following options:

After restarting mysqld, rerun mysqltuner and evaluate the resulting recommendations. Taking key_buffer_size out of the equation is enough in your instance.

share|improve this answer
    
Thanks, so assuming that I have a decent configuration, there is no significant penalty/overhead to keep the MyIASM catalogs online if I never query them? –  MPD Jan 3 '12 at 21:06
    
@MPD : That is Correct !!! –  RolandoMySQLDBA Jan 3 '12 at 21:07
    
Awesome, thanks. –  MPD Jan 3 '12 at 21:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.