RE: Fast method needed to determine if a table is corrupt

2004-11-10 Thread Mark Steele
c: '[EMAIL PROTECTED]' Subject: Re: Fast method needed to determine if a table is corrupt In the last episode (Nov 08), Tim Murtaugh said: > I'm using MySQL server version 4.0.15a in an embedded envirionment (as > a standalone server, I'm not using the embedded server library)

Re: Fast method needed to determine if a table is corrupt

2004-11-09 Thread Gleb Paharenko
Hello. I assume that MyISAM tables are checked thorougly, i.e. each record is read and compared to the table definition. How big your table is and what kind of storage it is on? If the time to check is comparable to the time needed to actually read the whole data from the storage - then it'

Re: Fast method needed to determine if a table is corrupt

2004-11-08 Thread gerald_clark
Tim Murtaugh wrote: Hi, I'm using MySQL server version 4.0.15a in an embedded envirionment (as a standalone server, I'm not using the embedded server library). I have 128 MB of memory and disk space is tight. I'm using MyISAM tables. If my system loses power, some tables are left in a corrupt st

Re: Fast method needed to determine if a table is corrupt

2004-11-08 Thread Dan Nelson
In the last episode (Nov 08), Tim Murtaugh said: > I'm using MySQL server version 4.0.15a in an embedded envirionment > (as a standalone server, I'm not using the embedded server library). > I have 128 MB of memory and disk space is tight. I'm using MyISAM > tables. > > If my system loses power,

Fast method needed to determine if a table is corrupt

2004-11-08 Thread Tim Murtaugh
Hi, I'm using MySQL server version 4.0.15a in an embedded envirionment (as a standalone server, I'm not using the embedded server library). I have 128 MB of memory and disk space is tight. I'm using MyISAM tables. If my system loses power, some tables are left in a corrupt state. As stated in