why is my mysqld-nt.exe takes 40-70% cpu usage :( ? please any can help?
Discussion on why is my mysqld-nt.exe takes 40-70% cpu usage :( ? please any can help? within the CO2 Private Server forum part of the Conquer Online 2 category.
Whatever that is... uninstall it. It's not the real version of mysql. MySql is a service, not a process.
Here's the real version that you should be using:
Edit: Ah. I'm wrong. I wasn't showing processes from all of the users on my laptop. and see if that helps.
Whatever that is... uninstall it. It's not the real version of mysql. MySql is a service, not a process.
Here's the real version that you should be using:
I'll just try to disregard the abhorrent amount of bullcrap wandering around these forums and answer the question.
It's probably because of a shitload of connections and queries issued to the MySQL server. There can be just so many reasons as well. Take a look .
I suspect a badly designed query running on MySQL. Under many connections MySQL becomes a memory hog too, and I see that it's eating just 15MB of RAM from you, so I'm almost sure you're trying to run a query that needs a lot to finish.
Debug, breakpoint, check for exceptions, make sure everything is handled correct. It could be anything that blocks the user. Try login yourself and breakpoint login state, then check where it stops.
CPU Usage like this can appear from different places like:
1. A select command used on a pretty big table countless times (get the items of an unspecified hero, just to select them in your code by checking if item_heroid == hero.id)
2. Update command which should update the entire table instead of a single row or a specific list of rows (giving the WHERE clause in your query)
3. Using improper table templates (MyISAM instead of InnoDB or so) for tables that are used to store big amounts of data
4. Bad configuration of your mysql server (as in your mysql server is configured for another kind of computer, a computer like a server and not a developer's one)
and the list could go on
PS: The number of connections you have on your mysql server DOES NOT affect the CPU usage.
Takes long... 12/28/2010 - Flyff Private Server - 7 Replies Hey all,
It takes HOURS! to go into my server...
Im waiting... and waiting
Pleas what to do?
Ciao
Bart
mysqld unter TOP in Putty 11/21/2010 - Metin2 Private Server - 2 Replies Dieser Prozess geht in Putty unter TOP immer an und aus.
In der zeit laggt es ingame so für 4sek..
Kann mir jemand da weiter helfen ?
Little Question! takes only 1 min! 12/17/2009 - Dekaron Private Server - 9 Replies I have a little question,,
I released me server (no adv yet)
But I dont know what rates are the best..
Please help me question
EXP rates?:
drop rates?:
reborn?:
Nebulars No-CrC takes too long D: 06/21/2009 - Dekaron - 6 Replies Okay thx to the members of elitepvpers I have successfully logged into 2moons with a modded pack.d04 and didn't get the lame "Invalid client, etc" message!!! WOOP WOOP.....but....
The CrC bypass provided from Nebular makes my PC really laggy and takes like a decade to log in D:
So is there anything I can do to get around that? I mean I know the first login with a "virgin" pack.d04 is needed, but afterwards can I manipulate my dekaron.exe or nsse.exe so I can use them to loggin faster?
...