Hi Krishna,
Can u please give me example of csplit.
regards
anandkl
On 6/16/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
try csplit to break the files into small chunks
On Fri, Jun 13, 2008 at 12:21 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
How do i split file during ENABLE KEYS
man csplit
try
csplit filename 10 {10}
On Mon, Jun 16, 2008 at 2:22 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Krishna,
Can u please give me example of csplit.
regards
anandkl
On 6/16/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
try csplit to break the files into small
try csplit to break the files into small chunks
On Fri, Jun 13, 2008 at 12:21 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
How do i split file during ENABLE KEYS
On 6/13/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
increase bulk_insert_buffer_size and if possible split the bigger
How do i split file during ENABLE KEYS
On 6/13/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
increase bulk_insert_buffer_size and if possible split the bigger file into
small chunks. It will help you.
On Thu, Jun 12, 2008 at 1:51 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
Hi All,
We are doing load data into a table using LOAD DATA INFILE process. Below is
the method we are following.
1. create empty table with all the indexes.
2. disable keys
3. Load data using LOAD DATA INFILE, close to 99 Million records which takes
around 3 hrs
4 . Enable keys
Table size is
Ananda Kumar wrote:
Hi All,
We are doing load data into a table using LOAD DATA INFILE process. Below is
the method we are following.
1. create empty table with all the indexes.
2. disable keys
3. Load data using LOAD DATA INFILE, close to 99 Million records which takes
around 3 hrs
4 . Enable
We have 200GB of free space on the file system where our database is
located.
On 6/12/08, Ken Menzel [EMAIL PROTECTED] wrote:
Ananda Kumar wrote:
Hi All,
We are doing load data into a table using LOAD DATA INFILE process. Below
is
the method we are following.
1. create empty table with
Ananda Kumar wrote:
We have 200GB of free space on the file system where our database is
located.
On 6/12/08, Ken Menzel [EMAIL PROTECTED] wrote:
Ananda Kumar wrote:
Hi All,
We are doing load data into a table using LOAD DATA INFILE process. Below
is
the method we are following.
1. create
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 9:41 AM
To: [EMAIL PROTECTED]
Cc: mysql
Subject: Re: enable and disable keys
We have 200GB of free space on the file system where our database is
located.
---8--- snip
If the system
/tmp has 16GB free space
On 6/12/08, Boyd, Todd M. [EMAIL PROTECTED] wrote:
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 9:41 AM
To: [EMAIL PROTECTED]
Cc: mysql
Subject: Re: enable and disable keys
We have 200GB of free
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 10:27 AM
To: Boyd, Todd M.
Cc: mysql
Subject: Re: enable and disable keys
/tmp has 16GB free space
On 6/12/08, Boyd, Todd M. [EMAIL PROTECTED] wrote:
-Original Message-
From: Ananda Kumar [mailto:[EMAIL
yes, this is the default folder its configured.
On 6/12/08, Boyd, Todd M. [EMAIL PROTECTED] wrote:
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 10:27 AM
To: Boyd, Todd M.
Cc: mysql
Subject: Re: enable and disable keys
/tmp has 16GB free space
On 6/12/08
increase bulk_insert_buffer_size and if possible split the bigger file into
small chunks. It will help you.
On Thu, Jun 12, 2008 at 1:51 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
We are doing load data into a table using LOAD DATA INFILE process. Below
is
the method we are following.
13 matches
Mail list logo