List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:January 29 2001 4:20pm
Subject:Re: What causes table corruption? (isamchk -r required)
View as plain text  
>>>>> "jds" == j d stumbles <j.d.stumbles@stripped> 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 version        10
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 version        10
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
Thread
What causes table corruption? (isamchk -r required)j.d.stumbles29 Jan
  • Re: What causes table corruption? (isamchk -r required)Vivek Khera29 Jan