Questions tagged [cpu]
The cpu tag has no usage guidance.
54
questions
-1
votes
1answer
45 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 ...
0
votes
0answers
24 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 ...
1
vote
2answers
99 views
How to calculate the max number of worker threads in SQL Server?
I use 64-bit OS with two CPUs (each of them makes 7 logical processors) and with total number of logical processors equal to 14.
When I run this code I get 2048
SELECT max_workers_count FROM sys....
0
votes
1answer
61 views
Trying to find out what is consuming all the CPU
SQL Server Specs :
SQL Server 2016 Standard
128 GB RAM for the SQL Server dedicated server.
108 GB allocated to SQL Server
40 logical CPU
All SQL Queries run in parallel mode and queries are pretty ...
2
votes
1answer
127 views
User connections without a login
I was looking at SQL Server performance and noticed that CPU utilization goes high when the number of connections go high(I believe it is normal).Usually number of connections on an average was ...
0
votes
0answers
15 views
High constant CPU on Aurora/RDS
I've noticed recently that our resting CPU on our Aurora RDS cluster appears to be about 80%. I'm unsure when this started, as we don't have alarms/metrics in place (something I plan to rectify now).
...
-1
votes
1answer
50 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%. ...
0
votes
2answers
33 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 ...
0
votes
0answers
24 views
Trying to identify if the query is long running or long waiting
I have a sql query which has multiple joins and uses a view which has multiple joins.I captured the query in sql profiler and i see few information in there.
I am trying to understand whether the ...
2
votes
0answers
116 views
Brand new SQL Server 2016 (SP2/CU1), has high CPU utilization with no mounted databases when the box experiences memory pressure
Brand new SQL Server 2016 (SP2/CU1), has high CPU utilization with no mounted databases when the box experiences memory pressure.
I have a test box for nightly builds with a brand new SQL Server 2016 ...
0
votes
1answer
51 views
Postgres consuming a lot of cpu [closed]
I have a Java system with Postgres 8.3 and Glassfish application server, from time to time, the application is very slow at certain times - when it has more hits; by the top command, we can see the ...
3
votes
1answer
261 views
Best way to divide CPU along all sql instances on 1 server
I have a physical server with 40 CPU's (hyperthreaded) with 2 NUMA nodes. On this server I have 20 SQL Server instances installed and I need to make sure each instance has some dedicated CPU assigned ...
0
votes
1answer
264 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% ...
1
vote
0answers
38 views
SQL Server suddenly using a lot of CPU: 300 compilations/s vs 2 batches/s
A instance of SQL Server Express 2016 that I'm in charge of has suddenly started to use a lot more CPU that usual. It's the backend database for a website, but doesn't see all that many queries due to ...
0
votes
1answer
31 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 ...
-3
votes
1answer
162 views
Sql Server consumes CPU but no one is using the server
In my server I have a SQL process that consumes CPU (~10%) but no one is using the server.
In query select * from master.dbo.sysprocesses order by cpu desc I see at least one suspect process:
spid: 9
...
0
votes
1answer
28 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 ...
0
votes
1answer
152 views
Thread Count is too high-what can I do in short term?
Before I posted this question read following articles.
Max. Worker Threads and when you should change it by Sakthivel Chidambaram
Are my actual worker threads exceeding the sp_configure 'max worker ...
0
votes
0answers
24 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 ...
0
votes
1answer
275 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
38 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
352 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
394 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
155 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
197 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 ...
4
votes
1answer
1k 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
80 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
39 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
339 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
2k 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
2k 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
275 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
997 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
53 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
21 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
4k 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
887 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
58 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
215 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
368 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 ...
2
votes
1answer
1k 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 ...
4
votes
1answer
2k 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 ...
1
vote
1answer
3k 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
2k 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 ...
3
votes
3answers
6k 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
5k 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
442 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
626 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 ...
