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:
    648
    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:
    36,394
    Likes Received:
    1,212
    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. stormy

    Upgrade from MySQL 5.6 to MariaDB - how much downtime?

    stormy, Sep 27, 2016, in forum: Database Discussions
    Replies:
    5
    Views:
    435
    stormy
    Sep 30, 2016
  2. Tommy Pro

    cPhulkd Error Log takes too much space

    Tommy Pro, Jul 17, 2017, in forum: General Discussion
    Replies:
    11
    Views:
    111
    cPanelMichael
    Jul 25, 2017 at 8:28 AM
  3. Lethe

    SOLVED cphulkd much too agressive

    Lethe, Jun 17, 2017, in forum: Security
    Replies:
    4
    Views:
    100
    Lethe
    Jun 19, 2017
  4. V3King

    /var folder taking too much space

    V3King, Dec 24, 2016, in forum: General Discussion
    Replies:
    5
    Views:
    386
    cPanelChrisI
    Dec 27, 2016
  5. watchdubbed.xyz

    ea-php70 Using too much CPU

    watchdubbed.xyz, Sep 11, 2016, in forum: EasyApache
    Replies:
    1
    Views:
    390
    cPJacob
    Sep 12, 2016

Share This Page