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
1
vote
1 answer

MySql configuration for huge Magento

Below is the report from mysqltuner and than at last I have written server stats and actual question. Performance Metrics [--] Up for: 2d 14h 28m 52s (59M q [266.240 qps], 96K conn, TX: 114G, RX: 16G) [--] Reads / Writes: 18% / 82% [--] Binary…
Kapil Karangeeya
  • 310
  • 1
  • 11
1
vote
1 answer

Tuning mysql. Mysqltuner recommendations

Good afternoon. The site is located on VPS (10 GB RAM, 2 CPU core, 65 GB SSD). I want to improve the speed of the site. But I do not understand all the parameters of mysql. I wrote out the current mysql settings, as well as the mysqltuner…
Boroda32
  • 11
  • 1
1
vote
1 answer

mysql performance - mysqltuner

On two database MySQL server (from two different websites), I launched a mysqltuner (we have a timeout on the web server, but we do not really know where it comes from at the moment) Here are the optimizations to bring advise by mysqltuner, the…
Mattmurdock
  • 11
  • 3
1
vote
1 answer

Mysql process goes over 400% of CPU usage

I'm experiencing some problems with my mysql server When I run top command, it sais that mysql process has taken over 350-500% of CPU I'm running centos 6 with 49 GB RAM my.cnf settings: [mysqld] #…
Mikel Tawfik
  • 658
  • 3
  • 9
  • 23
1
vote
1 answer

MySQL Database Performance Tuning

I have developed a PHP and MySQL web application. Lately it has been showing signs of slowing down. I have ran mysql-tuner on 090516 with an uptime of 12 days. The server specs are as follows: - Linux CentOS 6 - 48 Processors - 64GB RAM Here is…
Aaron
  • 11
  • 1
1
vote
1 answer

mysql query using the wrong indexes

I have some optimization problems with some of my queries in a mysql database. After I build my application I am trying to optimize using mysqltuner and explain, to find non indexed queries. This is a query that is running often and reports that is…
Ioannis Kokkinis
  • 185
  • 1
  • 1
  • 17
1
vote
1 answer

MySqlTuner - Failed: return code 256

we are trying to use mysqltuner to have a kind of vision of what could be the problems behind some issues on our Wordpress website but have have few problems when running it (mostly failed to execute / returne code: 256). First we did: wget…
Lightbox
  • 71
  • 2
  • 5
1
vote
1 answer

Magento fragmented tables

After running mysqltuner on my Magento db it says me [!!] Total fragmented tables: 1203 In suggestion it says Run OPTIMIZE TABLE to defragment tables for better performance I just made a db backup and I was wondering which is the best way to…
user2478262
  • 59
  • 1
  • 9
1
vote
1 answer

How to run mysqltuner script on a unix server?

Surprisingly I couldn't find a single tutorial for beginner about this script so it's gonna be an ultimate beginner question. What I want to do : I want to run the mysqltuner script to get information about the configuration of a server. I need a…
Phalanx
  • 1,217
  • 6
  • 25
  • 36
1
vote
2 answers

mysql performance tunning with results of mysqltuner.pl

I am using VPS with 1.5GB RAM and burst RAM of 3GB. The VPS is hosting multiple Joomla websites. I want to performance tune mysql. For the purpose I run mysqltuner in my server and here are the results. Please guide for creating a best my.cnf file…
Mansoor Yousaf
  • 11
  • 2
1
vote
1 answer

Large InnoDB data size even though entire database is MyISAM?

I'm running mysqltuner to tune up my database and I'm running into a very strange occurrence. Even though the entire database is MyISAM (all tables) it says the following: [!!] InnoDB data size / buffer pool: 403.1M/128.0M The default storage…
sveti petar
  • 3,637
  • 13
  • 67
  • 144
1
vote
2 answers

What does "MySQL's maximum memory usage is dangerously high" mean by mysqltuner?

I am trying to optimize my mysql runs on a 2GB mem VPS, I used mysqltuner, and I dont quite understand how to deal with the following recommendations, especially the one says: MySQL's maximum memory usage is dangerously high, deal with this one? Can…
Frank Guo
  • 547
  • 7
  • 8
0
votes
0 answers

Trying to troubleshoot/understand mysqltuner JSON error message

As per name I am just an old git who is attempting to teach himself so apologies if this is the wrong place/query for here. Anyway I have run mysqltuner and am working through the recommendations - some are easier and more obvious, some I've managed…
oldgit71
  • 1
0
votes
1 answer

"Sorts requiring temporary tables" is 73% in mysqltuner output

How can I reduce the percent of sorts that require temporary tables? What does this warning mean exactly? A comment here suggests it's due to using ORDER BY on a non-indexed column. I think I've added the indexes that I can. The full mysqltuner…
mgiuffrida
  • 3,299
  • 1
  • 26
  • 27
0
votes
2 answers

What's the best my.cnf configuration for a VPS

I am having a huge CPU and memory usage from mysql in my server. My configuration is the following : Intel Xeon E5-2640 v4 @ 2.40GHz (4 Core) 8GB RAM DDR4 ECC 120GB SSD RAID-10 Unmetered Traffic / 100Mbit I've tried optimizing some requests and…
Anas Zine El Abidine
  • 1
  • 2
1
2
3 4