Questions tagged [cpu]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
0answers
35 views

Why does my MySQL page cleaner thread step up its minimum CPU usage over time and never decrease back to zero?

I’m running a MySQL 5.7.29 instance on Ubuntu 16.04 on a dedicated Amazon EC2 t3a.XLARGE instance (4 vCPUS, 16 GiB Memory connected to an iOPS optimized EBS volume with 1000 provisioned iOPS) and have ...
2
votes
0answers
76 views

SQL Server, what is the optimal Processor & Core configuration for VMs? [duplicate]

In my day job I deal with alot of SQL Servers...and lately I've had a rash of clients running 16 cores but configured as 1 core per processor and their SQL Standard edition runs like a dog, as ...
2
votes
2answers
39 views

Virtualized SQL Server hits 100% CPU and 0 Active Memory

We recently experienced an odd crash with one of our server. We know what caused it, but we don't know why SQL Server responded the way it did. SQL Server 2016 Here is what happened: Friday: ...
-2
votes
1answer
87 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
30 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
123 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
72 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
132 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
18 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
57 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
36 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
129 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
56 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
289 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
318 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
39 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
32 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
168 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
29 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
174 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
25 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
342 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
40 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
385 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
419 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
170 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
204 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 ...
5
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
86 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
40 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
356 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
281 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
1k 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
54 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
22 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 ...
9
votes
2answers
5k 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
915 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
60 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
217 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
385 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
2k 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
2k 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
7k 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 ...