What causes table corruption? (isamchk -r required)

2001-01-29 Thread j.d.stumbles


3 times in the last few days I've had tables that have become
corrupted and needed isamchk -r to repair them. I'm becoming concerned:
what can cause such errors? (and what can I do to avoid them?)

I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes
updating the tables concerned continuously, via REPLACE INTO, INSERT INTO
or UPDATE statements.

TIA

regards,

--
John Stumbles  [EMAIL PROTECTED]
I.T. Services Centre,   University of Reading  http://www.rdg.ac.uk/~visstmbl
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
never generalise


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: What causes table corruption? (isamchk -r required)

2001-01-29 Thread Vivek Khera

 "jds" == j d stumbles [EMAIL PROTECTED] writes:

jds I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes
jds updating the tables concerned continuously, via REPLACE INTO, INSERT INTO
jds or UPDATE statements.

I've never had table corruption on a Solaris box, even with older
MySQL versions.  We don't use REPLACE INTO since I find it to be quite
useless, really.  Anyhow, here are some stats.  These are using binary
versions of MySQL from the www.mysql.com site.


mysqladmin  Ver 7.8 Distrib 3.22.14-gamma, for sun-solaris2.6 on sparc
TCX Datakonsult AB, by Monty

Server version  3.22.14-gamma
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 108 days 6 hours 38 min 40 sec

Threads: 7  Questions: 12566861  Slow queries: 65925  Opens: 120  Flush tables: 1  
Open tables: 116
[prod-rtm]% uname  -a
SunOS prod-rtm.xxx.xxx 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-250


and another box:

mysqladmin  Ver 7.8 Distrib 3.22.20a, for sun-solaris2.6 on sparc
TCX Datakonsult AB, by Monty

Server version  3.22.20a
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 217 days 7 hours 16 min 26 sec

Threads: 1  Questions: 43556764  Slow queries: 10224  Opens: 967  Flush tables: 1  
Open tables: 255
[prod-rtm2]% uname -a
SunOS prod-rtm2.xxx.xxx 5.6 Generic_105181-20 sun4u sparc SUNW,Ultra-250

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php