try setting storage_engine to myisam