debugsqlModerate
ERROR - Function 'innodb' already exists
Viewed 0 times
errorinnodbfunctionalreadyexists
Problem
I'm looking to start converting some MyISAM tables to INNODB. Running Ubuntu 14.04 Server with MySQL 5.6 ( apt-get upgraded from 5.5 ), 32G ram on 4 core/ 8 thread cpu. Initially had trouble with...
and
I followed Rolando's posted advice and the DB isn't crashing or creating a huge error.log anymore.
( the above issues are gone, just describing leading events )
Now I'm concerned about the following errors before I convert anything to INNODB. Federated can be ignored from what I read, the second line below ( also the subject of this post ) concerns me
added the following to my.cnf from Rolando's posted advice
Wasn't sure if there should be anything else INNODB related. Based on what I could find also added
That didn't help. No
could not open single-table tablespace file .\mysql\innodb_index_stats.ibd after restart of MySQLand
Error: Table "mysql"."innodb_table_stats" not found.I followed Rolando's posted advice and the DB isn't crashing or creating a huge error.log anymore.
( the above issues are gone, just describing leading events )
Now I'm concerned about the following errors before I convert anything to INNODB. Federated can be ignored from what I read, the second line below ( also the subject of this post ) concerns me
2014-05-19 01:50:57 30950 [Note] Plugin 'FEDERATED' is disabled.
2014-05-19 01:50:57 30950 [ERROR] Function 'innodb' already exists
2014-05-19 01:50:57 30950 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2014-05-19 01:50:57 30950 [ERROR] Function 'federated' already exists
2014-05-19 01:50:57 30950 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2014-05-19 01:50:57 30950 [ERROR] Function 'blackhole' already exists
2014-05-19 01:50:57 30950 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2014-05-19 01:50:57 30950 [ERROR] Function 'archive' already exists
2014-05-19 01:50:57 30950 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.added the following to my.cnf from Rolando's posted advice
innodb_buffer_pool_size=4G
innodb_buffer_pool_instances=2
innodb_read_io_threads=12
innodb_write_io_threads=12
innodb_io_capacity=300
innodb_log_file_size=128MWasn't sure if there should be anything else INNODB related. Based on what I could find also added
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1That didn't help. No
Solution
The plugins throwing errors in the error.log were not specifically specified in my.cnf. So I ran...
for MySQL 5.6.17 I deleted the following rows in mysql.plugin
Do not delete anything you are not sure about. The above worked for me as...
select * from mysql.pluginfor MySQL 5.6.17 I deleted the following rows in mysql.plugin
innodb ha_innodb.so
federated ha_federated.so
blackhole ha_blackhole.so
archive ha_archive.soDo not delete anything you are not sure about. The above worked for me as...
- I do not use Federated ( accesses data in tables of remote databases )
- INNODB is built into 5.6, no plugin required
- I do not use Blackhole ( accepts data but throws it away and does not store it )
- I do not use Archive ( storing large amounts of data without indexes in a very small footprint )
Code Snippets
select * from mysql.plugininnodb ha_innodb.so
federated ha_federated.so
blackhole ha_blackhole.so
archive ha_archive.soContext
StackExchange Database Administrators Q#65397, answer score: 15
Revisions (0)
No revisions yet.