Monday, January 16, 2012

[Level 3] Benchmark in MySQL

#!/usr/bin/bash
#mysqlslap -a -c100 i10 -u root -p --engine=InnoDB,MyISAM,MEMORY,ARCHIVE
mysqlslap -a --only-print

## ref.@@pseudo_thread_id to get different values of thread.
# mysqlslap --create="CREATE TABLE A (a int);INSERT INTO A values (@@pseudo_thread_id)"
# --query="SELECT * FROM A" --concurrency=50 --iterations=200
Wish this helps.
regards,
Stanley Huang