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
5
votes
2 answers

mysqltuner.pl on a windows 2008 server r2

I usually use linux for mysql and have something called mysqltuner.pl and this is great but we have a mysql server on a windows 2008 r2 server that we have and was wondering if any of you know of something simular to mysqltuner that i can use. I…
davethecoder
  • 3,856
  • 4
  • 35
  • 66
3
votes
1 answer

MySQL Optimization in 16GB RAM Server

I have a CentOS 6.5 VM with 16 GB RAM. I feel the MySQL quite slow response and I've ran the MySQLTuner script, and from the given recommendations how I can make change to my my.cny config file to improve the performance? Here are the results 2…
Rex See
  • 33
  • 1
  • 1
  • 3
2
votes
1 answer

Any MySQLTuner equivalent/alternative for Windows?

I know auto tuning has its limits, but it would be great to quickly determine reasonable starting points for my Windows MySQL InnoDB configuration (innodb_additional_mem_pool_size, innodb_buffer_pool_size, innodb_log_file_size,…
Erwin Mayer
  • 18,076
  • 9
  • 88
  • 126
2
votes
3 answers

MYSQL 8 running in WHM cPanel high CPU usage/crashing requiring mysql reset after 2 days

I have about 30 websites running Magento/Wordpress. Every 1-2 days I would need to reset mysql and then the CPU usage would be around 27% but then it'll slowly climbing up slowly over 1-2 days until it can't process any query. I've been trying to…
mrWiga
  • 131
  • 1
  • 2
  • 13
2
votes
4 answers

mysqltuner invalid login credentials with verified correct password

I downloaded mysqltuner to use on my ubuntu server and no matter which user I attempt to login with, it responds that my credentials are invalid. I routinely log in as root with my root password and yet it will not recognize it. Does mysqltuner need…
caro
  • 863
  • 3
  • 15
  • 36
2
votes
1 answer

How would i use nested classes in Puppet for this example?

I am trying to install mysqltuner for puppet from the forge, already installed properly mysql module, but i don´t understand quite well the classes behaviour. the example is below: class drupal::db { class { '::mysql::server': # how would i…
Kouen
  • 75
  • 1
  • 9
2
votes
3 answers

MySQL defragment InnoDB tables

After running mysqltuner, I received this output: Total fragmented tables: 284 To defragment I tried these: 1. ALTER TABLE tbl_name ENGINE=INNODB 2. Another way to perform a defragmentation operation is to use mysqldump to dump the table to a text…
torayeff
  • 9,296
  • 19
  • 69
  • 103
2
votes
2 answers

Optimize MySQL for Prestashop 1.6

I am running Prestashop 1.6 powered e-shop on VPS with 4GB RAM, 2CPUs, 60GB SSD characteristics. Currently I have about 20000 products in my shop and I am having problems with site loading because mysql queries run long. And when I run htop to…
torayeff
  • 9,296
  • 19
  • 69
  • 103
1
vote
1 answer

mysqltuner report for performance optimization

Very new to MySQL optimization techniques. Please find the below report of mysqltuner.pl and suggest what variables in my.cnf should I change for performance optimization. One more question - I'm not able to find few variables like…
Mandar Pande
  • 12,250
  • 16
  • 45
  • 72
1
vote
3 answers

I need assistance tuning the MySQL performances - MySQL's maximum memory usage is dangerously high and Temporary tables created on disk

can someone help me tune the MySQL performances for my WordPress site? I just want to make sure everything is optimized to the maximum. Thanks! Server details: CentOS v7.9 Apache / PHP (It's a WordPress site) vCPU/s:1 vCPU RAM:2048.00 MB Storage: 64…
RocketBrian
  • 87
  • 6
1
vote
3 answers

Run OPTIMIZE TABLE to defragment tables for better performance

I read articles related to OPTIMIZE TABLE which needs further clarification. I ran a mysqltuner.pl against my MariaDBv10.6.7 where I got a few recommendations and one of them was to run optimize table. Run OPTIMIZE TABLE to defragment tables for…
ragul rangarajan
  • 167
  • 2
  • 12
1
vote
1 answer

MySQL Tuner Performance Advice

My app works on LAMP 7.3, MySQL 5.7, Cloud VPS. The VPS has 2 GB RAM, 1 vCPU, 60 GB SSD. MySQL Tuner is working for 5-6 days, I'll share the output. -------- Storage Engine Statistics…
Jack UK
  • 45
  • 5
1
vote
2 answers

Optimal setting for mysql (mariadb optimization 10.5) in my.cnf (Centos 8)

Here are my mysqltuner results: [--] Skipped version check for MySQLTuner script [!!] Successfully authenticated with no password - SECURITY RISK! [!!] Your MySQL version 10.5.0-MariaDB is EOL software! Upgrade soon! [OK] Operating on…
Wed
  • 23
  • 1
  • 8
1
vote
1 answer

MySQL Tunner : High ratio of temporary tables created on disk - Website Slow response

I'm using a dedicated server with bellow specification for a single website with joomla CMS that is News/blog based website: Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz 10 of Cores, 20 of Threads Ram: 60GB SSD:250 (OS and i think DB) HDD: 2TB PHP…
Muhammad Abbas
  • 11
  • 1
  • 5
1
vote
2 answers

MySQL tmp_table_size for a small database

I have MySQL 5.7.23 on Ubuntu 18.04. It's a VPS with 2 vCores and 8 GiB of RAM. The server is hosting two WordPress websites. Each website has a database with the size of 7,5 MB. So there is 15 MB database overall. I was trying to optimize the…
LukasBeran
  • 13
  • 1
  • 3
1
2 3 4