I am wondering whether the storage engine of MySQL should be InnoDB or MyISAM.
I noticed that it makes a lot of difference for the PubSub maintenance pool
This pool is basically a queue which inserts at regular time-intervals a batch of new published items into the ofpubsubitem table
When I use InnoDB it takes on avg 93 milliseconds for each insert (which is far too long)
Using MyISAM I easily insert 5000 records per second
Is MyISAM ok to use for OpenFire because MyISAM does not support transactions, row-level locking, and foreign keys (which InnoDB DOES support).
Will that lead to problems?