Questions tagged [cpu]
The cpu tag has no usage guidance.
0
votes
1answer
32 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
1answer
34 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 ...
2
votes
1answer
90 views
Numa Node configuration for SQL server 2016
I have a question on one of my new build sql servers where we are planning to migrate our SQL databases from older SQL2012 running on windows 2012.
New build- SQL2016 on Windows 2016
My current [...
0
votes
1answer
26 views
Why is my AWS RDS (postgres) at a high percentage of cpu with no active sessions?
I have two postgres db, prod and dev. Lately, dev has been really slow, so I checked into it, and it appears to be using CPU credits faster than I'm getting them. I could not figure out why, so I ...
1
vote
1answer
77 views
How to Prevent heavy queries on one database, affecting the performance of other databases on same server?
I have a linux server running just Postgres with PostGIS Extension. There are several databases on this instance of the Postrges Server.
One of the databases has some computationally intensive ...
1
vote
1answer
135 views
MAX worker thread in SQL server 2012/14/16
I was just browsing the system health extended event to come across an event with diagnostic result for query processing showing status for worker threads:
Why max worker threads showing 2994 when I ...
0
votes
0answers
373 views
CPU usage constantly high after upgrading from Postgres 9.5 to 9.6 to 10.6
I upgraded my RDS instance (db.t2.medium) from Postgres 9.5 to 9.6 couple of days back. Since the upgrade, the CPU usage was almost 100% all the time. This brought down my application. Presuming that ...
-1
votes
1answer
39 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, ...
1
vote
0answers
25 views
Database with lots of writes to a big table uses less CPU than the same database with less writes?
I'm trying to understand why InnoDB/MySQL behaves the way it does and if there's anything I can change in the configuration to fix it.
I have a table with nearly 5M rows, about 9GB in size. I also ...
3
votes
1answer
237 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 ...
1
vote
1answer
778 views
Mysterious postgres process pegging CPU at 100%; no running queries
I have a recurring issue where a postgres process is pegging my cpu at > 100%. It's a strange one, you can see below the command is ./Ac2p20853 (surrounded by asterisks, added by me).
Running SELECT ...
-2
votes
2answers
742 views
How to query system specs (cpu, memory, data disks, free space) using t-sql [closed]
Is there an ability to query below system specifications using t-sql ?
1. cpu (show number of processors / cores / frequency)
2. memory (show total amount of RAM on a machine; show allocated RAM; ...
1
vote
1answer
195 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 ...
5
votes
1answer
655 views
Excessive Postgres Docker CPU Consumption
I'm using a Postgres container to run some small non-critical apps and sites. It's been stable for a while, but now the container has started to consume some serious CPU after it's been running for a ...
0
votes
0answers
48 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 ...
0
votes
1answer
13 views
Alternatives to User Defined Performance Counters for CPU Monitoring - SQL 2014
I want to monitor CPU usage before implementing TDE on several production SQL Servers.
My plan was to use user defined performance counters, over a period of a couple of days, counters as defined ...
8
votes
2answers
2k views
What is causing high CPU usage from this query/execution plan?
I have an Azure SQL Database that powers a .NET Core API app. Browsing the performance overview reports in the Azure Portal suggests that the majority of the load (DTU usage) on my database server is ...
3
votes
1answer
558 views
SQL Server not using all NUMA memory with 20 core limit and affinity mask
I have a physical SQL Server 2016 SP1 machine with this spec:
CPU Sockets: 2
Cores per socket: 44
Multithreading: Yes
Number of cores: 88
RAM: 256 GB
SQL Server Max Memory: 240 GB
...
1
vote
1answer
46 views
Strange CPU load on SQL Server [closed]
Starting at midnight for 30-40 minutes our application responds slowly (or times-out completely) What would cause this kind of cpu usage on a SQL 2012 server?
I cannot find any scheduled tasks or ...
1
vote
0answers
188 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 ...
0
votes
1answer
236 views
MySQL killed query with status “copying to tmp table”
We had an ALTER TABLE statement that added a new column which was taking quite a long time on status
copying to tmp table
Given we did not know how long it will take we decided to kill the query ...
1
vote
1answer
837 views
Do I gain read performance improvement by using zlib rather than snappy compression in MongoDB?
My current storage engine is WiredTiger and its compression level is as default, snappy. I've come across MongoDB documentation and it's been mentioned that using zlib compress better but needs more ...
3
votes
1answer
1k views
how to get the CPU speed in SQL Server?
when I run the following query from Glenn Berry
-- Hardware information from SQL Server 2016 (Query 18) (Hardware Info)
SELECT cpu_count AS [Logical CPU Count], scheduler_count, hyperthread_ratio ...
0
votes
1answer
1k 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 (kernel@kernel.ovh.net) (gcc ...
2
votes
1answer
1k views
The CPU utilization spikes to 80+ even with just one user on Amazon RDS (MYSQL INNODB)
These are my RDS instance configs
Instance Class: db.m3.xlarge
Storage 40 GB
Engine MySQL 5.6.34
Multi AZ : No
I have a the node.js based backend hosted in EC2 instance and also have a cloud front ...
0
votes
2answers
67 views
Application on Different SQL Servers
In a Sql note "you should never put applications in each other's way if you do not have to.. Applications sharing memory, CPUs, internal tempdb can cause an issue. One application submitting a ...
0
votes
0answers
1k views
Availability Group Lease Timeout: what is causing 100% CPU utilization and lease time outs on PRIMARY replica?
We have an availability group
Replica-01 (Sync on-premise) PRIMARY
Replica-02 (Sync on-premise) SECONDARY
Replica-03 (Async Azure VM) SECONDARY
Replica-01 is sometimes having lease time out and ...
4
votes
3answers
3k views
More than 15000 sleeping sessions in SQL Server 2014
The CPU utilization is going to 100% regularly, and when I check SP_who2, it is showing around 20000 sessions, most of them are sleeping (also utilizing the CPU).
I think the CPU load is related to ...
11
votes
3answers
4k views
Major performance problems on our production SQL Server, how would I troubleshoot this?
This question is basically the a follow up question to this question:
Strange performance problem with SQL Server 2016
We now went productive with this system. Though another application database ...
3
votes
1answer
348 views
Cpu-Alert in SQL Server -2012 standard edition
My question is an extension to this.
We have SQL Server Agent alerts(Deadlocks, Network IO etc) to monitor SQL Server performance. So i would like to write an alert for CPU increase percentage. ...
1
vote
1answer
393 views
High memory usage due to RING_BUFFER
I have a server that is churning up the CPU using 60% to 80% constantly. Using a tool from Brent Ozar's First Responder Kit, it shows RING_BUFFER_SCHEDULER_MONITOR is the culprit. What is this, and ...
2
votes
1answer
37 views
What's the difference of setting up CPU affinity between by Server's Task Manager and by SSMS?
What's the difference of setting up CPU affinity between by Server's Task Manager and by SSMS?
Which one is more reliable?
Thanks in advance.
4
votes
3answers
6k views
Improving RAM and CPU utilization by PostgreSQL 9.6
I've been running a function on the database that is going into each table, ALTER COLUMN on all columns of a certain data type, and CAST to remove trailing zeros. About 115 tables varying from a few ...
3
votes
4answers
1k 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 ...
3
votes
1answer
4k views
Is it bad to assign specific processors to SQL Server 2008 R2 cluster instances?
I have a SQL Server 2008 R2 failover cluster with a passive node and an active node. The servers are physically identical. I have two instances of SQL Server, one set to use all the CPUs in the ...
