RE: Corruption and my.cnf
Dear Mark,
I think your emailer has also experienced corruption since your from address
is actually mine. Please set it to your own email address, such as
[EMAIL PROTECTED]
Thanks,
Mike
> -Original Message-
> From: Michael McTernan
> Sent: 09 April 2004 12:18
> To: [EMAIL PROTECTED]
> 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 the
> > tables are large. I didn't have this level of problems on the
> rental server.
> >
> > 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=0x59 { DriveReady SeekComplete DataRequest Error }
> hdb: read_intr: error=0x40 { UncorrectableError },
> LBAsect=56276830, high=3,
> low=5945182, sector=52228450
>
> Is it possible this is related to my MySQL table corruption issues? There
> are more of these in the file.
>
>
> Mark Súsol
> ---
> u l t i m a t e 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]
Re: Corruption and my.cnf
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=3D52228450
>
> 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]
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 the
> tables are large. I didn't have this level of problems on the rental server.
>
> 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=0x59 { DriveReady SeekComplete DataRequest Error }
hdb: read_intr: error=0x40 { UncorrectableError }, LBAsect=56276830, high=3,
low=5945182, sector=52228450
Is it possible this is related to my MySQL table corruption issues? There
are more of these in the file.
Mark Súsol
---
u l t i m a t e 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]
