Want to subscribe to topics you're interested in?
Become a Member

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:
    10:50 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

    55,163
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    5:20 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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