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!

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

Discussion in 'Database Discussion' 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)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 whr, Oct 30, 2014
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,699
    Likes Received:
    1,790
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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:
    170
    cPanelMichael
    Jan 9, 2018
  2. srikanta159

    MySql Process taking too much ram

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

    Upgrade from MySQL 5.6 to MariaDB - how much downtime?

    stormy, Sep 27, 2016, in forum: Database Discussion
    Replies:
    5
    Views:
    918
    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:
    112
    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:
    207
    cPanelMichael
    Dec 11, 2017

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice