Difference between revisions of "Internet Offline: SQL - Rpi"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) (Created page with " mysqlslap -v -h localhost -u root -p123456 --auto-generate-sql mysqlslap -vvv -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-quer...") |
Onnowpurbo (talk | contribs) |
||
| Line 1: | Line 1: | ||
| + | mysqlslap tidak ada di raspberrypi, jadi agak susah untuk melakukan benchmark untuk MySQL. | ||
mysqlslap -v -h localhost -u root -p123456 --auto-generate-sql | mysqlslap -v -h localhost -u root -p123456 --auto-generate-sql | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
mysqlslap -vvv -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1 | mysqlslap -vvv -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000 | mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000 --iterations=5 | mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000 --iterations=5 | ||
| + | mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=innodb | ||
| + | mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=myisam | ||
| − | |||
| + | ==Pranala Menarik== | ||
| − | + | * [[Internet Offline]] | |
Latest revision as of 09:42, 18 December 2018
mysqlslap tidak ada di raspberrypi, jadi agak susah untuk melakukan benchmark untuk MySQL.
mysqlslap -v -h localhost -u root -p123456 --auto-generate-sql
mysqlslap -vvv -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1 mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000 --iterations=5
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=innodb
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=myisam