Stack Overflow
Stack Overflow

Questions tagged [mysqltuner]

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.

MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.

Compatibility:

  • MySQL 3.23, 4.0, 4.1, 5.0, 5.1 (full support)
  • MySQL 5.4 (not fully tested, partially supported)
  • MySQL 6.0 (partial support)
  • MariaDB 10.x (partial support)
  • Perl 5.6 or later (with perl-doc package)
  • Unix/Linux based operating system (tested on Linux, BSD variants, and Solaris variants)
  • Windows is not supported at this time
  • Unrestricted read access to the MySQL server (OS root access recommended for MySQL < 5.0)
52 questions
0
votes
1 answer

Mysqltuner optimize config and tables, report

Report from mysqltuner, can you help me ? how to disable InnoDB ist last Linux debian mysql version on stable, and conection aborted on more than 30%? [!!] InnoDB is enabled but isn't being used [OK] Total fragmented tables: 0 -------- Performance…
DaEaaL
  • 3
  • 3
0
votes
1 answer

How can i optimize MariaDB's my.cnf file? (with mysqltuner result)

I am using MariaDB & Apache (LAMP) and my VPS Ram is 512MB. Now the problem is sometimes when i use top, the MariaDB process is using 506MB of RAM so i want to optimize my MariaDB. Here is my ./mysqltuner.pl's result: [!!] Currently running…
He Yifei 何一非
  • 2,592
  • 4
  • 38
  • 69
0
votes
1 answer

mysqltuner - Sorts requiring temporary tables

I'm new to stackoverflow, so that's my first shot :) I have an issue with my Mysql DB. I was running into some performance issues, so i decided to use mysqltuner. The Result is [--] Up for: 7m 42s (7K q [16.452 qps], 78 conn, TX: 927K, RX: 2M) [--]…
user3531962
  • 1
  • 1
0
votes
1 answer

How can I find the SQL queries that are creating temporary tables on disk?

I got a job maintaining a high traffic webapp that uses MySQL. I'm using MySQLTuner, a Perl script that makes recommendations to improve MySQL performance. Recently I've been getting the following error from MySQLTuner: [!!] Temporary tables created…
khizar ansari
  • 1,476
  • 2
  • 18
  • 29
-1
votes
2 answers

What all should I be optimizing based on MySQL Tuner results?

-------- Log file Recommendations ------------------------------ [--] Log file: /var/log/mysqld.log(4K) [OK] Log file /var/log/mysqld.log exists [OK] Log file /var/log/mysqld.log is readable. [OK] Log file /var/log/mysqld.log is not empty [OK] Log…
user3514328
  • 109
  • 2
  • 8
-1
votes
1 answer

Need help MySQL Optimizations mysqltuner issues

I'm using MySQLTuner.pl to optimize my site/srever.... though I'm not entirely sure how to resolve some of these issues and am wondering if someone can help me out. I have VPS with 4GB ram, THIS IS my.cnf settings: [mysqld] …
motioz
  • 662
  • 2
  • 11
  • 21
-1
votes
1 answer

Can not run mysqltuner

I am running Ubuntu 10.04 LTS and I'm trying to run mysqltuner but it won't work. I downloaded the script and made it executable and then i typed ./mysqltuner.pl but it gave error ./mysqltuner.pl: line 4: syntax error near unexpected token…
Trish Pham
  • 439
  • 2
  • 6
  • 13
1 2 3
4