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.

add ssd drive and move mysql datadir

Discussion in 'Workarounds and Optimization' started by alexistkd, Jun 19, 2016.

  1. alexistkd

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi i was wondering if worth it to add a ssd drive to my dedicated server setup, im using it as shared hosting for more than 100 clients with litespeed + cloudlinux + mariadb here the mysqltuner.pl report and server specs:

    E3-1240v3 (3.4Ghz Quad Core + HT)
    32 GB ECC DDR3
    RAID1 2x2TB


    Code:
    -------- Performance Metrics -----------------------------------------------------------------------
    [--] Up for: 10d 15h 25m 53s (69M q [76.036 qps], 1M conn, TX: 518G, RX: 12G)
    [--] Reads / Writes: 96% / 4%
    [--] Binary logging is disabled
    [--] Physical Memory     : 31.2G
    [--] Max MySQL memory    : 3.6G
    [--] Other process memory: 3.0G
    [--] Total buffers: 806.0M global + 3.7M per thread (800 max threads)
    [--] P_S Max memory usage: 0B
    [--] Galera GCache Max memory usage: 0B
    [OK] Maximum reached memory usage: 1.1G (3.64% of installed RAM)
    [OK] Maximum possible memory usage: 3.6G (11.67% of installed RAM)
    [OK] Overall possible memory usage with other process is compatible with memory available
    [OK] Slow queries: 0% (12K/69M)
    [OK] Highest usage of available connections: 12% (98/800)
    [OK] Aborted connections: 0.00%  (28/1527060)
    [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
    [!!] Query cache may be disabled by default due to mutex contention.
    [OK] Sorts requiring temporary tables: 6% (117K temp sorts / 1M sorts)
    [!!] Joins performed without indexes: 65983
    [OK] Temporary tables created on disk: 25% (1M on disk / 7M total)
    [!!] Table cache hit rate: 0% (4K open / 423K opened)
    [OK] Open file limit used: 27% (4K/16K)
    [OK] Table locks acquired immediately: 99% (17M immediate / 17M locks)
    
    -------- Performance schema ------------------------------------------------------------------------
    [--] Performance schema is disabled.
    
    -------- ThreadPool Metrics ------------------------------------------------------------------------
    [--] ThreadPool stat is enabled.
    [--] Thread Pool Size: 8 thread(s).
    [--] Using default value is good enough for your version (10.0.25-MariaDB)
    
    -------- MyISAM Metrics ----------------------------------------------------------------------------
    [!!] Key buffer used: 19.1% (76M used / 402M cache)
    [OK] Key buffer size / total MyISAM indexes: 384.0M/255.4M
    [OK] Read Key buffer hit rate: 99.5% (255M cached / 1M reads)
    [!!] Write Key buffer hit rate: 28.2% (3M cached / 2M writes)
    
    -------- AriaDB Metrics ----------------------------------------------------------------------------
    [--] AriaDB is enabled.
    [OK] Aria pagecache size / total Aria indexes: 128.0M/1B
    [OK] Aria pagecache hit rate: 98.5% (20M cached / 307K reads)
    
    -------- InnoDB Metrics ----------------------------------------------------------------------------
    [--] InnoDB is enabled.
    [!!] InnoDB buffer pool / data size: 150.0M/853.1M
    [!!] InnoDB buffer pool <= 1G and innodb_buffer_pool_instances(!=1).
    [OK] InnoDB Used buffer: 89.33% (8575 used/ 9599 total)
    [OK] InnoDB Read buffer efficiency: 99.87% (4033436271 hits/ 4038496411 total)
    [!!] InnoDB Write Log efficiency: 75.92% (1312269 hits/ 1728521 total)
    [OK] InnoDB log waits: 0.00% (0 waits / 416252 writes)
    
    -------- TokuDB Metrics ----------------------------------------------------------------------------
    [--] TokuDB is disabled.
    
    -------- Galera Metrics ----------------------------------------------------------------------------
    [--] Galera is disabled.
    
    -------- Replication Metrics -----------------------------------------------------------------------
    [--] Galera Synchronous replication: NO
    [--] No replication slave(s) for this server.
    [--] This is a standalone server.
    i can get a ssd of 120GB for just 10$ per month additional
     
  2. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,577
    Likes Received:
    40
    Trophy Points:
    48
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    Do you need to? no
    do you want to? yes

    if your MySQL server is running a lot of queries you will defiantly see a performance boost
    But your MySQL tuner results show your servers not working up a sweat yet
     
    alexistkd likes this.
  3. alexistkd

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    you think is not worth it then? its a good deal in term of price i wont see any difference between now and after with ssd? what you think?

    thank you

     
  4. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,577
    Likes Received:
    40
    Trophy Points:
    48
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    depends on how big your databases are only $10
    go for it
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  6. Jeff P.

    Jeff P. Member

    Joined:
    Feb 2, 2016
    Messages:
    24
    Likes Received:
    5
    Trophy Points:
    3
    Location:
    Palm Coast, Fl
    cPanel Access Level:
    DataCenter Provider
    My setup is:
    1 ssd for /
    1 ssd for /var/lib/mysql
    1 ssd for /home
    1 sata for /backup

    This not only gives you HUGE performance, but if Linux crashes or the main drive burns out, you lost nothing critical. Just replace drive and restore image if your host allows you to create backup images.

    In case anyone does this... read:

    After you make your partitions, here are the only steps you need... THE RIGHT WAY.

    The proper way to move MySQL to a second drive.
     
Loading...

Share This Page