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.

Innodb works in Mysql 5.1 whether or not the innodb plugin, ha_innodb_plugin.so is loaded at startup or not. Configuration dependent of course.

What are the advantages and disadvantages of either using or not using the builtin or modular innodb features?

Thanks very much for any explanation :)

share|improve this question

1 Answer 1

up vote 1 down vote accepted

The InnoDB plugin came into existence in MySQL 5.1 since version 5.1.38.

Many new features in the plugin allow you to

You are better off upgrading to MySQL 5.6 which has surpassed MySQL 5.1/5.5 because in 5.6

  • you can dump the buffer pool to disk on shutdown and reload it on startup
  • you can segment the buffer pool into buffer pool instances to help prevent swapping if the buffer pool is more than 50% of installed RAM

I would suggest you upgrade to MySQL 5.6 instead of dealing with enabling the old 5.1 plugin

share|improve this answer
    
+1 Another good feature of the InnoDB plugin is fast index creation. –  Bill Karwin Sep 27 '13 at 0:55

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.