All Questions
32 questions
1
vote
1
answer
199
views
cpulimit/iolimit per mysql/mariadb user
I can set cpulimit, iolimit, etc for mysql process by moving its pid into cgroup.procs file of a cgroup.
But single mysql process handles all the queries(threads) and I cant set cpulimit to the entire ...
- 11
1
vote
3
answers
971
views
Sudden spike in BinLogDiskUsage
Two days ago our MySQL RDS instance saw a sudden spike in BinLogDiskUsage, CPUUtilization, NetworkReceiveThroughput and NetworkTransmitThroughput.
The result was a database that was extremely slow to ...
- 13
0
votes
1
answer
1k
views
MySQL | Measure overall query cost (performance, cpu usage, memory usage)
The Problem
You have a MySQL query, let's say a SELECT and you need to identify its overall cost in all aspect (Host Resource Usage, Query speed / performance ...) so that your result can be ...
- 151
1
vote
1
answer
495
views
high CPU with high user connection, mysql database
I use a VPS with 56 CPU cores and 64 GB of memory, a with MySQL database, but the CPU usage is always high for my apps - user 10.000.
This is in my mysqld.cnf. What's wrong with my settings?
...
2
votes
1
answer
722
views
MySQL 5.7.37 is consuming CPU and High memory ( 90-95% ) [closed]
I have a problem with my MySQL database.
RAM usage is too high, CPU too.
Does it come from my configuration ?
Here's my configuration :
auto_generate_certs ON
auto_increment_increment 1
...
- 21
0
votes
1
answer
142
views
Can set command cause more CPU usage?
Im running AWS aurora 5.7. The application stack is PHP. After moving to Aurora, I noticed that the CPU consumption is really high. When I checked the performance insights, its showing the SET command ...
- 1,960
-1
votes
2
answers
2k
views
Amazon RDS MySQL high CPU issues
I am hoping for a bit of help or direction on how best to troubleshoot this issue. We have recently increased our application load (more processes interacting with the DB) and the DB CPU is constantly ...
- 9
1
vote
0
answers
895
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 ...
- 123
3
votes
1
answer
30k
views
Mysql showing 100% CPU usage
We are facing problem of high cpu usage for mysql process (almost 100%). Here is the information related to server
Server Infos:
VPS - CENTOS 7.9 kvm - 6 GB RAM - 4 Core CPU - 180 GB SSD - MariaDB
And ...
0
votes
2
answers
2k
views
MySQL high CPU usage under medium load
I'm managing a Magento server with MySQL installed in it. 16GB RAM 8 core vCPU (Digitalocean).
We're having a problem with the site becoming a bit sluggish when under medium to heavy load. Under low ...
- 11
2
votes
2
answers
724
views
CPU High usage crashing our server
The server where my database is running is suffering from CPU spikes. We're having trouble identifying what is causing these CPU spikes, and consequently how to mitigate them.
I've tried adding some ...
2
votes
1
answer
3k
views
I have 600% high CPU usage mysqld
I have an insane usage of cpu mysqld +600% here is the file my cnf
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an ...
Alfredo
0
votes
2
answers
67
views
Near identical MySQL deployments behaving very different - High CPU Usage problem
So I have five identical websites, running on five machines provisioned in the same way. The only thing that differs between these installations are the language files and the languages of the text ...
- 363
0
votes
2
answers
647
views
MySQL taking up 400% CPU
LEMP stack on DigitalOcean (48GB ram, 960GB SSD, 12 vCPU) with WordPress on it. Added a new theme and mysql went through the roof. 400% CPU usage taken up by MySQL itself!
Looked at slow-log to figure ...
- 109
1
vote
1
answer
692
views
MySql doesn't use extra CPU
A server running only a MySql 5.7.30 instance consumes on average around 25% of its CPU, having over 100 threads connected, and of which generally 15-25 are running threads. The CPU in the server has ...
- 111
-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 ...
- 13
0
votes
0
answers
98
views
MySQL cpu won't go down after query; need restart
I have a query triggered towards a MySQL server. Every time I run such a query, the cpu goes up until the query ends. After that, cpu usage goes down, but not to normal value: a little cpu is still ...
- 101
-1
votes
1
answer
523
views
Mysql keep high cpu usage and I cannot tune it down
I have an asp.net application which use Mysql as database server. In my application have some threading which will query mysql database. It always caused the Mysql database server CPU usage up to 99%. ...
- 111
0
votes
2
answers
190
views
asp.net caused mysql 99% usage
I have an asp.net application which use Mysql. I test it on testing server running MySQL. When the application is running, it consumes 40% of cpu. I run the same code in production server which also ...
- 111
0
votes
1
answer
5k
views
Finding the cause of a stuck "Sending Data" query in MySQL
I'm running MySQL on a 1gb DigitalOcean droplet, and I have a number of scheduled tasks through the Laravel framework that run. One task in particular (seemingly) randomly causes MySQL to sit at 100% ...
- 113
0
votes
1
answer
87
views
MySQL server upgrade, how to adapt variables?
I am about to upgrade my MySQL server because I have currently used it mainly with a couple of people in the development stage. Before we launch, however, we would like more capacity to avoid the ...
- 101
0
votes
1
answer
49
views
Percona/XtraDB Database with many of writes to a small table uses less CPU than the same database with less writes?
I'm trying to understand why Percona and xtradb InnoDB/MySQL behaves the way it does and if there's anything I can change in the configuration to fix it.
I've a InnoDB database with only one table ...
- 1
0
votes
1
answer
2k
views
Why is turning on Event Scheduler Maxing my CPU?
I have search the web for the last week trying to figure this out.
I have exported my tables and events, re-installed the lastest MySQL and imported.
I have tried checking individual procedures.
My ...
1
vote
1
answer
4k
views
How to get CPU usage in MySQL per user?
I want to know is there anyway to get CPU usage per user in MySQL? for example I have 3 different users 'user1', 'user2' and 'user3'. I want to get the average/real time memory usage and CPU usage of ...
0
votes
1
answer
253
views
Where MySQL is taking time either in disk read or computation? [closed]
From SQl case study
System configuration is
Software: Percona 5.6.15-63.0. Hardware: Supermicro; X8DTG-D; 48G of RAM; 24xIntel(R) Xeon(R) CPU L5639 @ 2.13GHz, 1xSSD drive (250G)
Query is select ...
- 399
-1
votes
1
answer
368
views
High MySQL Load 700% CPU usage
My mysql takes 700% of CPU while loading the website.
top command shows -
784% of CPU
6.3% of MEM.
This is the output of lscpu command.
Architecture: x86_64
CPU op-mode(s): 32-bit, ...
3
votes
1
answer
1k
views
MySQL CPU usage super high since server crashed
I've had a big crash on my server 2 days ago, still don't know why, but after resurrect it the mysql server is consuming a huge amount of cpu and I don't know why:
The server is Mariadb installed by ...
- 31
1
vote
1
answer
388
views
What is the load impact of the Zabbix DB size query?
I am in the process of implementing Zabbix monitoring on multiple servers at an organization. I have recently run into some resistance from an Oracle / MySQL DBA. He claims that the following query ...
- 133
0
votes
0
answers
76
views
troubleshoot cpu usage mysql
We are running a few Mysql server on EC2 instances and RDS instances on AWS. From time to time they suddenly spike in CPU, and/or memory usage but when we login into the instances, it's too late and ...
1
vote
0
answers
242
views
mySQL task with high cpu usage
Hi i had 2 servers with the same hardware and software configuration, booth servers had the same my.cnf flags.
Centos 7.4
Cpanel
Mysql 5.6
Multi PHP
I execute a task on both servers, and on one of ...
- 19
1
vote
1
answer
7k
views
Wordpress causes high CPU usage (mysqld)
I have a wordpress site with 500k posts in MYSQL database running on debian dedicated server:
Server OS: Debian 8 "Jesssie)" - Linux version 4.9.58-xxxx-std-ipv6-64 ([email protected]) (gcc ...
- 13
4
votes
4
answers
4k
views
InnoDB memory/cpu use optimization for WordPress with MySQL
I'm not a DBA and need some help here... I have a high traffic WordPress site hosted in a EC2 instance. We are working in a new theme code that will have optimized queries, but right now I need to ...
