4
votes
2answers
777 views

Import a 260GB csv file into MySQL

I have a really big csv ~260GB and I want to import it into MySQL. I use the following mysql script in MacOS DROP TABLE IF EXISTS tmp_catpath_5; create table tmp_catpath_5( a1 ...
3
votes
2answers
482 views

Best approach to design this MySQL big database

I'm planing to design a database that contains only 2 tables (stats1 and stats2), but, this tables will contain rows going to 40 000 000 records! all the records will be "positive/unsigned" integers. ...