1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

DB to RAM

Discussion in 'Server Configuration and Hosting' started by Anton_Bodryachkom, Apr 15, 2015.

  1. Anton_Bodryachkom

    Anton_Bodryachkom Active Member

    Hello forum , is it possible to load full DB to RAM ? ( Our DB close to 1g )
    Would it be beneficial for performance?

    If yes , any suggestion for this solution
    thnk you in advance
     
  2. Tracy Perry

    Tracy Perry Well-Known Member

  3. Anton_Bodryachkom

    Anton_Bodryachkom Active Member

    thnx man , will read
     
  4. Anton_Bodryachkom

    Anton_Bodryachkom Active Member

    Looks like not a good idea , as it tricky with backing up date .
    Will try query_cache for MySQL

    thnx
     
  5. Ernest L. Defoe

    Ernest L. Defoe Well-Known Member

    Something else that will also help with speed which I am sure you already know is run your mySQL server on a SSD drive.
     
  6. Anton_Bodryachkom

    Anton_Bodryachkom Active Member

    yes we on ssd
     
  7. Ernest L. Defoe

    Ernest L. Defoe Well-Known Member

    Using stock mySQL or something better like Percona or MariaDB?
     
  8. Anton_Bodryachkom

    Anton_Bodryachkom Active Member

  9. Ernest L. Defoe

    Ernest L. Defoe Well-Known Member

    You would be better to switch to either Percona or MariaDB. I've heard Percona is better but I'm no server guru I know my host uses it. That will make things faster from a SQL standpoint. Percona is just a drop in replacement for mySQL. Again others can advise better than me on that though.
     

Share This Page