Hi!
Sergei == Sergei Golubchik [EMAIL PROTECTED] writes:
cut
Sergei Ok, mysqlimport uses LOAD DATA INFILE.
Yes, but they are simply convenient shortcuts to
myisamchk --keys-used=0 -rq
You can enable/disable keys from command line in 3.23.
Ok, what is the suggested usage?
create
MySQL - spam bypasser
myisamchk --keys-used=3D0 -rq
You can enable/disable keys from command line in 3.23.
While that would disable the key before the load,
how do I re-enable them afterwards?
-
Before posting, please
I'm trying to understand the most efficient load sequence
possible.
I've got 2 large tables. Each is about 50 million rows,
taking about 20GB of disk space. My disk is accessed
via fibre channel, and can read/write about 40 MB per
second.
My system is a dual PIII 850, running Linux 2.4.2-2smp
Hi!
On Dec 04, Barry Roomberg wrote:
I'm trying to understand the most efficient load sequence
possible.
I've got 2 large tables. Each is about 50 million rows,
taking about 20GB of disk space.
My system is a dual PIII 850, running Linux 2.4.2-2smp #1 SMP.
Memory: 1GB.
The actual
Hi Barry,
It is, indeed, faster to load the data then create the indexes.
Instead of 'disable' and 'enable', you could try:
- ALTER TABLE DROP index (or drop the table and create it without indexes.)
- load your data
- ALTER TABLE ADD index
HTH,
/Rob
At 09:40 -0500 2001/12/04, Barry
I've always thought it would be great if there was a way to drop an object but
keep the meta data so I can recreate objects without having to store the ddl
somewhere.
alter table drop index retain metadata
Would be helpful.
Dave
On Tue, Dec 04, 2001 at 11:19:43AM -0500, Robert Alexander
Hi!
On Dec 04, David Turner wrote:
I've always thought it would be great if there was a way to drop an object but
keep the meta data so I can recreate objects without having to store the ddl
somewhere.
alter table drop index retain metadata
Would be helpful.
That's what ALTER TABLE
Thanks, but I'm looking at having this for all objects
drop table mytable retain metadata;
etc
Dave
On Tue, Dec 04, 2001 at 06:52:17PM +0100, Sergei Golubchik wrote:
Hi!
On Dec 04, David Turner wrote:
I've always thought it would be great if there was a way to drop an object but
keep
Hi!
First: please reply to mysql-list and not directly to me.
Then:
On Dec 04, Barry Roomberg wrote:
Hi!
Hi back.
Why do you need RAID ? Are you using ext2fs ?
With 2.4.2 you can use reiserfs, which does not have 2GB file limit.
Using ext2fs right now. Heard a lot of reiserfs