参考文档:
https://github.com/Percona-Lab/mysql_random_data_load
下载地址:
https://github.com/Percona-Lab/mysql_random_data_load/releases
tar -xvf mysql_random_data_load_0.1.12_Linux_x86_64.tar.gz
mv mysql_random_data_load /usr/local/mysql/bin/
创建测试表
CREATE DATABASE IF NOT EXISTS test;
CREATE TABLE `test`.`t3` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tcol01` tinyint(4) DEFAULT NULL,
`tcol02` smallint(6) DEFAULT NULL,
`tcol03` mediumint(9) DEFAULT NULL,
`tcol04` int(11) DEFAULT NULL,
`tcol05` bigint(20) DEFAULT NULL,
`tcol06` float DEFAULT NULL,
`tcol07` double DEFAULT NULL,
`tcol08` decimal(10,2) DEFAULT NULL,
`tcol09` date DEFAULT NULL,
`tcol10` datetime DEFAULT NULL,
<