Questions tagged [mysqltuner]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
49 views

Mysql eat a lot of memory but innodb_buffer_pollsize is set to 50%

I don't understand why my mysql eat a lot of memory even though I set innodb_buffer_poll_size to around 50% here is my top user@Mulia-Abadi:~$ top top - 11:09:31 up 12 days, 16:30, 3 users, load ...
0
votes
1answer
27 views

it’s safe to run mysqltuner on production server

Can i run mysqltuner directly on a production server ? It’s will slowdown my server or install some packages ? My users will be affected ?
0
votes
1answer
72 views

mysql tuner - optimize table and cnf

I want to optimize my database and decided to start by running mysqltuner, but it showed me so many errors that I don’t know what to undertake, I couldn’t advise what configuration I should specify ...
1
vote
2answers
76 views

MySQLTuner request - high CPU problems

I've been running a pretty high pop website for a few months new and as its growing we've been having some problems lately. Its a 2 core Xeon, 8GB, SSD server. We're pulling +- 150k people a day. ...
0
votes
1answer
41 views

Limit hostnames for user

I am running MySQL optimisation wizard, mysqltuner, which gives the suggestion: User 'root@%' does not specify hostname restrictions. How is this achieved? I can't readily find an answer.
3
votes
5answers
1k views

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 ...
0
votes
1answer
244 views

Extremely slow website, MySQLTuner log, any advice?

We are running a Wordpress site and are having major problems with extremely slow response time for pages that have to miss the Nginx cache. I'm looking at our database performance as a culprit, and ...
1
vote
1answer
1k views

Low Memory Usage High CPU mysqld

I'm managing a server with medium to high traffic. It serves a wordpress website. It seems that it use a lot of CPU (over 300% at some points) and always stack around 15% of memory usage. It is a ...
1
vote
3answers
485 views

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....
1
vote
0answers
446 views

Help troubleshoot MySQL memory usage, indexes without joins, save-point rollbacks

I noticed that the memory usage for mysqld keeps growing over time. The sites hosted are quite low traffic, though they're mostly Magento installations (which is known to be a bit of a hog). I tuned ...
0
votes
3answers
169 views

MySQL process takes up to 180% of the CPU (optimisation need)

I have a dedicated server with 128 GB of RAM and an 8 core CPU and 2TB hard drive. I have cPanel and MySQL installed in the same server. In this server I have 12 websites hosted including 5 with a ...
0
votes
1answer
926 views

InnoDB Write Log efficiency above 100%

After running mysqltuner.pl, I get an Innodb write log efficiency way above 100 %. Why? What does it mean? There is no specific reccomendation from mysqltuner. DB is MariaDB 10.1.26 on Debian 9.x ...
3
votes
4answers
2k views

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 ...
2
votes
2answers
4k views

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 -------- ...
0
votes
1answer
37 views

mysqltuner.pl shows [!!] 2 different collations for database

mysqltuner.pl shows me result [!!] 2 different collations for database ccdb I don't see two different COLLATE on DB level. Is this even possible? How to verify? > show create database ccdb; +---...
1
vote
3answers
617 views

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 ...
0
votes
1answer
236 views

Optimizing MYSQL Configuration

I used MYSQLTUNER on my 1GB RAM Server. Here is the Output:- -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] ...
-2
votes
1answer
369 views

Tune mysql database for performance

I have an ec2 t2.micro instance having memory 1 GB. My database consist of a single table having records approximately 1.2 million. How should i tune my database? This is the result i got after ...
6
votes
3answers
6k views

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 <major@mhtx.net> &...
2
votes
1answer
321 views

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 ...
0
votes
2answers
1k views

MySQL Optimization Suggestions for EC2 T2 Small 2GB RAM

I'm trying to optimize our MySQL configuration for our server. The reason I believe that MySQL needs to be configured further is because my log has shown that our SELECT queries are taking a long time ...
1
vote
0answers
1k views

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) ...
2
votes
2answers
715 views

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 ...
1
vote
1answer
545 views

Optimise MySQL on VPS (2 CPUs & 3 GB RAM) with WP MU

I have a vps server with os centos 6.7 64x, 2 cpu's and 3gb ram, and I use it exclusively for a WP MU (Memory limit: 512 MByte/Memory usage: 53.97 MByte). I use mostly myisam and have about 30 ...
2
votes
1answer
2k views

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 ...
2
votes
1answer
4k views

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 ...
2
votes
2answers
3k views

tmp_table_size with mostly InnoDB tables

I use MySQL version 5.6.25-0ubuntu0.15.04.1 on 64-bit Ubuntu 15.04. I have 2GB RAM and the disk is SSD (so, in my mind, writing to disk isn't that costly). I currently have databases for just two ...
1
vote
1answer
141 views

Why does MySQLTuner only see 4Gb of RAM?

I ran MySQLTuner to verify the configuration of a MySQL database, and it reported this problem: [!!] Maximum possible memory usage: 40.9G (1022% of installed RAM) These figures come from computing ...
1
vote
2answers
3k views

Mysql causing high load average with large amount of server resources left

I've have 2 servers running a application and the server that runs the mysql sgbd is with the load average around 3 times more than the webserver. I think that is something wrong because i have a lot ...
0
votes
0answers
505 views

Tunning MySQL Variables

we have a dedicated mysql server with 10 CPU and 32G of memory After doing some readings came up with those configs : # This was formally known as [safe_mysqld]. Both versions are currently parsed. ...
0
votes
1answer
3k views

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 ...
0
votes
1answer
3k views

Following mysqltuner suggestions: query_cache_size and join_buffer_size

So I am following the suggestions of mysqltuner, and so far I've had great results, the server is performing well (dedicated VPS running a large Magento eCommerce store) There is only two issues left ...
2
votes
1answer
878 views

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 ...
0
votes
2answers
8k views

mySQL Optimization Suggestions

I'm trying to optimize our mySQL configuration for our large Magento website. The reason I believe that mySQL needs to be configured further is because New Relic has shown that our SELECT queries are ...