• Halloween is coming! To celebrate the occasion, we dusted off a couple of old skins, and even created a brand new one (Pixel).
    To get into the festive spirit, install the Skins extension.
  • The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

MySQL Query virtually killing my server (99% CPU)

A

atinoco

Guest
Greetings, I'm experincing an important problem here, eveytime one of my clients executes certain query to their database the cpu usage of the mysqld-nt.exe process jumps to 99% and all the other services (http, pop, etc) on my server freezes for a couple of minutes (while the query runs).

Is there a way to limit the resources the mysql process uses? I any ideas on how to solve this?

I use: Windows 2003 Server, plesk 7.5.6 (windows).

Thanks in Advance
 
You must log in or register to reply here.

Similar threads

G
Issue Clarification needed: Inconsistency between Resource Limits (CPU 100%), Monitoring, and Process List (Server Crashes)
Replies
6
Views
4K
pleskpanel
P
G
Question Plesk Panel Extremely Slow and Shows White Screen Despite Server Resources Being Idle
Replies
2
Views
5K
HHawk
HHawk
T
Question Mysql memory usage and memory used by system reach 90% of available ram and then crash
2
Replies
28
Views
25K
thinkjarvis
T
Talistech
Resolved Backups failing since a couple days: Unable to run the backup agent
Replies
1
Views
6K
Talistech
Talistech
A
Issue High CPU usage and poor performance (MYSQL)
Replies
8
Views
8K
mow
M
Back
Top