[Help] mysqld-nt.exe using 80% cpu!

[Dexboy]

Hey guys, recently my computer has been using 100% cpu which sucks and I checked what was causing this and its due to 'mysqld-nt.exe' using 80-100% cpu D: mysql has been fine for 2 months or so and I never encountered this, now that stops the world server and crashes it >.>

So anything I can do to solve this problem?

Thanks alot

[MentaL]

[FrostElite]

You mean with caali server files?

[Dexboy]

It doesnt really matter about caali files, its a problem that happens to lots of people and Im just seeing if theres a way to fix it :S

[FrostElite]

there is a way to fix it

[Dexboy]

there is a way to fix it

you tease me

[x103strike]

very easy back up ur database and come on reinstall........there is something wrong on it just reinstall it should be fine

[DaRkAnGeL]

Hey guys, recently my computer has been using 100% cpu which sucks and I checked what was causing this and its due to 'mysqld-nt.exe' using 80-100% cpu D: mysql has been fine for 2 months or so and I never encountered this, now that stops the world server and crashes it >.>

So anything I can do to solve this problem?

Thanks alot

give me your pc specs and decrease the mysql usage... so reinstall your mysql configs

[travistah]

Sorry for this noob question How can i make backup for MYSQL Navicat? thank you for replying

[DaRkAnGeL]

Sorry for this noob question How can i make backup for MYSQL Navicat? thank you for replying

open your navicat and you will see the back up option.....as i remember is in the right icons

[Dexboy]

give me your pc specs and decrease the mysql usage... so reinstall your mysql configs

Windows vista ultimate

AMD Athlon(tm) 64 processor 3000+ 1.81 GHz

2.00 GB RAM

32-bit operating system

I did the MySQLInstantceConfig again and made it all default, but still Im getting the same problem.. It stays at 5-10 cpu then shoots up randomly to 80-90% cpu. What should the CPU be for mysqld-nt anyways? So I guess I have to reinstall it all over again and put my queries and such back : /

[travistah]

Darkangel i open my navicat but there is no backup here only this Connection,Manage User,Table,View,Stored Procedure,Event,Querry, thats all there is no back up can u help me?

[DaRkAnGeL]

Windows vista ultimate

AMD Athlon(tm) 64 processor 3000+ 1.81 GHz

2.00 GB RAM

32-bit operating system

I did the MySQLInstantceConfig again and made it all default, but still Im getting the same problem.. It stays at 5-10 cpu then shoots up randomly to 80-90% cpu. What should the CPU be for mysqld-nt anyways? So I guess I have to reinstall it all over again and put my queries and such back : /

vista sucks in the hosting server idea... i do not have time to check the power of your machine.. but in a few hours you will have an answer

Darkangel i open my navicat but there is no backup here only this Connection,Manage User,Table,View,Stored Procedure,Event,Querry, thats all there is no back up can u help me?

we have different version.. well next to file there is the view... check there

[Dexboy]

vista sucks in the hosting server idea... i do not have time to check the power of your machine.. but in a few hours you will have an answer

I see, When I reinstall it shall I use MySQL Light?

[DaRkAnGeL]

I see, When I reinstall it shall I use MySQL Light?

well when you will reinstall your mysql make it to be a developer machine not a server machine, as these files do not need so cpu power or ram....

[Dexboy]

well when you will reinstall your mysql make it to be a developer machine not a server machine, as these files do not need so cpu power or ram....

Okey I reinstalled, and got my backup fine, I noticed that mysqld-nt has dissapered and been replaced by mysqld.exe (the same) but it spikes up when theres someone logging in. So if so 10 people log in at the same time is spikes to 90% cpu for around 1 min, but atleast its a short period of time.

Thx

[DaRkAnGeL]

Okey I reinstalled, and got my backup fine, I noticed that mysqld-nt has dissapered and been replaced by mysqld.exe (the same) but it spikes up when theres someone logging in. So if so 10 people log in at the same time is spikes to 90% cpu for around 1 min, but atleast its a short period of time.

Thx

ok i am happy to read it

[travistah]

we have different version.. well next to file there is the view... check there

But Dark i click the view but no backup here!! hmmm what version did u use??

[DaRkAnGeL]

But Dark i click the view but no backup here!! hmmm what version did u use??

i use navicat 8 and in the view i have the back up also next to report icon i have the back up icon