安装

• http://dev.mysql.com/downloads/mysql/
• https://zhuanlan.zhihu.com/p/87069388
• 下载mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz到/usr/local/

• tar -zxvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz -C /usr/local

  文件目录

• show variables like ‘%dir%’;

配置

配置文件：/etc/my.cnf

修改字符集

• show variables like ‘character%’;

将csv文件中的数据导入相应的表中

导入

• load data infile ‘/usr/local/mysql/data/csv/test.csv’ into table test fields terminated by ‘,’ enclosed by ‘“‘ lines terminated by ‘\n’ ignore 1 rows;
• user_action：21.75s，共7317882条数据
• select count(*) from user_action;1.89s
• select * from user_action where userid=250236;2.44s
• select * from user_action where userid=8;2.39s

创建userid索引

• select * from user_action where userid=250236;0.01s

  运行sql文件

  https://blog.csdn.net/cx136295988/article/details/74188447