Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Saints should always be judged guilty until they are proven innocent. -- George Orwell


devel / comp.databases.mysql / Re: load data infile somewhat flaky

SubjectAuthor
* load data infile somewhat flakyDFS
`* Re: load data infile somewhat flakyJohann Klammer
 `* Re: load data infile somewhat flakyDFS
  `* Re: load data infile somewhat flakyDr Eberhard Lisse
   `* Re: load data infile somewhat flakyDFS
    +- Re: load data infile somewhat flakyJ.O. Aho
    +- Re: load data infile somewhat flakyAxel Schwenke
    `* Re: load data infile somewhat flakyThe Natural Philosopher
     +- Re: load data infile somewhat flakyDFS
     `- Re: load data infile somewhat flakyJerry Stuckle

1
load data infile somewhat flaky

<T4SSI.3$Qp7.1@fx46.iad>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=27&group=comp.databases.mysql#27

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!4.us.feeder.erje.net!2.eu.feeder.erje.net!feeder.erje.net!news.uzoreto.com!newsfeed.xs4all.nl!newsfeed7.news.xs4all.nl!news-out.netnews.com!news.alt.net!fdc2.netnews.com!peer01.ams1!peer.ams1.xlned.com!news.xlned.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!fx46.iad.POSTED!not-for-mail
Newsgroups: comp.databases.mysql
X-Mozilla-News-Host: news://usnews.blocknews.net:119
From: nos...@dfs.com (DFS)
Subject: load data infile somewhat flaky
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.13.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Lines: 17
Message-ID: <T4SSI.3$Qp7.1@fx46.iad>
X-Complaints-To: abuse@blocknews.net
NNTP-Posting-Date: Tue, 17 Aug 2021 17:11:15 UTC
Organization: blocknews - www.blocknews.net
Date: Tue, 17 Aug 2021 13:11:14 -0400
X-Received-Bytes: 1333
 by: DFS - Tue, 17 Aug 2021 17:11 UTC

Finally got a big file (3 columns x 612K rows) of messy data loaded.

load data infile 'file.csv'
into table
fields terminated by ','
enclosed by '"';

