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
0 answers

Run mysqltuner.pl against azure database for MySQL service

I would like to run mysqltuner from my pc on a remote host. The remote host is a MySQL database hosted on Azure (Azure Database service for MySQL). I dont have access to the virtual machine - just have credentials to connect to the database. perl…
sokolata
  • 491
  • 3
  • 7
  • 21
0
votes
1 answer

MariaDB optimization and mysqltuner.pl - RAM and tuning

I am attempting to optimize the database I am running, it's sitting on a system with 8GB of RAM, and would like it to be able to use about 5GB-6GB of it. I've ran the mysqltuner.pl script, and made some changes, but before doing too much to it, I'd…
npderi
  • 79
  • 1
  • 6
0
votes
0 answers

How to efficiently maintain daily stock for more than 1000 products in MySQL?

I'm having 1000+ Products. I need to maintain the stock on the daily basis. Product Table Schema CREATE TABLE Product ( ProductId INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(30) NOT NULL, ) Stock Table Schema CREATE TABLE…
B.Balamanigandan
  • 4,713
  • 11
  • 68
  • 130
0
votes
2 answers

mysqld performance high cpu and memory usage

I appreciate if you can help with the mysqld performance problem as seen below. top shows 2 mysqld with 99% cpu usage and 73% mem usage. I have 6CPU's and 8GB of RAM in total. You can easily see the CPU's performance in last 24h. I am sending the…
Guclu Ceyhan
  • 1
  • 1
  • 1
0
votes
1 answer

Left join with ISNULL condition query taking long time to execute on MySQL RDS

Kindly help me to optimize below query,this query took more than 60 mints to execute with the ISNULL condition but if we replace ISNULL to <=> condition its took 15 mints to execute but our expectation is this query should take maxmimum 2…
Rk Singh
  • 17
  • 1
  • 11
0
votes
1 answer

Server Bogs down when using eBeSucher traffic exchange

I have 6 sites first off are all on the same dedicated server, 2 of the sites get very steady traffic . I would say their is always at least 90 to 120 people on the 2 sites consistently and 15 to 25 on the rest. The sites run decent currently until…
artskeem
  • 34
  • 1
  • 4
0
votes
1 answer

Running mysqltuner on Mac OSX

I use Zend Server CE on my Mac running OSX Snow Leopard for my development environment. I need to tune up MySQL and have used mysqltuner.pl in the past on Linux servers to do pre- and post-testing. I downloaded the script and get the following…
spdaly
  • 1,260
  • 2
  • 18
  • 35
0
votes
1 answer

MySQLTuner 1.5 Maximum possible memory usage conflicting information

We host on a VPS with 16gb Memory allocated and 12 processes, Intel(R) Xeon(R) CPU E5649 @ 2.53GHz Only recently when using mysqltuner.pl, it is showing the following which has only started since the server when down for a day, a month or so ago.…
Marne
  • 11
  • 1
  • 1
0
votes
3 answers

Mysql my.cnf empty and mysqltuner

I'm trying to solve a performance issue I have on a Mysql database and to do that I'm using mysqltuner. What I don't understand is why in phpmyadmin and mysqltuner I have several variable mentioned, whereas when I open the my.cnf file is almost…
Luca
  • 108
  • 1
  • 11
0
votes
1 answer

What does the my.cnf file actually do to the database?

So I know that the my.cnf file lets you control things like "key_buffer" and "thread_cache_size" for the application but does it directly modify the database? At the current time I have 5 servers for my site, 4 test server and 1 live. All 5 of these…
Joe Lloyd
  • 19,471
  • 7
  • 53
  • 81
0
votes
2 answers

What do "key buffer size" and "total MyISAM indexes" unit sizes mean?

I ran MySQLTuner on my database to check if things are working correctly and optimally, but I was confused as to the units used for these two values. Here is what the output looks like for performance metrics -------- Performance Metrics…
Joe Lloyd
  • 19,471
  • 7
  • 53
  • 81
0
votes
1 answer

mysqltuner recommendation suggestion

Question: whenever i run mysqltuner it always complain about three components even i change their values to high but still showing need more, they are following, I have both table MyISAM and InnoDB and we do join etc also but i heard it is not good…
Satish
  • 16,544
  • 29
  • 93
  • 149
0
votes
1 answer

Suggestion in MySQLTuner

Suggestion in MySQLTuner Hi i have run the MySQLTuner - perl and i take Security Recommendations Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name…
Geochris
  • 9
  • 1
0
votes
1 answer

Prepared statement needs to be re-prepared after mysqltuner

My application logs show "Prepared statement needs to be re-prepared" after running mysqltuner ( bother version 1.1 and 1.4 ). Once I run "flush tables;", the error goes away. I have looked online and most things mention mysqldump in relation to…
Tony B
  • 915
  • 1
  • 9
  • 24
0
votes
2 answers

MySQL Open and Opened Tables

I have 81 tables in an innodb database (MySQL). The data in them amounts to 2GB on disk. My queries rarely join more than 3 tables together at once. My innodb_buffer_pool size is about 2.1 GB. Running mysqltuner.pl I get the following !! [!!] Table…
Adergaard
  • 760
  • 10
  • 24
1 2
3
4