Questions tagged [mysqltuner]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
35 views

Advice on WooCommerce DB and really slow WC core admin queries

Thanks for reading! So I'm kind of banging my head against a wall but I firstly want to say that I think this is a DB setup problem rather than the code as even when stripped back to bare bones WC the ...
Devon Developer's user avatar
0 votes
1 answer
460 views

Tips for improving MariaDB performance and tuning queries

I'm currently working on optimizing the performance of my MariaDB database and have come across a tool called mysqltuner. I've installed and run mysqltuner on my server, and it provided me with some ...
Wiki wanda's user avatar
0 votes
1 answer
329 views

Help with MySQLTuner and MySQL Configuration

I am running my server on Cloudways AWS server; it's a LearnDash WordPress website. I tried to adjust the server config as their support does not want to do anything with that. I have a 16 vCPU and 32 ...
tech team's user avatar
0 votes
2 answers
387 views

MySQL's maximum memory usage is dangerously high and CPU run 100%

Hi we faced an issue on our server and it go verry slow for more tan 1 month and it go worst every day. I am really not server administrator, This is mysqltuner.pl result, -------- Storage Engine ...
Mathieu's user avatar
0 votes
0 answers
327 views

MySQLTuner vs cPanel SQL recommendations are different / contradictory

I've used WHM's (cPanel) to optimize the mysql configuration on my server and it suggested making the following changes which I made innodb_buffer_pool_size=3328M key_buffer_size=55M ...
Ryflex's user avatar
  • 51
0 votes
1 answer
296 views

Optimize MariaDB 10.6

I am not a database guru. But here's the matter with which I'd like some help. I have a relatively freshly-minted server running AlmaLinux 8.7, with 64GB RAM and a pair of terabyte SSDs. After ...
Gene Steinberg's user avatar
0 votes
2 answers
1k views

MySQL 8.0 memory usage continuously growing

I have installed MySQL 8.0.29 on a dedicated server with 16 vCores and 60 GB RAM but the memory usage is still growing. I restarted the mysql service 2 months ago and it takes about 91% RAM now: ...
deem's user avatar
  • 113
3 votes
0 answers
301 views

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 ...
emhsmath's user avatar
2 votes
3 answers
6k views

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 <jmrenouard@gmail....
Cyril Arnaud's user avatar
-1 votes
2 answers
474 views

Help Me For Implementing MySQL tuner suggesstions [closed]

Mine is Digitalocean with 1vCPU, 1GB -25GB SSD Ubuntu server with nginx, MariaDB, phpmyadmin and running a wordpress blog. Mysql is taking too much cpu and on running running MySqlTuner, I got these ...
Vishal Gupta's user avatar
1 vote
0 answers
770 views

high CPU usage of MySQL and recommendation from Mysqltunner [closed]

we have noticed that our database server is getting so high CPU (more than 90 % used by mysqld process), the output of mysqltunner is shown below, can you help me please, i'm okay about the ...
Hamza AZIZ's user avatar
1 vote
0 answers
144 views

Help me tune Mysql instance to support more users

I'm currently supporting, A Moodle 3.10 instance, running MySQL 8.0.20. This is running through an Azure Provider as a Standard DS11(2 vcpus, 14 GiB memory). Running as a LAMP stack server. Currently, ...
CorrectHorseBatteryStaple's user avatar
0 votes
2 answers
117 views

Asking Suggestions regarding mysql optimization

Im running a dedicated server with around 20-25 sites, almost all of them running wordpress installations. Running it over a cpanel setup. For a while its mostly mysql eating most of the cpu and ...
Sawada Tsunayoshi's user avatar
0 votes
2 answers
239 views

MySQL Tuner Settings for Question - Answer Dynamic Website

I ran the mysqltuner script on my server that has been working continuously for 1 week. I share the values I got and the existing mysql configuration file. Could you help me? When I looked on the ...
XtrmuS's user avatar
  • 1
1 vote
1 answer
1k views

MySQL 5.7 High Memory usage Killed by OOM

i upgrade my WHM server / Cent-OS 7 from MySQL 5.6 to 5.7. after that upgrade every few hours my server memory full by MySQL which after hours of MySQL restart it exceed 80% of whole memory. i ...
Bilal H's user avatar
  • 11
1 vote
0 answers
567 views

Bad write log efficiency, strange broken relationships

I recently switched galera synchronization method from rsync to mariabackup which greatly reduced CPU usage on our DB servers and also increased the innodb_log_file_size to 2G from about 600M or so. ...
Chibueze Opata's user avatar
0 votes
2 answers
1k views

