Internet Offline: SQL - Asus minipc
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
mysqlslap -v -h localhost -u root -p123456 --auto-generate-sql Benchmark Average number of seconds to run all queries: 0.435 seconds Minimum number of seconds to run all queries: 0.435 seconds Maximum number of seconds to run all queries: 0.435 seconds Number of clients running queries: 1 Average number of queries per client: 0
mysqlslap -vvv -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1 Benchmark Average number of seconds to run all queries: 1.812 seconds Minimum number of seconds to run all queries: 1.812 seconds Maximum number of seconds to run all queries: 1.812 seconds Number of clients running queries: 100 Average number of queries per client: 0
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000 Benchmark Average number of seconds to run all queries: 27.501 seconds Minimum number of seconds to run all queries: 27.501 seconds Maximum number of seconds to run all queries: 27.501 seconds Number of clients running queries: 100 Average number of queries per client: 100
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000 --iterations=5 Benchmark Average number of seconds to run all queries: 29.830 seconds Minimum number of seconds to run all queries: 28.134 seconds Maximum number of seconds to run all queries: 32.361 seconds Number of clients running queries: 100 Average number of queries per client: 100
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=innodb Benchmark Running for engine innodb Average number of seconds to run all queries: 2.262 seconds Minimum number of seconds to run all queries: 2.262 seconds Maximum number of seconds to run all queries: 2.262 seconds Number of clients running queries: 100 Average number of queries per client: 10
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=myisam Benchmark Running for engine myisam Average number of seconds to run all queries: 0.368 seconds Minimum number of seconds to run all queries: 0.368 seconds Maximum number of seconds to run all queries: 0.368 seconds Number of clients running queries: 100 Average number of queries per client: 10