Mark,
----- Original Message -----
From: "Mark Susol|Ultimate Creative Media"
<[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 08, 2004 11:25 PM
Subject: Re: Corruption and my.cnf
> > I've experienced more corruption lately on my main site since I moved to
=
> my
> > own server running 4.0.17max. The site is very busy (60GB a month) and
th=
> e
> > tables are large. I didn't have this level of problems on the rental
serv=
> er.
> >=20
> > What are the variables to look into regarding why my tables are getting
> > corrupt? Is this a my.cnf issue? Is this a memory issue? Is this a hard
> > drive issue? Is this a too many connections issue?
>
> Looking at my dmesg output..
>
> end_request: I/O error, dev 03:42 (hdb), sector 52228450
> hdb: read_intr: status=3D0x59 { DriveReady SeekComplete DataRequest
Error }
> hdb: read_intr: error=3D0x40 { UncorrectableError }, LBAsect=3D56276830,
high=3D3=
> ,
> low=3D5945182, sector=3D5222 8450
>
> Is it possible this is related to my MySQL table corruption issues? There
> are more of these in the file.
it might be. Corruption has a cause, and usually it is the OS/drivers or the
hardware.
> Mark S=FAsol
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Register now for the 2004 MySQL Users Conference!
http://www.mysql.com/events/uc2004/index.html
> -------------------------------
> u l t i m a t e =AD CreativeMedia
> Web | Print | CD Media | eCommerce
> www.ultimatecreativemedia.com
> Ph: 301-668-0588
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
