Generally, you should find that removing and re-adding the indexes will
speed up your operation.
I do not believe that ALTER TABLE with just index additions will require
a table rebuild, but even if it does, doing a table copy will be a
fairly fast operation (much faster than loading from othe
I am loading 35 million rows of data into an empty MyISAM table. This table
has 1 primary key (AutoInc) and 1 unique index and 2 non-unique indexes.
Is it going to be any faster if I remove the indexes from the table before
loading the data, load the data, then do an Alter Table .. add index ..
Is the CREATE TABLE you show the result of SHOW CREATE TABLE or your own
create statement? If the latter, please show the output of SHOW CREATE.
Does SELECT succeed if you remove the INSERT part of the statement?
You might want to consider adding an index on transactionlogid, this
could bring
Hello!
If you use *nix sistem. You can use the 'tail' utilit with -f flag.
In the first terminal you use: mysqldump or 'select * into outfile'.
In the second terminal you can use: tail -f file_name.
This is help for monitoring.
2010/2/21 Yang Zhang
> Hi, I'm interested in piping out the contents
