my mysql db crashing sometimes why it's happen?

[barrathi]

Hai all

my mysql db crashing sometimes at that time i loss data (ya i have a backup)

why it's happen?

please tell me some suggestion

and tell me performance tuning details(if possible step by step)

and also please tell me some ref book name..


thaks a lot

barrathi

[ronverdonk]

What do you mean by crashing? What is the nature of this? Does it halt processing, does it run into an infinite loop, does it hang you OS, what ....?

Ronald :cool:

[barrathi]

hai
thanks for ur replay.

crash means totaly my msql is not working fine

it shows some error no and it shows (accsess denied using password yes).

What do you mean by crashing? What is the nature of this? Does it halt processing, does it run into an infinite loop, does it hang you OS, what ....?

Ronald :cool:

[ronverdonk]

hai
thanks for ur replay.

crash means totaly my msql is not working fine

it shows some error no and it shows (accsess denied using password yes).

So it is not crashing, it is doing its job and merely denying you access because you did not supply a valid userid and password.

Ronald :cool:

[sashi]

hai
thanks for ur replay.

crash means totaly my msql is not working fine

it shows some error no and it shows (accsess denied using password yes).

Hi there,

Please provide a simple & clear problem / error statement as it would ease in providing solution in return.

The term "crash" means something serious happen to you server, i.e. not able to start server service, OS not being able to boot and so on. Hope you understanding what am trying to say here. Good luck & Take care.

p.s/ Make things simple & clear for us to be able to help you.