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
MySQL MEMORY
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
2 posts
• Page 1 of 1
MySQL MEMORY
by phil_discount » Thu Dec 05, 2013 8:53 am
ViciBox Redux 3.0.5 | Vicidial 2.2.1-260 100527-2211 | Asterisk 1.4.27.1
9xVicidial 8-core 2.5GHz,4GB,SSD
4xWeb 4-core 2.5GHz,4GB,SSD
DB: 24-core-1.9GHz AMD,96GB,8xSSD Raid10
3xDBslave 4-core 2.5GHz,4GB,SSD (for SELECT: Reporting/LIVE)
400 seats
9xVicidial 8-core 2.5GHz,4GB,SSD
4xWeb 4-core 2.5GHz,4GB,SSD
DB: 24-core-1.9GHz AMD,96GB,8xSSD Raid10
3xDBslave 4-core 2.5GHz,4GB,SSD (for SELECT: Reporting/LIVE)
400 seats
- phil_discount
- Posts: 468
- Joined: Thu Jun 18, 2009 8:44 am
- Location: Deutschland/Schweiz/Österreich
Re: MySQL MEMORY
by mflorell » Thu Dec 05, 2013 8:05 pm
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.
- mflorell
- Site Admin
- Posts: 18387
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 139 guests