Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua
  2. --oltp-test-mode=complex --oltp-table-size=1000000
  3. --mysql-db=mydb --mysql-user=root --mysql-password=mypassword prepare
  4.  
  5. sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua
  6. --oltp-test-mode=complex --oltp-table-size=1000000 --oltp-read-only=off
  7. --num-threads=6 --max-time=60 --max-requests=0
  8. --mysql-db=mydb --mysql-user=root --mysql-password=mypassword run
  9.  
  10. # hdparm -Tt /dev/sda
  11.  
  12. /dev/sda:
  13. Timing cached reads: 27166 MB in 2.00 seconds = 13599.63 MB/sec
  14. Timing buffered disk reads: 1488 MB in 3.00 seconds = 495.64 MB/sec
  15.  
  16. # dd if=/dev/zero of=/tmp/output bs=8k count=10k; rm -f /tmp/output
  17. 10240+0 records in
  18. 10240+0 records out
  19. 83886080 bytes (84 MB) copied, 0.0517404 s, 1.6 GB/s
  20.  
  21. transactions: 101001 (1683.29 per sec.)
  22.  
  23. transactions: 10501 (174.95 per sec.)
  24.  
  25. transactions: 11280 (187.86 per sec.)
  26.  
  27. transactions: 10779 (179.55 per sec.)
  28.  
  29. transactions: 10595 (176.48 per sec.)
  30.  
  31. transactions: 73683 (1228.00 per sec.)
  32.  
  33. transactions: 703 (11.65 per sec.)
  34.  
  35. transactions: 643 (10.67 per sec.)
  36.  
  37. transactions: 652 (10.80 per sec.)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement