mysqlstress - stress mysql server
mysqlstress README
to install see INSTALL
Usage: mysqlstress [OPTIONS]
-h, --hostname Connect to host. (default: localhost)
-u, --username User to log in. (default: root)
-p, --password Password to log in. (default: none)
-d, --database Database You want to connect. (default: mysql)
-S, --socket Connet to unix socket (default: NULL)
-P, --port Port number to use for connection. (default: 3306)
-n, --number Number of SQL statements per connection (default: 5000)
-s, --statement SQL statement you want to exec during stress test. (default "SELECT * FROM user")
-t, --threads Number of threads You want (default: 5000)
-i, --info Show version of MySQL Server
-c, --close Close MySQL connections (default: no). See README!
-q, --quiet No output, just work (default: no)
-V, --version Output version information and exit.
-H, --help Output this message and exit.
all options are logical, the only one is the -c or --close.
if you really want to stress your mysql don't close mysql connections.
See ChangeLog
enjoy
Go back