SmartCJ Support Forum

Hi,
As suggested when tuning mysql all rot_* tables were converted into InnoDB, but there are other tables as you can see in the list below that are in Innodb cause during setup automatically they are in the Innodb format.My question is would it help to reduce memory utilized for caching if all the others tables other than the rot_* tables are converted into MyISAM? Would it be safe to convert these tables on a high traffic site? Below is the list of the tables and format.

admins - InnoDB
admin_access_log - InnoDB
admin_sessions - MyISAM
blacklist - InnoDB
bookmarks - MyISAM
browsers - MyISAM
countries - InnoDB
day - MyISAM
day_last_hour - MyISAM
forces - MyISAM
functions_data - MyISAM
ga_categories - InnoDB
ga_sites - MyISAM
history - MyISAM
inrules - InnoDB
ips - MyISAM
language - MyISAM
links - MyISAM
outrules - InnoDB
out_ips - MyISAM
out_ips2trader - MyISAM
quality_settings - InnoDB
refs - MyISAM
reports - InnoDB
rot_cell_data - InnoDB
rot_cell_skimming - InnoDB
rot_comments - InnoDB
rot_content - InnoDB
rot_crop_profiles - InnoDB
rot_gal2group - InnoDB
rot_gal2model - InnoDB
rot_gal2tag - InnoDB
rot_galleries - InnoDB
rot_gallery_data - InnoDB
rot_gallery_info - InnoDB
rot_gallery_stats - InnoDB
rot_groups - InnoDB
rot_groups_data - InnoDB
rot_import_sets - InnoDB
rot_linked_db - InnoDB
rot_models - InnoDB
rot_pages - InnoDB
rot_page_items - InnoDB
rot_replacements - InnoDB
rot_search_queries - InnoDB
rot_servers - InnoDB
rot_settings - InnoDB
rot_sponsors - InnoDB
rot_sponsors_data - InnoDB
rot_tags - InnoDB
rot_users - InnoDB
rot_user_fav - InnoDB
script_messages - InnoDB
settings - InnoDB
skim_rules - InnoDB
tds_rules - MyISAM
tds_schemes - MyISAM
toplists - InnoDB
traders - InnoDB
trader_groups - InnoDB
trader_plugs - MyISAM

Please let me know and appreciate the help.

Regards,

Those tables that are in Innodb format by default are pretty small, few Mb, so converting them won't help much.

Thanks for the clarification.

NP