Always corrupted after restart server

Hi List,
I have a very big size MyISAM table. For some reason I need to restart =
the server periodically. But After restarting the server, the table =
always get corrupt, and always need to run myisamchk. Don't know what =
cause the problem. But it will be very helpful if somebody can give me =
some tips to avoid this problem. Thanks alot.



sangprabv
sangprabv@gmail.com
http://www.petitiononline.com/froyo/



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Always corrupted after restart server

How are you shutting down the server during the restart.. have you
checked the logs? Might you be issuing a kill and crashing it?
MyISAM doesnot dealwith crashes very elegantly.

Also, what is some reason? Might thereason you need to restart be related?

- michael dykman


On Tue, Aug 24, 2010 at 11:13 PM, sangprabv wrote:
> Hi List,
> I have a very big size MyISAM table. For some reason I need to restart th=
e server periodically. But After restarting the server, the table always ge=
t corrupt, and always need to run myisamchk. Don't know what cause the prob=
lem. But it will be very helpful if somebody can give me some tips to avoid=
this problem. Thanks alot.
>
>
>
> sangprabv
> sangprabv@gmail.com
> http://www.petitiononline.com/froyo/
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
=A0- michael dykman
=A0- mdykman@gmail.com

=A0May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Always corrupted after restart server

On 25/08/2010 8:05 a, Michael Dykman wrote:
> How are you shutting down the server during the restart.. have you
> checked the logs? Might you be issuing a kill and crashing it?
> MyISAM doesnot dealwith crashes very elegantly.
>
> Also, what is some reason? Might thereason you need to restart be related?
>
> - michael dykman
> On Tue, Aug 24, 2010 at 11:13 PM, sangprabv wrote:
>> Hi List,
>> I have a very big size MyISAM table. For some reason I need to restart the server periodically. But After restarting the server, the table always get corrupt, and always need to run myisamchk. Don't know what cause the problem. But it will be very helpful if somebody can give me some tips to avoid this problem. Thanks alot.
>>
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=mdykman@gmail.com
>
Maybe you need to check *why* you have to keep on restarting the server?
Cure the disease, not the symptoms? We have a particular mysql server
that has been up the last 8 months with no downtime...

--
Jangita | +256 76 91 8383 | Y! & MSN: jangita@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org