Page 1 of 1

MySQL MEMORY

PostPosted: Thu Dec 05, 2013 8:53 am
by phil_discount
Hi guys,

is it a problem to convert some tables from myisam to MEMORY?
- vicidial_auto_calls
- vicidial_manager
- vicidial_live_agents
I've got 100GB RAM ..

regards
Philip

Re: MySQL MEMORY

PostPosted: Thu Dec 05, 2013 8:05 pm
by mflorell
You will have to convert some TEXT fields to CHAR to do that, but it will work. We've done it before. You need to plan out your RAM usage, and make sure those TEXT fields are only as big as they need to be for your specific installation, or moving to MEMORY could actually slow down your database.