I'm trying to import some csv files into my mysql mariadb database, but I'm having problems with some files. Importing csv with a line with only spaces (2MB of space character) the database stops for hours without giving an answer. I then created a csv file with only spaces, copying it exactly from one of the many files that cause the problem: 1.888.653 byte of spaces and when I run the query by importing this file the server no longer responds.
MariaDB version: 10.1.31-MariaDB - mariadb.org binary distribution Protocol version: 10
This is the query I run:
LOAD DATA LOCAL INFILE
LINES TERMINATED BY "\n"
= REGEXP_SUBSTR(@line, "^[^;:,]*"),
= REGEXP_SUBSTR(@line, "[^;:,]+$");
This is the server structure: email: varchar(255) utf8_bin password: varchar(255) utf8_bin
key_buffer = 64M
max_allowed_packet = 1M
sort_buffer_size = 5M
net_buffer_length = 8M
read_buffer_size = 5M
read_rnd_buffer_size = 5M
myisam_sort_buffer_size = 8M
log_error = "mysql_error.log"
innodb_buffer_pool_size = 2650M
innodb_additional_mem_pool_size = 64M
innodb_log_file_size = 2048M
innodb_log_buffer_size = 512M
bulk_insert_buffer_size = 2048M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
Log files do not report any errors while waiting. I waited more than 2 hours and then I stopped loading, and every time I encounter a file like that the server no longer responds. How can I solve this problem?