I'm having troubles replicating memory tables because these are randomly breaking my replication with the following error:
Could not execute Delete_rows_v1 event on table mydb.xf_session_activity; Can't find record in 'xf_session_activity', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND;
xengallery_album_view xengallery_media_view xf_attachment_view xf_session_activity xf_thread_view xf_tinhte_xentag_tag_view
Option 2. Is it performance-wise and safe to convert those tables from MEMORY to InnoDB? Note that I have plenty of RAM on the server and a well tuned my.cnf file... while I understand that nothing beats the RAM speed, is there going to be a significant negative impact if I convert those tables to InnoDB?
Which option is more convenient?