All Questions
Tagged with cpu optimization
6 questions
2
votes
2
answers
820
views
SQL Server - performance for certain partition is slow until restart
On production environment, randomly having strange issue.
There are tables with days as partition (1,2..31). There is only last 5 day data in tables, there are also tables which doesn't have ...
- 41
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 ...
2
votes
2
answers
723
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 ...
0
votes
0
answers
139
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 ...
- 1,335
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 ...
7
votes
3
answers
31k
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 ...
- 403