Cannot lower/figure out per connection mariadb memory usage

I'm running a small mariadb DB to serve some websites and monitoring tools (nexctloud, wordpress and icinga2). The machine that works as a DB server also run an elasticsearch + graylog instance so I ...
ebiagi's user avatar
  • 3
1 vote
3 answers
489 views

MySQL Optimization Guidance Needed

UPDATE 6/23/2020: Haven't noticed any odd CPU spikes lately, but noticed that the MySQL memory footprint grows indefinitely until it goes OOM and is killed by the kernel. Where should I start looking ...
enyceexdanny's user avatar
1 vote
3 answers
1k views

MySQL Optimization on my server

I have an active server running around 80-100 active websites. I would like to optimize the server and possibly reduce the amount of RAM and optimize my MySQL settings. I have 30 GB of RAM assigned ...
DAVID ANDRÉS TAPIA MOSCOSO's user avatar
0 votes
2 answers
1k views

Help me to tune MySQL

I have a server that is giving me CPU spikes and and is slow in serving pages: Server information Processor: X3440 (2.53GHz Quad Core + HT) Memory Type: 8GB DDR3-1333 REG ECC Memory information ...
samuelmf's user avatar
1 vote
1 answer
1k views

MariaDB Optimization with Mysql Tuner

I've read so many articles regarding MariaDB optimization for low memory servers. There are a lot of guides about that but people are always sharing their own configuration. That makes it difficult to ...
Serdar Koçak's user avatar
-3 votes
1 answer
2k views

What is the optimal configuration for MariaDB ? (CentOS 8, MariaDB 10.5)

Hello i have MariaDB 10.5 on a Centos 8 Server configuration 18cores 32 threads and 32gb ram I have plenty of free ram but I am trying to optimize for CPU less CPU work and more ram usage How I do ...
Wed's user avatar
  • 13
0 votes
1 answer
947 views

mariadb takes too much load though having sufficient RAM

I am facing more CPU usage for my app server. Server configuration is as below. 1> CPU: Intel(R) Xeon(R) CPU E5-2650 v4 @ 2.20GHz 8 core 2> RAM: 32 GB 3> 600 GB SSD NVRAM 4> Mariadb ...
Kavin Chauhan's user avatar
1 vote
1 answer
2k 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 ...
Ekkai Imwe's user avatar
1 vote
1 answer
596 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 ?
Metra's user avatar
  • 113
0 votes
1 answer
369 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 ...
user avatar
0 votes
1 answer
431 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.
Kohjah Breese's user avatar
6 votes
6 answers
19k 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 ...
Augusto Murri's user avatar
-2 votes
2 answers
645 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 ...
nicenice's user avatar
1 vote
1 answer
3k 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 ...
fat_mike's user avatar
  • 121
2 votes
3 answers
2k 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....
SvEnjoyPro's user avatar
1 vote
0 answers
792 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 ...
enyceexdanny's user avatar
-1 votes
3 answers
964 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 ...
tmedtcom's user avatar
  • 101
0 votes
1 answer
4k 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 ...
Timido's user avatar
  • 173
3 votes
4 answers
6k 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 ...
enyceexdanny's user avatar
2 votes
2 answers
8k 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 -------- ...
lp1051's user avatar
  • 123
0 votes
1 answer
58 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; +---...
Sybil's user avatar
  • 2,458
2 votes
3 answers
1k 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 ...
behjattiger's user avatar
0 votes
1 answer
305 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] ...
user avatar
-2 votes
1 answer
421 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 ...
Azhar's user avatar
  • 3
7 votes
3 answers
13k 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 <[email protected]> &...
user119791's user avatar
2 votes
1 answer
613 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 ...
danxinnoble's user avatar
0 votes
2 answers
3k 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 ...
NineCattoRules's user avatar
2 votes
0 answers
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) ...
Grzegorz Adam Kowalski's user avatar
2 votes
2 answers
963 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 ...
Mwordpress's user avatar
1 vote
1 answer
2k 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 ...
Alex's user avatar
  • 43
2 votes
1 answer
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 ...
emilushi's user avatar
  • 121
3 votes
1 answer
7k 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 ...
Holly's user avatar
  • 145
2 votes
2 answers
6k 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 ...
Eric Marsh's user avatar
1 vote
1 answer
187 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 ...
dr_'s user avatar
  • 1,314