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.

Where is MySQLTuner script?

Discussion in 'Workarounds and Optimization' started by Wabun, Aug 6, 2014.

  1. Wabun

    Wabun Well-Known Member

    Joined:
    Oct 6, 2012
    Messages:
    56
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Antwerpen
    cPanel Access Level:
    Root Administrator
    Dear support,

    I am trying to find the mysqltuner.pl script to find out about what to tweak in mysql.
    I have converted the server to ClouLinux and have some issues, when trying to install it with yum I get:

    ]# yum install mysqltuner
    Loaded plugins: fastestmirror, rhnplugin
    Loading mirror speeds from cached hostfile
    * cloudlinux-x86_64-server-6: cl-mirror.krystal.co.uk
    Setting up Install Process
    No package mysqltuner available.
    Error: Nothing to do

    cPanel version, CLOUDLINUX 6.5 x86_64 WHM 11.42.1 (build 25)

    How to proceed to install?
    Thank you.
     
  2. Wabun

    Wabun Well-Known Member

    Joined:
    Oct 6, 2012
    Messages:
    56
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Antwerpen
    cPanel Access Level:
    Root Administrator
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  4. Wabun

    Wabun Well-Known Member

    Joined:
    Oct 6, 2012
    Messages:
    56
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Antwerpen
    cPanel Access Level:
    Root Administrator
    IC, but CL replaced your versions of MySQL, are they supporting the mysqltuner?
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Is there any reason you prefer not to use the utility referenced in my first response, or do you prefer to simply have the file uploaded to your server by default on new installations? You could open a feature request for that via:

    Submit A Feature Request

    I don't know of any plans for CL to include a MySQL tuner as part of their software.

    Thank you.
     
  6. Wabun

    Wabun Well-Known Member

    Joined:
    Oct 6, 2012
    Messages:
    56
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Antwerpen
    cPanel Access Level:
    Root Administrator
    Hi, it is just that I am unsure now, Apache become unresponsive and this early morning Apache and MySQL issues, I contacted CL they say, no high load on server so it must be an issues with and then they sum up a lot of possiblities, one of them is MySQL tweak, I knew from past mySQLTuner, but I understand you dropped it, and CL replaced MySQL with their version, so I don't want to break anything, I want to find the culprit of my problems and thought to start with MySQL because of the errors:

    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Too many connections'

    /etc/cron.hourly/modsecparse.pl:

    DBI connect('modsec:localhost','modsec',...) failed: Too many connections at /etc/cron.hourly/modsecparse.pl line 20
    Unable to connect to mysql database at /etc/cron.hourly/modsecparse.pl line 20.

    cat /etc/my.cnf
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    slow_query_log=/var/lib/mysql/slow.log

    local-infile=0

    character-set-server=utf8
    collation-server=utf8_general_ci
    default-storage-engine=MYISAM

    innodb_file_per_table=1

    open_files_limit=99999

    [mysql.server]
    user=mysql

    [mysqld_safe]
    log-error=/var/lib/mysql/mysqld.log

    [client]
    default-character-set=utf8

    It looks like I need to add the amount of open connections, but wanted to see what the tuner tells me about how many. Unless there is an other way to find out how many?


    Will start with this, that gives me time to find out if it is safe to run.

    open_files_limit=9999
    max_connections=5000
    max_user_connections=300


    Kind regards
     
    #7 Wabun, Aug 6, 2014
    Last edited: Aug 6, 2014
Loading...

Share This Page