在linux:mysqlslap测试

[root@dbtest ~]# mysqlslap --defaults-file=/etc/my.cnf  --concurrency=2000 --iterations=4 --create-schema=gamedb --query='/home/test_login.sql' --number-of-queries=20000 -uroot -proot!


mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)

mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)

mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)

mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)

mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)


linux上连接过多


[root@dbtest ~]# vim /etc/security/limits.conf  添加

root  hard  nofile  16384
root  soft   nofile  16384


增加linux上打开文件数