Hi, I posted this question a few days ago, and didn't get a reply,
so I thought that I'd try again in case it got lost amongst the
documentation/RTFM threads !!
I've got a linux database server running MySQL 3.22.32 on kernel
version 2.4.0-test8.
The database server has a number of housekeeping scripts running
in the background (around half a dozen), all written in Perl, and
the database itself is updated from 4 linux machines elsewhere on
the network. One in particular is capable of generating between
1500 and 9000 inserts into a table called CurrentTraffic every 5
minutes (the insertion rate is between 170 and 350 rows per second).
Records are removed from the table as required by one of the scripts
running in the background.
Periodically, one of the database tables gets corrupted. It's always
CurrentTraffic, and running isamchk against the table reports that
the delete list is corrupt. A few days ago, I inserted about 450 Mb
into the table, and found that it got screwed up. I don't know how
many records there were ("select count(*) from CurrentTraffic" ran
for over an hour before I gave up on it), but the table definition
isn't enormous - one char(15) and twelve int(10)'s - and
CurrentTraffic.ISD was about 530 Mb, so I'd guess at somewhere about
9.5 million rows. Three of the fields are indexed (no primary index
though).
I've read the documentation for MySQl, and paid attention to the
discussions here, but there's no mention of problems explicitly related
to the kind of setup that I've got here.
Is there an issue with bulk inserts coming over a network whilst
(different) records are being deleted by local scripts? I can't
imagine it, but who knows?
Any other ideas are, of course, welcome !!
The Hooker
--
"A closed mouth gathers no feet"
---------------------------------------------------------------------
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
