Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Too much MySQL writting to the HDD, how to offload writting?

Discussion in 'Database Discussions' started by postcd, Oct 29, 2014.

  1. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    662
    Likes Received:
    11
    Trophy Points:
    68
    I have optimised mysql configuration i think quite good, but there are queries that i believe canot be cached in RAM (i have plenty of free RAM), but use HDD swap?

    My result:
    Can i anyhow offload mysql HDD writting/(swapping?) on other HDD/server without physically moving mysql databases causing more than 40 seconds downtime to one website?

    WHM feature "Setup Remote MySQL Server" do not offload existing mysqls unless i transfer them to new server, and as i say i dont want bigger downtime. Also it sounds better 4me to have all at one server. thx

    PS, one possibility is googling "MySQL tmpdir on a RAM disk", these two tutorials looks good:
    http://www.fromdual.com/mysql-tmpdir-on-ram-disk
    http://2bits.com/articles/reduce-your-servers-resource-usage-moving-mysql-temporary-directory-ram-disk.html
    (issue is i dont know hot to prevent case mysql want to write more data then is ramdisc size)
     
    #1 postcd, Oct 29, 2014
    Last edited: Oct 29, 2014
  2. whr

    whr Active Member

    Joined:
    Jul 25, 2009
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    India
    If you can afford a little downtime, get an SSD disk and move the entire database folder there. Then symlink it to the actual location. SSD drives are good in handling higher read/write cycles.
     
    #2 whr, Oct 30, 2014
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,372
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Note that the following post might be helpful if you plan on implementing the steps suggested on the previous post:

    Moving MySQL Data Location

    Thank you.
     
    #3 cPanelMichael, Oct 30, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - much MySQL writting
  1. srikanta159

    MySql Process taking too much ram

    srikanta159, Sep 5, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    97
    cPanelMichael
    Sep 6, 2017
  2. stormy

    Upgrade from MySQL 5.6 to MariaDB - how much downtime?

    stormy, Sep 27, 2016, in forum: Database Discussions
    Replies:
    5
    Views:
    529
    stormy
    Sep 30, 2016
  3. adam987123

    Incremental Backups taking up too much space

    adam987123, Aug 23, 2017, in forum: Data Protection
    Replies:
    13
    Views:
    259
    tui
    Sep 23, 2017 at 1:30 PM
  4. wafaa

    IMAP consuming so much bandwidth

    wafaa, Jul 26, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    221
    cPanelMichael
    Jul 27, 2017
  5. Tommy Pro

    cPhulkd Error Log takes too much space

    Tommy Pro, Jul 17, 2017, in forum: General Discussion
    Replies:
    13
    Views:
    202
    cPanelMichael
    Jul 26, 2017

Share This Page