Welcome to Centmin Mod Community
Register Now

MariaDB Optimization for my VDS

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Cr0w, Feb 3, 2016.

  1. Cr0w

    Cr0w Member

    165
    9
    18
    Mar 17, 2015
    Iran
    Ratings:
    +13
    Local Time:
    7:29 AM
    1.9.x
    5.5
    Recently i bought a VDS From a well-known Company .
    here are the information of my Server :
    Ram : 4 GB
    DISK : 100GB SATA3 , SAS
    HARDWARE : LSI 9471 RAID Controller - Raid 10, SAS
    PORT : 1Gbps Guaranteed
    DDOS PROTECTION : 1 Gbps / 500k PPS
    CPU : 2Core - IntelĀ® Core i7-3770- 3.9 GHz
    Bandwidth : UNLIMITED
    always i will install Centminmod by default configs ;)

    i make this thread to help me improve my server performance .
    Pleas share your my.cnf files here :-*
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,839
    6,903
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,393
    Local Time:
    1:59 PM
    Nginx 1.13.x
    MariaDB 5.5
    copying other folks my.cnf is useless as my.cnf needs to be tailored to your web apps' mysql usage patterns and only you know what they are

    i did write mysqlmymonlite.sh script to help folks gather such stats so they can analyse and log their usage stats over time mysqlmymonlite.sh Addon | Centmin Mod Community
     
    • Like Like x 1
    • Agree Agree x 1