Hi!
>>>>> "marcello" == marcello <[EMAIL PROTECTED]> writes:
marcello> Hi,
marcello> I have a problem with 3-23.34a, running a shell scripts like this:
marcello> .............................................................................
marcello> for table in ${table-list} # that is a very long list, just about 1030
marcello> # different tables
marcello> do
marcello> ## this command send to mysql the create table command
marcello> dbutil -a -f $table | mysql -A $DB
marcello> ## This command create a sequential file tab separated
marcello> dbutil -S $table -f $pathname -d $TMPDIR/$table.seq
marcello> ## And this to insert data into DB
marcello> mysql -A $DB <<!
marcello> LOAD DATA INFILE '$TMPDIR/$table.seq' IGNORE INTO
TABLE $table
marcello> !
marcello> done
marcello> .............................................................................
marcello> Some table have the index files corruped !
Why do you think the index is corrupted?
Did you run 'CHECK TABLE' on the tables ?
(not that myisamchk may report problems if you don't do flush-table,
but this is normal !)
marcello> to avoid the problem I need to insert 'mysqladmin flush-table' inside, in
marcello> this way:
<cut>
marcello> Is it correct ?
This should not be needed!
marcello> Do you think that the 3.23.35 should fix this problem ?
As we don't know what could be the problem in your case, I don't think
this is fixed in 3.23.25.
Any change you can create a test case for us?
marcello> Do you think that i have to wait to upgrade the customer from 3.23.34 to
marcello> 3.23.35, i have notice that last version introduce another bug but i don't
marcello> know wich one.
marcello> What is the difference between Innobase, gemini and BDB tables, in the other
marcello> words, wich one has the right support on mySQL now and is more stable that i
marcello> can use it without any problem to manage transactions ?
The normal MYSQL binary doesn't have any of the above table handlers.
All of the above table handlers are still to be regarded 'for testing
only'. All the table handlers do however past our test and benchmark
suite, so they 'should work'. It will however take 1-2 months before
we can start to regard these as 'reasonable solid for any work', just
because they have not yet been used by a large group of MySQL users.
Regards,
Monty
---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
