Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysqltuner]

51 questions
7
votes
3 answers

Mariadb MySQL Tuner report confusing

I'd like to ask you to clarify the report from mysqltuner regarding MariaDB database. The mysqltuner was called with --nogood flag! >> MySQLTuner 1.7.1 - Major Hayden >> Bug reports, feature requests, and downloads at…
user119791
  • 71
  • 1
  • 1
  • 2
6
votes
6 answers

Help with MySQL's maximum memory usage which is dangerously high

Anyone can help me to check this MySQL configuration? I have a VPS 32GB RAM - 8 vcpu and running 1 ecommerce. MySQLTuner returns me: Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing…
Augusto Murri
  • 195
  • 1
  • 2
  • 7
4
votes
1 answer

How to use mysqltuner from remote host

We do not have access to our servers with operating system console. Our production environment is Ubuntu 12. Is it possible to use mysqltuner from remote host? If yes, please provide guidelines. We are using mysql5.6
MahendraV
  • 43
  • 1
  • 5
3
votes
0 answers

mysqltuner says my joins are not using index but I have index

I am very new to database design, I spun up an Ubuntu server version 20.04.3 LTS and installed mysql version mysql Ver 8.0.31-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)). I designed my database like so addresses use `testdb`; DROP TABLE IF…
emhsmath
  • 31
  • 2
3
votes
3 answers

MySQL's maximum memory usage is dangerously high

I'm trying to understand what is not working in my configuration. When I run the [root@server ~]# ./mysqltuner.pl >> MySQLTuner 1.9.8 * Jean-Marie Renouard * Major Hayden >> Bug…
Cyril Arnaud
  • 31
  • 1
  • 1
  • 2
3
votes
4 answers

MySQL Optimizations

I'm running a dedicated server with about 20 websites active. About 6 of them are Magento installations. Running the server as a webserver (web, e-mail, and MySQL ). This is a preemptive optimization. Currently, I don't seem to have any issues, but…
enyceexdanny
  • 53
  • 1
  • 6
3
votes
1 answer

How to use MySQLTuner on Amazon RDS

I've installed MySQLTuner locally and it works on my local database. When I try to run it on my Amazon RDS db it does not, it says my login credentials are invalid. $ perl mysqltuner.pl --host testing-db.??????????.us-east-1.rds.amazonaws.com --port…
Holly
  • 145
  • 1
  • 7
2
votes
1 answer

Optimize Percona MySQL InnoDB 3.2TB database

(Before you will call me an idiot or start laughing, please remember it's a real deal on my side and I cannot cancel this assignment as it is a part of a bigger project) I have a database server that is crazy big in size and is running on crazy…
Jestemkaspi
  • 23
  • 3
2
votes
3 answers

I ran MySQLTuner and wondered if anyone would go over the results with me, specifically query cache and temporary tables

Here are the results of MySQLTuner: [--] Skipped version check for MySQLTuner script [OK] Logged in using credentials from debian maintenance account. [OK] Currently running supported MySQL version 5.7.21-0ubuntu0.16.04.1 [OK] Operating on 64-bit…
SvEnjoyPro
  • 123
  • 5
2
votes
2 answers

mysqltuner - Write Key buffer hit rate

I'm pasting section of MySQL Tuner result regarding MyISAM Metrics. [OK] Currently running supported MySQL version 5.5.57-0ubuntu0.14.04.1-log [OK] Operating on 64-bit architecture -------- Performance Metrics…
lp1051
  • 123
  • 1
  • 5
2
votes
3 answers

Optimize MySQL Server Performance

I have a VPS Server at Vultr with 8GB Ram and 4vCPUs and am looking to get optimized mysql settings. I have a DB of around 170 InnoDB tables, but they mostly don't contain a lot of data. There are 2 MyISAM tables however with 150k rows each which I…
behjattiger
  • 21
  • 2
2
votes
1 answer

mysqltuner: "MySQL started within last 24 hours - recommendations may be inaccurate." Why?

I'm new to db management and db tweaking. I'm using mysqltuner to get recommendations for how to improve db performance. Mysql issues a warning message along with its recommendations: "MySQL started within last 24 hours - recommendations may be…
danxinnoble
  • 123
  • 2
2
votes
0 answers

Negative InnoDB Write Log efficiency in mysqltuner.pl results

I noticed something strange in results from mysqltuner.pl. I see this in mysqltuner output from three of my four servers with MariaDB 10.1.12: [OK] You have the latest version of MySQLTuner(1.6.5) [OK] Currently running supported MySQL version…
Grzegorz Adam Kowalski
  • 131
  • 6
2
votes
2 answers

optimize mysql with mysqltuner Recommendations

Every day at 18:00 mysqlserver became very slow How do I apply the suggestions by mysqltuner for optimize mysqlserver CentOS release 6.6 (Final) MySQL version 5.6.28 64-bit architecture 32GB RAM [mysqltuner] >> Bug reports, feature requests, and…
Mwordpress
  • 21
  • 2
2
votes
1 answer

Mysql Tuning for a small server

I have a small Cloud Server running under Ubuntu 2 core, 2GB ram and 2GB swap, with Plesk Panel, Apache, Nginx as reverse proxy and Mysql 5.5. I have about 18 domains hosted here and each domain has his DB. Most of the websites are running under…
emilushi
  • 121
  • 4
1
2 3 4