MySQL 生成百万测试数据-蒲公英云

MySQL 生成百万测试数据

叁歲伎倆 2024-04-18 09:05 151阅读 0赞

利用MySQL官方提供的测试库：test_db（链接）来作为测试数据：

1、我这里是docker容器中安装的MySQL5.7，需要进入MySQL容器当中，并将容器外的/usr/local/employees_db下的测试库文件夹中所有文件拷贝到MySQL容器的/opt目录下；

[root@localhost usr]# docker ps -a
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS                     PORTS                               NAMES
05236bb062ee        mysql:5.7           "docker-entrypoint.s…"   5 minutes ago       Exited (1) 5 minutes ago                                       great_gould
aaebad189b9e        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7005
85c7ea6a780a        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7004
c3739b28b97f        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7003
c8175f6b9e53        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7002
d48017b48f0a        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7001
1de8d0866fff        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7000
0b9283e34495        mysql:5.7           "docker-entrypoint.s…"   5 months ago        Up 3 minutes               0.0.0.0:3306->3306/tcp, 33060/tcp   mysql5.7
[root@localhost usr]# docker exec -it 0b9283e34495 /bin/bash
root@0b9283e34495:/# ls
bin  boot  dev  docker-entrypoint-initdb.d  entrypoint.sh  etc  home  lib  lib64  media  mnt  opt  proc  root  run  sbin  srv  sys  tmp  usr  var
root@0b9283e34495:/# cd /opt
root@0b9283e34495:/opt# ls
root@0b9283e34495:/opt# exit;
exit
[root@localhost usr]# docker cp /usr/local/employees_db/ 0b9283e34495:/opt
[root@localhost usr]# docker exec -it 0b9283e34495 /bin/bash
root@0b9283e34495:/# cd /opt
root@0b9283e34495:/opt# ls
employees_db

2、利用mysql -uroot -p123456 < employees.sql 命令导入。

账号密码自行根据自己需要更改。

root@0b9283e34495:/opt# cd employees_db/
root@0b9283e34495:/opt/employees_db# ls
Changelog      employees_partitioned.sql   load_departments.dump   load_employees.dump  objects.sql
README         employees_partitioned2.sql  load_dept_emp.dump      load_salaries.dump   test_employees_md5.sql
employees.sql  employees_partitioned3.sql  load_dept_manager.dump  load_titles.dump     test_employees_sha.sql
root@0b9283e34495:/opt/employees_db# mysql -uroot -p123456 < employees.sql
--------
--------
--------（等待....）