_buffer = 2M
I am open to other tuning also.
mark
Mark Dalton wrote:
> I am getting table corruption on one machine that I was testing a change
> to get better performance.
>
> This is using the C API to connect to the database. With the delete
> without
> the sort b
I am getting table corruption on one machine that I was testing a change
to get better performance.
This is using the C API to connect to the database. With the delete
without
the sort by id, I started getting the database key corruption. There
were about
2.6 million rows matched to be
Hi,
Pls try altering the engine type from 'MyISAM' to 'InnoDB'
mysql > alter table `tablename` ENGINE='InnoDB';
Just try out. I'm not sure. But there are issues over 'MyISAM' engine' and
table corruption. Pls look into the link
ht
hello
I am still facing the same problem..
MyISAM table corruptionI am getting following errors
mysql> use DB1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> check table t
?
2) Could delay_key_write ON be the reason for this corruption, or setting
it off minimise the chances of it happenning ?
3) How can I debug / add logs to give me a clue about the corruption
origin ? What would you do to find out the problem / solve it ?
4) Are there settings that minimize / maximiz
elay_key_write ON be the reason for this corruption, or setting it
off minimise the chances of it happenning ?
3) How can I debug / add logs to give me a clue about the corruption origin
? What would you do to find out the problem / solve it ?
4) Are there settings that minimize / maximize table
-
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
View this message in context:
http://www.nabble.com/Frequently-MyISAM-TABLE-corruption.Pls-help-tf3715472.html#a10412877
Sen
; Gerald L. Clark
> Supplier Systems Corporation
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
View this message in context:
http://www.nabble.com/
Nilnandan wrote:
Hello all,
I have one server which has mysql 5.0.27 installed. There is one table named
table1.
that table has 122000 records..It has 114 fields and 22 indexes.
Now this table always been corrupt. I have try to found the solution but i
couldn't.
Pls help me ASAP. I have used
this message in context:
http://www.nabble.com/Frequently-MyISAM-TABLE-corruption.Pls-help-tf3715472.html#a10393479
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
So I've been poking around my system and I found
/usr/lib/mysql/
/usr/share/mysql/
The mod dates on these are really old. Can I delete these safely?
I'm guessing the are from the Apple install.
These files seem to be in the /usr/local/mysql/ path also. Hmmm... I
looked at my old Mac OS
On Jul 23, 2005, at 12:49 PM, Ware Adams wrote:
Then I don't know what to say about the MyISAM error, though I'd
watch InnoDB pretty carefully as I think MyISAM is pretty robust on
OS X too. We did also see these when a disk is failing, but I
assume you've run disk utility. I guess it co
On Jul 23, 2005, at 1:58 PM, Dan Tappin wrote:
On Jul 23, 2005, at 10:14 AM, Ware Adams wrote:
Has your mysql crashed or have your restarted the machine without
first shutting down mysql manually? We only saw this error when
mysql was not shut down normally. You can look in your .err fi
On Jul 23, 2005, at 10:14 AM, Ware Adams wrote:
Has your mysql crashed or have your restarted the machine without
first shutting down mysql manually? We only saw this error when
mysql was not shut down normally. You can look in your .err file
which should be in your data directory. Ever
On Jul 23, 2005, at 11:56 AM, Dan Tappin wrote:
I am all most ready to give up on MySQL at this point. I'm still
getting regular table corruption on multiple installs of OS X.
I went as far as reporting it as a bug:
http://bugs.mysql.com/bug.php?id=12066
They seem to want more info b
I am all most ready to give up on MySQL at this point. I'm still
getting regular table corruption on multiple installs of OS X.
I went as far as reporting it as a bug:
http://bugs.mysql.com/bug.php?id=12066
They seem to want more info but my requests for clarification have
gone unans
On Jul 6, 2005, at 10:26 AM, [EMAIL PROTECTED] wrote:
I'm not a Mac guru but what you describe sounds like file system
corruption. Can you do a diagnostic scan of your hard drives
looking for bad sectors? You can move your data to another portion
of the disk if you run an ALTER TABLE to ma
Dan Tappin <[EMAIL PROTECTED]> wrote on 07/06/2005 11:26:13 AM:
> I am running into repeatable table corruption with MySQL 4.x on Mac
> OS X 10.x.
>
> I previously had a MySQL install on 10.2 Client under 3.x and never
> had an issue or any major problems at all. I
along the way.
Could the dump and restore perhaps fix this? Can I still do it with
out down grading?
Dan T
On Jul 6, 2005, at 9:26 AM, Dan Tappin wrote:
I am running into repeatable table corruption with MySQL 4.x on Mac
OS X 10.x.
I previously had a MySQL install on 10.2 Client under 3.
I am running into repeatable table corruption with MySQL 4.x on Mac
OS X 10.x.
I previously had a MySQL install on 10.2 Client under 3.x and never
had an issue or any major problems at all. I upgraded to MySQL 4.x
and have subsequently installed MySQL 4.x (from the supplied pkg's)
We have a large OS X MySQL deployment on multiple servers and we have
experienced a range of weirdness with table corruption that I was never able
to fully determine the cause for.
Moving to G5 Xserves (from G5 Towers and G4 Xserves) has seen all the
problems go away as if a switch were thrown. I
Hello,
We have been running MySQL (about 50 databases, some medium-sized,
some small, mix of MyISAM and InnoDB) on Mac OS X Client for more than
a year (currently 10.3.8 with MySQL 4.1.10) and I have never seen any
corrupt tables. We use only the MySQL-provided packages for our
binaries.
Maybe th
Ave,
I run MySQL 4.x on my Power Mac G5 with Mac OS X 10.3.8 with PHP5. I have
been running Apache Web Server and my websites on this machine for almost 6
months now. And twice I have faced table corruption which I had to fix using
REPAIR TABLE. Twice in 6 months isn't bad at all, yet, I w
MySQL package.
On Apr 4, 2005, at 11:00 AM, Dan Tappin wrote:
I have been running into issues with MySQL table corruption issues on
a couple of OS X systems. I end up with tables that need repair every
day and some times multiples times per day. It's so bad now that I
have a script that run
I have been running into issues with MySQL table corruption issues on a
couple of OS X systems. I end up with tables that need repair every
day and some times multiples times per day. It's so bad now that I
have a script that runs the mysql 'REPAIR TABLE...' command and the
All,
We run mysql 3.23.58 on a Tru64 OSF 4.0F. There are 3 tables that are
consitently corrupt; these tables are fixed using myisamchk and after a
couple of hours they are corrupt again. The following are errors in mysql
error log.
/usr/local/mysql/bin/myisamchk: ISAM file
/usr/local/mysql/
Have a look at your /var/log/messages for messages around the time the
table crashes . It really should not crash this much. Is there a
quota system on your box ? I once had a table marked corrupt and
though I tried hard to find where the problem is, I was not able to.
Eventually, it turne
matt_lists wrote:
every few days I get one of these
MySql: Can't open file: 'mrf.MYI' (errno: 145)
For more information, see Help and Support Center at
http://www.mysql.com.
Checking table: './db/mrf'
For more information, see Help and Support Center at
http://www.mysql.com.
Recovering table: '
matt_lists wrote:
Raj Shekhar wrote:
Mark Maggelet wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext
index on it. The table gets corrupted every 1 week or so and I have
to repair it. I've tried upgrading to newer versions of mysql 3
times but the problem persists. I t
Raj Shekhar wrote:
Mark Maggelet wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext
index on it. The table gets corrupted every 1 week or so and I have
to repair it. I've tried upgrading to newer versions of mysql 3 times
but the problem persists. I think it may have s
Mark Maggelet wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3 times but the
problem persists. I think it may have something to do with
Random hardware failures will NOT only impact a single file.
The only thing that I know that will consistantly fail at the same spot is s/w.
On Mon, 03 Jan 2005 16:32:31 -0800, Mark Maggelet
<[EMAIL PROTECTED]> wrote:
> Thanks Mike,
> It's hardware raid, but I don't know the manufacturer. I could
Thanks Mike,
It's hardware raid, but I don't know the manufacturer. I could try to
find out but if the problem is the hardware there isn't much I can do
about it anyway without turning it into a big project.
I'm not really expecting to solve this, I'm just hoping for some advice
on what the pro
At 12:37 PM 1/3/2005, you wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3 times but the
problem persists. I think it may have somethin
keywords`)
) TYPE=MyISAM
OS is RedHat 9 - 2.4.20-8smp
I'd rather not upload the crashed table because it is really big and it
has some sensitive data.
Thanks,
- Mark
Heikki Tuuri wrote:
Mark,
- Original Message - From: "Mark Maggelet"
<[EMAIL PROTECTED]>
Newsgroups: mailing.datab
Mark,
- Original Message -
From: "Mark Maggelet" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, January 03, 2005 8:36 PM
Subject: big table corruption
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The tabl
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3 times but the
problem persists. I think it may have something to do with the raid 1
mirror b
/2004 04:07 cc
PM[EMAIL PROTECTED]
Subject
Re: myisam table corruption
Please
Is this accurate? My understanding from the changelog in 4.0.18 was
that DELAYED is only ignored when using:
INSERT DELAYED ... SELECT ...
But not otherwise. So unless he's doing that, that portion shouldn't
be an issue. If you have alternative information, please let me know.
Thanks!
On Mo
On Monday 15 November 2004 03:25 pm, Jeff Smelser wrote:
> insert delayed is a myth.. Least in the 4.1 version. 4.1.18 it was taken
> out.
Course thats 4.0.18.
pgpBoy3BGuPlh.pgp
Description: PGP signature
On Monday 15 November 2004 11:30 am, [EMAIL PROTECTED] wrote:
> I am running mysql version 4.1.7 on SuSE professional 9.1.
I run 4.0.22
> I have a MyISAM table which I use for syslog messages. This table gets
> about 40-70 inserts a second with peaks of over 400 inserts a second. I am
> using IN
Hello,
I am running mysql version 4.1.7 on SuSE professional 9.1.
I have a MyISAM table which I use for syslog messages. This table gets
about 40-70 inserts a second with peaks of over 400 inserts a second. I am
using INSERT DELAYED for all inserts, and only one thread of my application
has w
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 12:40 PM
To: [EMAIL PROTECTED]
Subject: Re: frecvent table corruption
"adam" <[EMAIL PROTECTED]> wrote:
> The actual error message we get is:
>
> " SELECT
"adam" <[EMAIL PROTECTED]> wrote:
> The actual error message we get is:
>
> " SELECT query FROM namedqueries WHERE userid = 4 AND name = '(Default
> query)': Got error 127 from table handler at globals.pl line 276. "
[EMAIL PROTECTED] egor]$ perror 127
Error code 127: Unknown error 127
127 =
Hello.
My company is using mysql as a backed to Bugzilla.
However, recently, as the number of users that are logging bugs increased we
are experiencing frequent table corruption and loss of data.
The actual error message we get is:
" SELECT query FROM namedqueries WHERE userid =
Odhiambo Washington <[EMAIL PROTECTED]> wrote:
>> > +--++--++
>> > | atmail.Users | repair | info | Key 1 - Found wrong stored record at 0 |
>> > | atmail.Users | repair | status | OK |
>>
On Wednesday 04 August 2004 06:44 am, Odhiambo Washington wrote:
> Is there hope for me in this situation??? I have googled and googled but
> all that I see doesn't seem to help me to recover the data in the table.
>
> This makes me very desparate.
>
> I'd be very thankful for any pointers that wo
* Egor Egorov <[EMAIL PROTECTED]> [20040804 16:24]: wrote:
> Odhiambo Washington <[EMAIL PROTECTED]> wrote:
>
> > +--++--++
> > | atmail.Users | repair | info | Key 1 - Found wrong stored record at 0 |
> > | atmail.Users | rep
Odhiambo Washington <[EMAIL PROTECTED]> wrote:
> +--++--++
> | atmail.Users | repair | info | Key 1 - Found wrong stored record at 0 |
> | atmail.Users | repair | status | OK |
> +
Hello DB-users,admins,
I have serious problem with a table in a DB that I have.
This is on a mysql-4.0.20.
mysql> CHECK TABLE Users;
+--+---+--+--+
| Table|
I am having some problems with constant table corruption on a database. I have
now had this occur on two different operating systems with two different
versions of MySQL. I edit these tables using Phpmyadmin (again two different
version) and eventually, either after 1-5 actions, the table gets
Hi,
After setting up a slave mysql server ( 4.0.17 ) on an SMP linux box (
kernel 2.4.18 SMP ). I noticed that one of my large tables ( 300MB )
started to corrupt regularly ( every day or two day max ). I discover
its corruption after getting the error "Got error 127 from table
handler". Repairing
myisamchk doesn't recover it.)
> From: "Hassan Shaikh" <[EMAIL PROTECTED]>
> To: "MySQL List" <[EMAIL PROTECTED]>
> Subject: MyISAM Table Corruption
> Date: Tue, 3 Feb 2004 12:50:29 +0400
> What are the chances of MyISAM tables corruption when the ta
What are the chances of MyISAM tables corruption when the table is
update rarely? (Once in a 60+ days). It's basically a lookup table
used mainly in SELECT statements.
Thanks.
Hassan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
torsdag 18. desember 2003, 13:24, skrev Victor Medina:
> I also agree with you, it might be a hardware problem, but i also must
> note, that in a environment with very often writes to the db, myisam
> tables are not always the best choice, that's why i suggested a change
> to InnoDB tables, a probl
DB or BDB
> >
> > Best Regards!
> >
> > On Fri, 2003-12-12 at 15:05, James E Hicks III wrote:
> > > I'm having sporadic myisam table corruption. This table is constantly being
> > > added to, updated, and deleted from. PHPMyAdmin reports that "The t
your
environment.
Thomas Spahni
On Fri, 12 Dec 2003, Victor Medina wrote:
> Change myisam format to something else, like InoDB or BDB
>
> Best Regards!
>
> On Fri, 2003-12-12 at 15:05, James E Hicks III wrote:
> > I'm having sporadic myisam table corruption. This table i
Change myisam format to something else, like InoDB or BDB
Best Regards!
On Fri, 2003-12-12 at 15:05, James E Hicks III wrote:
> I'm having sporadic myisam table corruption. This table is constantly being
> added to, updated, and deleted from. PHPMyAdmin reports that "The ta
I'm having sporadic myisam table corruption. This table is constantly being
added to, updated, and deleted from. PHPMyAdmin reports that "The table is in
use" when I try to access this table after corruption. After I perform this
step in the correct directory everything goes
Hi!
On Nov 27, [EMAIL PROTECTED] wrote:
> >Description:
>
> The included sql test script (output of mysqldump 10.2 (create table
> statement and insertion of 250 records into this table) with added
> check for table integrity) results in corrupted table and error
> message 'Found key at pag
On Dec 01, 2003, at 18:00, Jared Klett wrote:
b.) Is there a proven way to backup MySQL databases that have to be up
and running 24/7/365?
Well, I don't know so much about a 'proven' way - but I use replication
on another server and it works pretty good for me. When i want to make
a static bac
hi all,
I have MySQL 3.23.58 running on Solaris 9 x86, and it's been working
fantastically.
I recently added this to a crontab:
/usr/local/mysql/bin/mysqldump --all-databases --opt -u jklett >
/storage/backup/mysql-all-databases.sql 2>&1
And the backup file gets created with the right amou
[EMAIL PROTECTED] wrote:
>>Description:
>
> The included sql test script (output of mysqldump 10.2 (create table statement and
> insertion of 250 records into this table) with added check for table integrity)
> results in corrupted table and error message 'Found key at page 36864 that poi
atabaseIdentifier',0,'GO:0005682',NULL,NULL,NULL,NULL,NULL,00,NULL,NULL),(9731,NULL,'DatabaseIdentifier',0,'GO:0004284',NULL,NULL,NULL,NULL,NULL,00,NULL,NULL),(9732,NULL,'DatabaseIdentifier',0,'GO:0005683',NULL,NULL,NU
I have a Mysql 4.0.14 standard database. A developer runs 'mysql
optimize table_name' on a small database. After running it, the SQL gui
reports that the 'MESSAGES.MYI' cannot be read.
We have to use myisamchk -o on the table to get the table back but it is
missing a lot of updates.
Any idea wh
Hi!
On Sep 09, [EMAIL PROTECTED] wrote:
>
> I'm using MySQL v4.0.12 on Redhat Linux 9.0
>
> I have a python script (using the MySQLdb module) that inserts a large
> batch of records to several MyISAM tables. The largest table (named
> 'log') has 20 columns. A single column defines the primary
On Tue, Sep 09, 2003 at 02:56:56PM -0700, [EMAIL PROTECTED] wrote:
>
> This seemed like an ideal case to DISABLE KEYS, insert the data and
> then ENABLE KEYS based on the MySQL documentation. And running some time
> tests proves that this approach runs much faster.
>
> However, in doing so, th
I'm using MySQL v4.0.12 on Redhat Linux 9.0
I have a python script (using the MySQLdb module) that inserts a large
batch of records to several MyISAM tables. The largest table (named
'log') has 20 columns. A single column defines the primary key. There
isn't an auto increment column. Many of
Are there any known issues with table corrouption on 4.0.14-standard-log?
I'm getting recurring problems with a single table becoming corrupted, does
mysql handle disk full problems gracefully or could that cause something
like this?
# myisamchk -c jobs
Checking MyISAM file: jobs
Data records:
chnology,
> > CoreSense Inc.
> > (518) 306-3043 x3951
> >
> > - Original Message -
> > From: "Joseph Bueno" <[EMAIL PROTECTED]>
> > To: "Tom Roos" <[EMAIL PROTECTED]>
> > Cc: "Richard Gabriel" <[EMAIL PROTEC
t;
Cc: "Richard Gabriel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 4:10 AM
Subject: Re: Frequent Table Corruption - Please Help
Have you tried to use a non SMP kernel ?
I have also experienced table corruptions 2 years ago with
mysql 3.23.xx and a
Bueno" <[EMAIL PROTECTED]>
To: "Tom Roos" <[EMAIL PROTECTED]>
Cc: "Richard Gabriel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 4:10 AM
Subject: Re: Frequent Table Corruption - Please Help
> Have you tried to use a non
t;[EMAIL PROTECTED]>
To: "Richard Gabriel" <[EMAIL PROTECTED]>; "Heikki Tuuri"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 2:59 AM
Subject: RE: Frequent Table Corruption - Please Help
hi guys
i am runing the rh 2.4.20-18.7smp k
high.
i'm trying different parameters for mysqld to see if the problem goes away.
tom
-Original Message-
From: Richard Gabriel [mailto:[EMAIL PROTECTED]
Sent: 15 July 2003 22:35
To: Heikki Tuuri; [EMAIL PROTECTED]
Subject: Re: Frequent Table Corruption - Please Help
Thank you very
Original Message -
From: "Tom Roos" <[EMAIL PROTECTED]>
To: "Richard Gabriel" <[EMAIL PROTECTED]>; "Heikki Tuuri"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 9:59 AM
Subject: RE: Frequent Table Corruption - P
ailto:[EMAIL PROTECTED]
Sent: 15 July 2003 22:35
To: Heikki Tuuri; [EMAIL PROTECTED]
Subject: Re: Frequent Table Corruption - Please Help
Thank you very much for the help. I will schedule the upgrade and see if
helps. I have 2 other machines running 2.4.18 without problems, but they
also do not ru
Inc.
(518) 306-3043 x3951
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 15, 2003 4:08 PM
Subject: Re: Frequent Table Corruption - Please Help
> Richard,
>
> - Original Message -
&g
Richard,
- Original Message -
From: "Richard Gabriel" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 15, 2003 10:53 PM
Subject: Re: Frequent Table Corruption - Please Help
> Thanks for the tip
anks again!
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 15, 2003 3:45 PM
Subject: Re: Frequent Table Corruption - Please Help
Message -
From: "Richard Gabriel" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, July 15, 2003 9:52 PM
Subject: Frequent Table Corruption - Please Help
> Hi everyone,
>
> Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting tabl
Hi everyone,
Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table
corruption often. It happens about twice per week (with about 500
queries per second average). I have even set up a cron to run
mysqlcheck every hour to try to do some damage control. The biggest
problem is
>Description:
The table is corrupted after DELETE FROM ; command:
There is one table called tmprecord in my database used as temporary table
and for serialisation of changes in another table.
It's used under following schema only:
LOCK tmprecord as tmprecord WRITE, (loc
Pada Thu, 12 Sep 2002 22:22:24 +
"Inandjo Taurel" <[EMAIL PROTECTED]> menulis :
> sqlsqlsqlsqlsqlsqlsqlsqlsql
>
>
> hi ,
>
> I've been having a constant nightmare for the past 2 weeks: a particular
> table gets corrupted every at least twice.
> Am using the 3.23.49 windows version and Myis
sqlsqlsqlsqlsqlsqlsqlsqlsql
hi ,
I've been having a constant nightmare for the past 2 weeks: a particular
table gets corrupted every at least twice.
Am using the 3.23.49 windows version and Myisam table types on Win2k, and
the operation crashing the database seems to be an update.
I get an erro
Chris,
Sunday, July 14, 2002, 5:44:49 AM, you wrote:
CB> I'm new to the list.
CB> I'm writing because I've been having trouble with table corruption. I'm
CB> using isam tables and i've been using myisamchk under linux to check them.
CB> alot of the time it
Hi people,
I'm new to the list.
I'm writing because I've been having trouble with table corruption. I'm
using isam tables and i've been using myisamchk under linux to check them.
alot of the time it just reports that some of the tables were'nt closed
properly so i re
Kevin,
Wednesday, July 10, 2002, 10:36:06 PM, you wrote:
KF> One of our servers (of many running the same software and mysql version) is
KF> frequently getting
KF> "ERROR 1030: Got error 127 from table handler"
KF> on two of its tables.
KF> mysql version is 3.23.49.
KF> We can not rec
On Wed, 10 Jul 2002, Kevin Fries wrote:
> One of our servers (of many running the same software and mysql version) is
> frequently getting
> "ERROR 1030: Got error 127 from table handler"
>
> on two of its tables.
>
> mysql version is 3.23.49.
>
>
> We can not recover with myisamchk -r,
One of our servers (of many running the same software and mysql version) is
frequently getting
"ERROR 1030: Got error 127 from table handler"
on two of its tables.
mysql version is 3.23.49.
We can not recover with myisamchk -r, but instead have to use "myisamchk -o"
which ends up wipin
Hi,
I've observed some table corruption:
How-To-Repeat: no idea, but maybe you might have one ;)
$ mysql -hxxx Escherichia_coli_O157_H7
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any
I've been using MySQL on WindowsNT and Solaris for about 5-6 years
(don't use any NT machines anymore), and have yet to experience a
single corrupted table, mysql daemon crash or any other problem with
MySQL. There were a couple of minor snafus when I was setting things
up, but they were mostl
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 8:01 PM
Subject: InnoDB and Table Corruption
> I am working with a low-load, mission-critical database. Although I have
> yet to have a corrupted table, I seem to read about it a lot on the
> list. This is a s
I am working with a low-load, mission-critical database. Although I have
yet to have a corrupted table, I seem to read about it a lot on the
list. This is a scary thought for me, considering the importance of the
data I manage. Can anyone tell me if this is a rare occurrence? Is it
even r
Hello list,
This is the output of mysql myisamchk -s */*.MYI, which seems very badly
corrupted. I know myisamchk -o or myisamchk -c will rescue this, but is
any idea to know what made the corruptions?
myisamchk: ISAM file stocks/TimelyDeals.MYI
myisamchk: error: Size of datafile is: 5645430
Hello list,
This is the output of mysql myisamchk -s */*.MYI, which seems very badly
corrupted. I know myisamchk -o or myisamchk -c will rescue this, but is
any idea to know what made the corruptions?
myisamchk: ISAM file stocks/TimelyDeals.MYI
myisamchk: error: Size of datafile is: 5645430
Bonjour,
BA> But I forgot the "-d" ... and here is what I found : There are some
BA> "\r" at the end of some symbols !
I corrected everything with one query :
mysql> UPDATE historique_AMS set symbole=TRIM(TRAILING '\r' FROM symbole);
These '\r' may come from a program a colleague did.
Bonjour Sinisa,
SM> There were some bug fixes with packed keys.
SM> 3.23.47 will soon be out and it would be fine if you could test your
SM> case with it again.
I tried to do
>alter table historique_AMS PACK_KEYS=0;
But it did not correct the problem.
Then I wanted check if the PA
Bonjour Richard,
RE> Have you checked your table with myisamchk? Sounds like a corrupt
RE> index to me.
I did "check" and "repair" table from mysql console.
And from the documentation :
"CHECK TABLE only works on MyISAM tables. On MyISAM tables it's the
same thing as running myisamchk
BAUMEISTER Alexandre writes:
> Bonjour,
>
> I have a table :
>
[skip]
> Any idea ?
>
> Regards,
> Alex.
There were some bug fixes with packed keys.
3.23.47 will soon be out and it would be fine if you could test your
case with it again.
--
Regards,
__ ___ ___ __
/
Bonjour,
I have a table :
[11:09am]> mysqldump -d cotations historique_AMS
# MySQL dump 8.16
#
# Host: localhostDatabase: cotations
#
# Server version3.23.45
#
# Table structure for table 'historique_AMS'
#
CREATE TABLE hist
1 - 100 of 123 matches
Mail list logo
