Hi,
I have a problem with 3-23.34a, running a shell scripts like this:
.............................................................................
for table in ${table-list} # that is a very long list, just about 1030
# different tables
do
## this command send to mysql the create table command
dbutil -a -f $table | mysql -A $DB
## This command create a sequential file tab separated
dbutil -S $table -f $pathname -d $TMPDIR/$table.seq
## And this to insert data into DB
mysql -A $DB <<!
LOAD DATA INFILE '$TMPDIR/$table.seq' IGNORE INTO TABLE $table
!
done
.............................................................................
Some table have the index files corruped !
to avoid the problem I need to insert 'mysqladmin flush-table' inside, in
this way:
.............................................................................
or table in ${table-list} # that is a very long list, just about 1030
# different tables
do
## this command send to mysql the create table command
dbutil -a -f $table | mysql -A $DB
mysqladmin flush-tables
## This command create a sequential file tab separated
dbutil -S $table -f $pathname -d $TMPDIR/$table.seq
## And this to insert data into DB
mysql -A $DB <<!
LOAD DATA INFILE '$TMPDIR/$table.seq' IGNORE INTO TABLE $table
!
mysqladmin flush-tables
done
.............................................................................
Is it correct ?
Do you think that the 3.23.35 should fix this problem ?
Do you think that i have to wait to upgrade the customer from 3.23.34 to
3.23.35, i have notice that last version introduce another bug but i don't
know wich one.
What is the difference between Innobase, gemini and BDB tables, in the other
words, wich one has the right support on mySQL now and is more stable that i
can use it without any problem to manage transactions ?
Regards
marcello
