Tag Info

New answers tagged


I try to avoid mixing MyISAM and InnoDB tables in the same database, but this is for sanity rather than practical reasons. However, I find it useful to have a database with MyISAM tables for fulltext search so I can run that on sites. Keeping it in a separate database with a foreign key for each entry makes it easy for any other developers working on the DB ...


There are two situations you must address SITUATION #1 : TABLES TO CREATE You must add this to my.cnf [mysqld] default-storage-engine=MEMORY Then, restart mysql (MariaDB) CAVEAT: This will not convert already existing tables to MEMORY tables. Why can do for those tables ? SITUATION #1 : TABLES ALREADY EXISTING Here is the script to convert all tables ...

Top 50 recent answers are included