Skip to main content

add ssd drive and move mysql datadir

alexistkd
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
-------- 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

Comments

5 comments

Date Votes
  • dalem
    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
    0
  • alexistkd
    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
    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

    0
  • dalem
    depends on how big your databases are only $10 go for it
    0
  • cPanelMichael
    Hello, You may also find the following discussion of this topic helpful: SSD vs HDD for databases Thank you.
    0
  • Jeff P.
    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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post