Sfrgttk

Should my PhD thesis be submitted under my legal name?

Why are on-board computers allowed to change controls without notifying the pilots?

How to be able to process a large JSON response?

Giant Toughroad SLR 2 for 200 miles in two days, will it make it?

Pronouncing Homer as in modern Greek

Can a malicious addon access internet history and such in chrome/firefox?

Teaching indefinite integrals that require special-casing

Is there enough fresh water in the world to eradicate the drinking water crisis?

Installing PowerShell on 32-bit Kali OS fails

What to do when my ideas aren't chosen, when I strongly disagree with the chosen solution?

Books on the History of math research at European universities

Bob has never been a M before

What would you call a finite collection of unordered objects that are not necessarily distinct?

Are Warlocks Arcane or Divine?

node command while defining a coordinate in TikZ

I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?

How do ultrasonic sensors differentiate between transmitted and received signals?

Indicating multiple different modes of speech (fantasy language or telepathy)

Why is delta-v is the most useful quantity for planning space travel?

What is the opposite of 'gravitas'?

Visiting the UK as unmarried couple

Would it be legal for a US State to ban exports of a natural resource?

What is the term when two people sing in harmony, but they aren't singing the same notes?

In Star Trek IV, why did the Bounty go back to a time when whales were already rare?

Why my LOAD DATA INFILE is so slow?

mysqldump vs LOAD DATA INFILEMySQL hang in load data infile commandWhy is 'LOAD DATA INFILE' faster than normal INSERT statements?LOAD DATA INFILE decline in performanceMySQL-load data infile- invalid data validationLoad csv file to mysql using load data local infileMySQL Load Data Infile extremely slowSetting up replication with MariaDB 10.3.4 docker imagesLoad data local infile changing special characterPhpMyAdmin versus Script (Load Data Infile)

0

I have a brand new mysql docker. I created a new table:

CREATE TABLE FENWDB (

    FEN varchar(90) BINARY,



    # Number of white wins

    W INTEGER,



    # Number of black wins

    B INTEGER,



    # Number of draws

    D INTEGER,



    PRIMARY KEY (FEN)

);

My file is 1.7GB, and:

> wc games.pgn.index.fens # 25387343



> head -n1 games.pgn.index.fens

rnr3k1/p2qppbp/1p4p1/8/3PP3/B4N2/P3QPPP/1R3RK1 w - - 1 16   0   1   1

All other rows are very similar. My loading script:

USE Explorer;

LOAD DATA INFILE '/tmp/games.pgn.index.fens' 

INTO TABLE FENWDB 

FIELDS TERMINATED BY 't' 

ENCLOSED BY '"'

LINES TERMINATED BY 'n'

IGNORE 1 ROWS;

For some reason, this operation has been taking a long time, for about 12 hours and still not complete. I have a 120GB RAM powerful server machine.

Is this normal for a 1.7GB data file?

mysql

share

asked 5 mins ago

SmallChessSmallChess

1011

New contributor

SmallChess is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have a brand new mysql docker. I created a new table:

CREATE TABLE FENWDB (

    FEN varchar(90) BINARY,



    # Number of white wins

    W INTEGER,



    # Number of black wins

    B INTEGER,



    # Number of draws

    D INTEGER,



    PRIMARY KEY (FEN)

);

My file is 1.7GB, and:

> wc games.pgn.index.fens # 25387343



> head -n1 games.pgn.index.fens

rnr3k1/p2qppbp/1p4p1/8/3PP3/B4N2/P3QPPP/1R3RK1 w - - 1 16   0   1   1

All other rows are very similar. My loading script:

USE Explorer;

LOAD DATA INFILE '/tmp/games.pgn.index.fens' 

INTO TABLE FENWDB 

FIELDS TERMINATED BY 't' 

ENCLOSED BY '"'

LINES TERMINATED BY 'n'

IGNORE 1 ROWS;

For some reason, this operation has been taking a long time, for about 12 hours and still not complete. I have a 120GB RAM powerful server machine.

Is this normal for a 1.7GB data file?

mysql

share

asked 5 mins ago

SmallChessSmallChess

1011

New contributor

SmallChess is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have a brand new mysql docker. I created a new table:

CREATE TABLE FENWDB (

    FEN varchar(90) BINARY,



    # Number of white wins

    W INTEGER,



    # Number of black wins

    B INTEGER,



    # Number of draws

    D INTEGER,



    PRIMARY KEY (FEN)

);

My file is 1.7GB, and:

> wc games.pgn.index.fens # 25387343



> head -n1 games.pgn.index.fens

rnr3k1/p2qppbp/1p4p1/8/3PP3/B4N2/P3QPPP/1R3RK1 w - - 1 16   0   1   1

All other rows are very similar. My loading script:

USE Explorer;

LOAD DATA INFILE '/tmp/games.pgn.index.fens' 

INTO TABLE FENWDB 

FIELDS TERMINATED BY 't' 

ENCLOSED BY '"'

LINES TERMINATED BY 'n'

IGNORE 1 ROWS;

For some reason, this operation has been taking a long time, for about 12 hours and still not complete. I have a 120GB RAM powerful server machine.

Is this normal for a 1.7GB data file?

mysql

share

asked 5 mins ago

SmallChessSmallChess

1011

New contributor

SmallChess is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

CREATE TABLE FENWDB (

    FEN varchar(90) BINARY,



    # Number of white wins

    W INTEGER,



    # Number of black wins

    B INTEGER,



    # Number of draws

    D INTEGER,



    PRIMARY KEY (FEN)

);

> wc games.pgn.index.fens # 25387343



> head -n1 games.pgn.index.fens

rnr3k1/p2qppbp/1p4p1/8/3PP3/B4N2/P3QPPP/1R3RK1 w - - 1 16   0   1   1

USE Explorer;

LOAD DATA INFILE '/tmp/games.pgn.index.fens' 

INTO TABLE FENWDB 

FIELDS TERMINATED BY 't' 

ENCLOSED BY '"'

LINES TERMINATED BY 'n'

IGNORE 1 ROWS;

share

asked 5 mins ago

SmallChessSmallChess

1011

New contributor

SmallChess is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

SmallChessSmallChess

1011

New contributor

SmallChess is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

SmallChessSmallChess

1011

New contributor

SmallChess is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

SmallChessSmallChess

1011