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:
    689
    Likes Received:
    14
    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:
    42,782
    Likes Received:
    1,712
    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. ahmad musa

    Script using too much MySQL resources

    ahmad musa, Jan 9, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    129
    cPanelMichael
    Jan 9, 2018
  2. srikanta159

    MySql Process taking too much ram

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

    Upgrade from MySQL 5.6 to MariaDB - how much downtime?

    stormy, Sep 27, 2016, in forum: Database Discussions
    Replies:
    5
    Views:
    844
    stormy
    Sep 30, 2016
  4. toplisek

    SOLVED How much ram your applications could use without swapping

    toplisek, Apr 3, 2018, in forum: Workarounds and Optimization
    Replies:
    2
    Views:
    73
    toplisek
    Apr 11, 2018
  5. albatroz

    How much time to expect for decompressing a 130GB backup file

    albatroz, Dec 10, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    183
    cPanelMichael
    Dec 11, 2017

Share This Page