Internet Offline: SQL - Asus minipc

From OnnoWiki
Jump to: navigation, search
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


Pranala Menarik