I noticed it tells you an error occurred at a certain line, but the
offending data (a text field ending in \ or "\") 5 lines later was the
real issue.

On one run 5 lines didn't post, and it turns out they were the next 5
lines after a field ending in "\". Those 5 lines got concatenated with
the offending line, so I had one large clump of data in one row.

Moral: watch for fields ending in \ or "\".

Re: load data infile somewhat flaky

<sfif9v$15o4$1@gioia.aioe.org>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=29&group=comp.databases.mysql#29

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!aioe.org!E3GnTvseyk6PorvVSnzUKA.user.46.165.242.91.POSTED!not-for-mail
From: klamm...@NOSPAM.a1.net (Johann Klammer)
Newsgroups: comp.databases.mysql
Subject: Re: load data infile somewhat flaky
Date: Wed, 18 Aug 2021 10:10:26 +0200
Organization: Aioe.org NNTP Server
Message-ID: <sfif9v$15o4$1@gioia.aioe.org>
References: <T4SSI.3$Qp7.1@fx46.iad>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="38660"; posting-host="E3GnTvseyk6PorvVSnzUKA.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:24.0) Gecko/20100101 Icedove/24.5.0
X-Notice: Filtered by postfilter v. 0.9.2
 by: Johann Klammer - Wed, 18 Aug 2021 08:10 UTC

On 08/17/2021 07:11 PM, DFS wrote:
> Finally got a big file (3 columns x 612K rows) of messy data loaded.
>
> load data infile 'file.csv'
> into table
> fields terminated by ','
> enclosed by '"';
>
> I noticed it tells you an error occurred at a certain line, but the offending data (a text field ending in \ or "\") 5 lines later was the real issue.
>
> On one run 5 lines didn't post, and it turns out they were the next 5 lines after a field ending in "\". Those 5 lines got concatenated with the offending line, so I had one large clump of data in one row.
>
> Moral: watch for fields ending in \ or "\".
>
I seem to recall it also has problems with whitespace around the commata.

Re: load data infile somewhat flaky

<Y78TI.490$Oz2.40@fx47.iad>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=30&group=comp.databases.mysql#30

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!newsreader4.netcologne.de!news.netcologne.de!peer03.ams1!peer.ams1.xlned.com!news.xlned.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!fx47.iad.POSTED!not-for-mail
Subject: Re: load data infile somewhat flaky
Newsgroups: comp.databases.mysql
References: <T4SSI.3$Qp7.1@fx46.iad> <sfif9v$15o4$1@gioia.aioe.org>
From: nos...@dfs.com (DFS)
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.13.0
MIME-Version: 1.0
In-Reply-To: <sfif9v$15o4$1@gioia.aioe.org>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Lines: 31
Message-ID: <Y78TI.490$Oz2.40@fx47.iad>
X-Complaints-To: abuse@blocknews.net
NNTP-Posting-Date: Wed, 18 Aug 2021 13:43:20 UTC
Organization: blocknews - www.blocknews.net
Date: Wed, 18 Aug 2021 09:43:20 -0400
X-Received-Bytes: 2204
 by: DFS - Wed, 18 Aug 2021 13:43 UTC

On 8/18/2021 4:10 AM, Johann Klammer wrote:
> On 08/17/2021 07:11 PM, DFS wrote:
>> Finally got a big file (3 columns x 612K rows) of messy data loaded.
>>
>> load data infile 'file.csv'
>> into table
>> fields terminated by ','
>> enclosed by '"';
>>
>> I noticed it tells you an error occurred at a certain line, but the offending data (a text field ending in \ or "\") 5 lines later was the real issue.
>>
>> On one run 5 lines didn't post, and it turns out they were the next 5 lines after a field ending in "\". Those 5 lines got concatenated with the offending line, so I had one large clump of data in one row.
>>
>> Moral: watch for fields ending in \ or "\".
>>
> I seem to recall it also has problems with whitespace around the commata.

Yes, I saw that too.

It was a fiasco. Wasted a fair amt of my time. A couple times it would
spend 10 minutes reading a file (Stage 1 of 1...) then tell me it bombed
on row 1 (which was valid data).
Near the end of my db cloning process (15 tables, 30M rows total, SQLite
to MariaDB) I wrote a little python program to copy the data.

The python code did - no joking - nearly 2700+ inserts/second into
MariaDB. I copied 1.5M rows (~4GB) in under 10 minutes.

'load data infile' isn't worthless - it worked decently fast on simple
data - but there are better ways of getting data into MariaDB.

Re: load data infile somewhat flaky

<io6qceFqsemU1@mid.individual.net>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=31&group=comp.databases.mysql#31

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: nos...@lisse.NA (Dr Eberhard Lisse)
Newsgroups: comp.databases.mysql
Subject: Re: load data infile somewhat flaky
Date: Thu, 19 Aug 2021 12:33:47 +0200
Lines: 62
Message-ID: <io6qceFqsemU1@mid.individual.net>
References: <T4SSI.3$Qp7.1@fx46.iad> <sfif9v$15o4$1@gioia.aioe.org>
<Y78TI.490$Oz2.40@fx47.iad>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: individual.net SLnZYGzbJsj8YxC3IdjOug+jyL0sAZlfJm/NFEESTJ4f1F5O46
Cancel-Lock: sha1:LuCg01O3BYbQ2Ln89PACcHqtWOg=
User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.0.2)
Gecko/20060308 Thunderbird/1.5.0.2 Mnenhy/0.7.4.0
In-Reply-To: <Y78TI.490$Oz2.40@fx47.iad>
Content-Language: en-US
 by: Dr Eberhard Lisse - Thu, 19 Aug 2021 10:33 UTC

I find that using tools like CSVQ helps with checking CSV data
integrity.

Turning off indexes and such during the load and generating them
afterwards speeds loading of data up significantly.

However,

https://www.google.com/search?q=sqlite+to+mariadb

has 1.5 Million results :-)-O

I have used

https://pypi.org/project/sqlite3-to-mysql/

in the past successfully

el

On 18/08/2021 15:43, DFS wrote:
> On 8/18/2021 4:10 AM, Johann Klammer wrote:
>> On 08/17/2021 07:11 PM, DFS wrote:
>>> Finally got a big file (3 columns x 612K rows) of messy data loaded.
>>>
>>> load data infile 'file.csv'
>>> into table
>>> fields terminated by ','
>>> enclosed by '"';
>>>
>>> I noticed it tells you an error occurred at a certain line, but the
>>> offending data (a text field ending in \ or "\") 5 lines later was
>>> the real issue.
>>>
>>> On one run 5 lines didn't post, and it turns out they were the next
>>> 5 lines after a field ending in "\". Those 5 lines got concatenated
>>> with the offending line, so I had one large clump of data in one
>>> row.
>>>
>>> Moral: watch for fields ending in \ or "\".
>>>
>> I seem to recall it also has problems with whitespace around the
>> commata.
>
>
> Yes, I saw that too.
>
> It was a fiasco. Wasted a fair amt of my time. A couple times it
> would spend 10 minutes reading a file (Stage 1 of 1...) then tell me
> it bombed on row 1 (which was valid data). Near the end of my db
> cloning process (15 tables, 30M rows total, SQLite to MariaDB) I wrote
> a little python program to copy the data.
>
> The python code did - no joking - nearly 2700+ inserts/second into
> MariaDB. I copied 1.5M rows (~4GB) in under 10 minutes.
>
> 'load data infile' isn't worthless - it worked decently fast on simple
> data - but there are better ways of getting data into MariaDB.

--
To email me replace 'nospam' with 'el'

Re: load data infile somewhat flaky

<UvsTI.1064$qV1.572@fx18.iad>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=32&group=comp.databases.mysql#32

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.uzoreto.com!news-out.netnews.com!news.alt.net!fdc3.netnews.com!peer03.ams1!peer.ams1.xlned.com!news.xlned.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!fx18.iad.POSTED!not-for-mail
Subject: Re: load data infile somewhat flaky
Newsgroups: comp.databases.mysql
References: <T4SSI.3$Qp7.1@fx46.iad> <sfif9v$15o4$1@gioia.aioe.org>
<Y78TI.490$Oz2.40@fx47.iad> <io6qceFqsemU1@mid.individual.net>
From: nos...@dfs.com (DFS)
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.13.0
MIME-Version: 1.0
In-Reply-To: <io6qceFqsemU1@mid.individual.net>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Lines: 100
Message-ID: <UvsTI.1064$qV1.572@fx18.iad>
X-Complaints-To: abuse@blocknews.net
NNTP-Posting-Date: Thu, 19 Aug 2021 12:54:12 UTC
Organization: blocknews - www.blocknews.net
Date: Thu, 19 Aug 2021 08:54:12 -0400
X-Received-Bytes: 3980
 by: DFS - Thu, 19 Aug 2021 12:54 UTC

On 8/19/2021 6:33 AM, Dr Eberhard Lisse wrote:

> I find that using tools like CSVQ helps with checking CSV data
> integrity.

The data came out of a SQLite db and was fairly clean, but encoding
issues meant the SQLite data had 'dupes':

this field has a question mark ? in it
this field has a question mark � in it

> Turning off indexes and such during the load and generating them
> afterwards speeds loading of data up significantly.
>
> However,
>
>      https://www.google.com/search?q=sqlite+to+mariadb
>
> has 1.5 Million results :-)-O

www.google.com/search?q=mariadb+to+sqlite

has 1.4M results

SQLite has been very robust for this db of 30M rows. Easy to backup and
administer, never crashed, fast querying... but it's very slow to alter
big tables, and I wanted to see what all the fuss about MySQL/MariaDB
was about.

It (MariaDB) is a nice dbms, I must say. Especially for no cost/open
source.

I also looked at Oracle Express Edition, but it was limited to 10GB of
data, and my database with indexes is at least 15GB.

> I have used
>
>      https://pypi.org/project/sqlite3-to-mysql/
>
> in the past successfully

Thanks.

I'll look at it. I wrote my own source to dest python code, and the
INSERT rate into MariaDB was fast, as high as 8600 per second on some
tables.

Overall: 30.6M rows copied in 5770 seconds = 5304 per second (on my
11-year-old i5-750 computer). That's still 96 minutes, so I wonder if
there's a better way.

> el
>
> On 18/08/2021 15:43, DFS wrote:
>> On 8/18/2021 4:10 AM, Johann Klammer wrote:
>>> On 08/17/2021 07:11 PM, DFS wrote:
>>>> Finally got a big file (3 columns x 612K rows) of messy data loaded.
>>>>
>>>> load data infile 'file.csv'
>>>> into table
>>>> fields terminated by ','
>>>> enclosed by '"';
>>>>
>>>> I noticed it tells you an error occurred at a certain line, but the
>>>> offending data (a text field ending in \ or "\") 5 lines later was
>>>> the real issue.
>>>>
>>>> On one run 5 lines didn't post, and it turns out they were the next
>>>> 5 lines after a field ending in "\".  Those 5 lines got concatenated
>>>> with the offending line, so I had one large clump of data in one
>>>> row.
>>>>
>>>> Moral: watch for fields ending in \ or "\".
>>>>
>>> I seem to recall it also has problems with whitespace around the
>>> commata.
>>
>>
>> Yes, I saw that too.
>>
>> It was a fiasco.  Wasted a fair amt of my time.  A couple times it
>> would spend 10 minutes reading a file (Stage 1 of 1...)  then tell me
>> it bombed on row 1 (which was valid data).  Near the end of my db
>> cloning process (15 tables, 30M rows total, SQLite to MariaDB) I wrote
>> a little python program to copy the data.
>>
>> The python code did - no joking - nearly 2700+ inserts/second into
>> MariaDB. I copied 1.5M rows (~4GB) in under 10 minutes.
>>
>> 'load data infile' isn't worthless - it worked decently fast on simple
>> data - but there are better ways of getting data into MariaDB.
>

Re: load data infile somewhat flaky

<io74a9Fsp3lU1@mid.individual.net>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=33&group=comp.databases.mysql#33

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: use...@example.net (J.O. Aho)
Newsgroups: comp.databases.mysql
Subject: Re: load data infile somewhat flaky
Date: Thu, 19 Aug 2021 15:23:21 +0200
Lines: 45
Message-ID: <io74a9Fsp3lU1@mid.individual.net>
References: <T4SSI.3$Qp7.1@fx46.iad> <sfif9v$15o4$1@gioia.aioe.org>
<Y78TI.490$Oz2.40@fx47.iad> <io6qceFqsemU1@mid.individual.net>
<UvsTI.1064$qV1.572@fx18.iad>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: individual.net il5r0lTYzlS+SNl0Zen0UAPqb2S0rps5B7k3Gim0pqjgMZeAVX
Cancel-Lock: sha1:anmz9dW3zRtWbLnqhbaFlgIuYBU=
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
Thunderbird/78.13.0
In-Reply-To: <UvsTI.1064$qV1.572@fx18.iad>
Content-Language: en-US-large
 by: J.O. Aho - Thu, 19 Aug 2021 13:23 UTC

On 19/08/2021 14.54, DFS wrote:
> On 8/19/2021 6:33 AM, Dr Eberhard Lisse wrote:
>
>> I find that using tools like CSVQ helps with checking CSV data
>> integrity.
>
> The data came out of a SQLite db and was fairly clean, but encoding
> issues meant the SQLite data had 'dupes':
>
> this field has a question mark ? in it
> this field has a question mark � in it

As long as it's the same charset used in the sqlite, it shouldn't be too
much work to fix it, but a completely different thing is it's a mix.

>> Turning off indexes and such during the load and generating them
>> afterwards speeds loading of data up significantly.
>>
>> However,
>>
>>       https://www.google.com/search?q=sqlite+to+mariadb
>>
>> has 1.5 Million results :-)-O
>
>
> www.google.com/search?q=mariadb+to+sqlite
>
> has 1.4M results
>
> SQLite has been very robust for this db of 30M rows.  Easy to backup and
> administer, never crashed, fast querying... but it's very slow to alter
> big tables, and I wanted to see what all the fuss about MySQL/MariaDB
> was about.
>
> It (MariaDB) is a nice dbms, I must say.  Especially for no cost/open
> source.

PostgreSQL is worth to mention (I know shouldn't say it here), also open
source and do have some nice features missing in MariaDB/MySQL.

--

//Aho

Re: load data infile somewhat flaky

<sflr0t$sev$1@dont-email.me>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=34&group=comp.databases.mysql#34

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: axel.sch...@gmx.de (Axel Schwenke)
Newsgroups: comp.databases.mysql
Subject: Re: load data infile somewhat flaky
Date: Thu, 19 Aug 2021 16:49:00 +0200
Organization: A noiseless patient Spider
Lines: 17
Message-ID: <sflr0t$sev$1@dont-email.me>
References: <T4SSI.3$Qp7.1@fx46.iad> <sfif9v$15o4$1@gioia.aioe.org>
<Y78TI.490$Oz2.40@fx47.iad> <io6qceFqsemU1@mid.individual.net>
<UvsTI.1064$qV1.572@fx18.iad>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Injection-Date: Thu, 19 Aug 2021 14:49:01 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="ff6b6794c06de305997a56f5866b348b";
logging-data="29151"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+Ce1NPrD0sVBIyaKkDcMFTGjHlwE3V3SM="
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
Thunderbird/52.9.1
Cancel-Lock: sha1:xVk3UXTKPA7kka3suKtS7sdpaoc=
In-Reply-To: <UvsTI.1064$qV1.572@fx18.iad>
Content-Language: en-US
 by: Axel Schwenke - Thu, 19 Aug 2021 14:49 UTC

On 19.08.2021 14:54, DFS wrote:
> On 8/19/2021 6:33 AM, Dr Eberhard Lisse wrote:
>
> The data came out of a SQLite db and was fairly clean, but encoding issues
> meant the SQLite data had 'dupes':

That makes no sense. If the data source has other encoding (charset) than
the destination, it is the DBAs fault. He has to make sure that destination
encoding allows all characters from the source.

>>>>> On one run 5 lines didn't post, and it turns out they were the next
>>>>> 5 lines after a field ending in "\".  Those 5 lines got concatenated
>>>>> with the offending line, so I had one large clump of data in one
>>>>> row.

Invalid data in exported files is also the DBAs fault. He must use proper
quoting if the data contains special characters like '\'

Re: load data infile somewhat flaky

<sflv7j$qi6$2@dont-email.me>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=35&group=comp.databases.mysql#35

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: tnp...@invalid.invalid (The Natural Philosopher)
Newsgroups: comp.databases.mysql
Subject: Re: load data infile somewhat flaky
Date: Thu, 19 Aug 2021 17:00:51 +0100
Organization: A little, after lunch
Lines: 11
Message-ID: <sflv7j$qi6$2@dont-email.me>
References: <T4SSI.3$Qp7.1@fx46.iad> <sfif9v$15o4$1@gioia.aioe.org>
<Y78TI.490$Oz2.40@fx47.iad> <io6qceFqsemU1@mid.individual.net>
<UvsTI.1064$qV1.572@fx18.iad>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 19 Aug 2021 16:00:51 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="517b01fabff319477ea24224e8ca3052";
logging-data="27206"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/6Sif83+dAx5XThv+QpOLnZ3y2LlJRMMg="
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
Thunderbird/60.6.1
Cancel-Lock: sha1:8u5nr1lc/HtWnqhJU+kuUVEMzYw=
In-Reply-To: <UvsTI.1064$qV1.572@fx18.iad>
Content-Language: en-GB
 by: The Natural Philosop - Thu, 19 Aug 2021 16:00 UTC

On 19/08/2021 13:54, DFS wrote:
> and my database with indexes is at least 15GB.
....indices.... ^^^^^^^

--
Outside of a dog, a book is a man's best friend. Inside of a dog it's
too dark to read.

Groucho Marx

Re: load data infile somewhat flaky

<_HvTI.1419$vA6.1107@fx23.iad>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=36&group=comp.databases.mysql#36

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!aioe.org!news.uzoreto.com!fdc2.netnews.com!news-out.netnews.com!news.alt.net!fdc3.netnews.com!peer02.ams1!peer.ams1.xlned.com!news.xlned.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!fx23.iad.POSTED!not-for-mail
Subject: Re: load data infile somewhat flaky
Newsgroups: comp.databases.mysql
References: <T4SSI.3$Qp7.1@fx46.iad> <sfif9v$15o4$1@gioia.aioe.org>
<Y78TI.490$Oz2.40@fx47.iad> <io6qceFqsemU1@mid.individual.net>
<UvsTI.1064$qV1.572@fx18.iad> <sflv7j$qi6$2@dont-email.me>
From: nos...@dfs.com (DFS)
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.13.0
MIME-Version: 1.0
In-Reply-To: <sflv7j$qi6$2@dont-email.me>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Lines: 9
Message-ID: <_HvTI.1419$vA6.1107@fx23.iad>
X-Complaints-To: abuse@blocknews.net
NNTP-Posting-Date: Thu, 19 Aug 2021 16:31:54 UTC
Organization: blocknews - www.blocknews.net
Date: Thu, 19 Aug 2021 12:31:53 -0400
X-Received-Bytes: 1152
 by: DFS - Thu, 19 Aug 2021 16:31 UTC

On 8/19/2021 12:00 PM, The Natural Philosopher wrote:
> On 19/08/2021 13:54, DFS wrote:
>> and my database with indexes is at least 15GB.
> ...indices....         ^^^^^^^

or indexes.

Re: load data infile somewhat flaky

<sfoqgu$8eg$1@jstuckle.eternal-september.org>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=38&group=comp.databases.mysql#38

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!jstuckle.eternal-september.org!.POSTED!not-for-mail
From: jstuck...@attglobal.net (Jerry Stuckle)
Newsgroups: comp.databases.mysql
Subject: Re: load data infile somewhat flaky
Date: Fri, 20 Aug 2021 13:58:51 -0400
Organization: A noiseless patient Spider
Lines: 14
Message-ID: <sfoqgu$8eg$1@jstuckle.eternal-september.org>
References: <T4SSI.3$Qp7.1@fx46.iad> <sfif9v$15o4$1@gioia.aioe.org>
<Y78TI.490$Oz2.40@fx47.iad> <io6qceFqsemU1@mid.individual.net>
<UvsTI.1064$qV1.572@fx18.iad> <sflv7j$qi6$2@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Fri, 20 Aug 2021 17:58:54 -0000 (UTC)
Injection-Info: jstuckle.eternal-september.org; posting-host="81bb4d10e646f550df40771fda0b9ba2";
logging-data="8656"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+VdkygLkojRyENl6rM4FuAGgVSEPbpRCU="
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.13.0
Cancel-Lock: sha1:TyBM60nppe9a+IJDqnKvwKUw5NU=
In-Reply-To: <sflv7j$qi6$2@dont-email.me>
Content-Language: en-US
 by: Jerry Stuckle - Fri, 20 Aug 2021 17:58 UTC

On 8/19/2021 12:00 PM, The Natural Philosopher wrote:
> On 19/08/2021 13:54, DFS wrote:
>> and my database with indexes is at least 15GB.
> ...indices....         ^^^^^^^
>

Both are acceptable. https://www.dictionary.com/browse/index

--
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex@attglobal.net
==================

1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor