Where is MySQLTuner script?

Wabun

• August 06, 2014 08:49

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.

• 

  cPanelMichael

  • August 06, 2014 14:05

  Hello :) You may find the following thread helpful: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0
• 

  Wabun

  • August 06, 2014 14:21

  Thanks for the reply, does that mean cPanel is not adding the mysqltuner any more? The link to the cPanel Application tool

  0
• 

  cPanelMichael

  • August 06, 2014 14:25

  Yes, it was removed from cPanel per internal case number 90317 because it does not support the versions of MySQL we provide. Thank you.

  0
• 

  Wabun

  • August 06, 2014 15:09

  IC, but CL replaced your versions of MySQL, are they supporting the mysqltuner?

  0
• 

  cPanelMichael

  • August 06, 2014 15:24

  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.

  0
• 

  Wabun

  • August 06, 2014 15:36

  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

  0

Please sign in to leave a comment.