Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

20120814_sysbench_outputs

By: lolomin on Aug 14th, 2012  |  syntax: None  |  size: 7.59 KB  |  views: 51  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. root@djen:~/lolo# cat sysbench_cluster.sh
  2. #!/bin/bash
  3.  
  4. if [ "x$1" == "x" ]
  5. then
  6.         echo "You must specify the command to run : prepare / run / cleanup."
  7.         exit
  8. fi
  9.  
  10. sysbench --num-threads=32 --max-requests=10000 --test=oltp --oltp-table-size=1000000 --oltp-test-mode=complex --oltp-reconnect-mode=query --mysql-host=172.16.29.238 --mysql-user=cluster --mysql-password=blabla --mysql-port=3309 --oltp-skip-trx --mysql-table-engine=innodb $1
  11.  
  12. root@djen:~/lolo# ./sysbench_cluster.sh cleanup
  13. sysbench 0.4.12:  multi-threaded system evaluation benchmark
  14.  
  15. No DB drivers specified, using mysql
  16. Dropping table 'sbtest'...
  17. Done.
  18.  
  19. root@djen:~/lolo# ./sysbench_cluster.sh prepare
  20. sysbench 0.4.12:  multi-threaded system evaluation benchmark
  21.  
  22. No DB drivers specified, using mysql
  23. Creating table 'sbtest'...
  24. Creating 1000000 records in table 'sbtest'...
  25.  
  26. root@djen:~/lolo# ./sysbench_cluster.sh run
  27. sysbench 0.4.12:  multi-threaded system evaluation benchmark
  28.  
  29. No DB drivers specified, using mysql
  30. Running the test with following options:
  31. Number of threads: 32
  32.  
  33. Doing OLTP test.
  34. Running mixed OLTP test
  35. Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
  36. Skipping BEGIN/COMMIT
  37. Using auto_inc on the id column
  38. Maximum number of requests for OLTP test is limited to 10000
  39. Threads started!
  40. FATAL: unable to connect to MySQL server, aborting...
  41. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  42. FATAL: failed to connect to database server!
  43. FATAL: unable to connect to MySQL server, aborting...
  44. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  45. FATAL: failed to connect to database server!
  46. FATAL: unable to connect to MySQL server, aborting...
  47. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  48. FATAL: failed to connect to database server!
  49. FATAL: unable to connect to MySQL server, aborting...
  50. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  51. FATAL: failed to connect to database server!
  52. FATAL: unable to connect to MySQL server, aborting...
  53. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  54. FATAL: failed to connect to database server!
  55. FATAL: unable to connect to MySQL server, aborting...
  56. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  57. FATAL: failed to connect to database server!
  58. FATAL: unable to connect to MySQL server, aborting...
  59. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  60. FATAL: failed to connect to database server!
  61. FATAL: unable to connect to MySQL server, aborting...
  62. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  63. FATAL: failed to connect to database server!
  64. FATAL: unable to connect to MySQL server, aborting...
  65. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  66. FATAL: failed to connect to database server!
  67. FATAL: unable to connect to MySQL server, aborting...
  68. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  69. FATAL: failed to connect to database server!
  70. FATAL: unable to connect to MySQL server, aborting...
  71. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  72. FATAL: failed to connect to database server!
  73. FATAL: unable to connect to MySQL server, aborting...
  74. (last message repeated 1 times)
  75. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  76. FATAL: failed to connect to database server!
  77. FATAL: unable to connect to MySQL server, aborting...
  78. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  79. FATAL: failed to connect to database server!
  80. FATAL: unable to connect to MySQL server, aborting...
  81. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  82. FATAL: failed to connect to database server!
  83. FATAL: unable to connect to MySQL server, aborting...
  84. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  85. FATAL: failed to connect to database server!
  86. FATAL: unable to connect to MySQL server, aborting...
  87. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  88. FATAL: failed to connect to database server!
  89. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  90. FATAL: failed to connect to database server!
  91. FATAL: unable to connect to MySQL server, aborting...
  92. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  93. FATAL: failed to connect to database server!
  94. FATAL: unable to connect to MySQL server, aborting...
  95. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  96. FATAL: failed to connect to database server!
  97. FATAL: unable to connect to MySQL server, aborting...
  98. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  99. FATAL: failed to connect to database server!
  100. FATAL: unable to connect to MySQL server, aborting...
  101. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  102. FATAL: failed to connect to database server!
  103. FATAL: unable to connect to MySQL server, aborting...
  104. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  105. FATAL: failed to connect to database server!
  106. FATAL: unable to connect to MySQL server, aborting...
  107. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  108. FATAL: failed to connect to database server!
  109. FATAL: unable to connect to MySQL server, aborting...
  110. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  111. FATAL: failed to connect to database server!
  112. FATAL: unable to connect to MySQL server, aborting...
  113. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  114. FATAL: failed to connect to database server!
  115. FATAL: unable to connect to MySQL server, aborting...
  116. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  117. FATAL: failed to connect to database server!
  118. FATAL: unable to connect to MySQL server, aborting...
  119. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  120. FATAL: failed to connect to database server!
  121. FATAL: unable to connect to MySQL server, aborting...
  122. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  123. FATAL: failed to connect to database server!
  124. FATAL: unable to connect to MySQL server, aborting...
  125. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  126. FATAL: failed to connect to database server!
  127. FATAL: unable to connect to MySQL server, aborting...
  128. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  129. FATAL: failed to connect to database server!
  130. FATAL: unable to connect to MySQL server, aborting...
  131. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  132. FATAL: failed to connect to database server!
  133. FATAL: unable to connect to MySQL server, aborting...
  134. FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
  135. FATAL: failed to connect to database server!
  136. Done.
  137.  
  138. OLTP test statistics:
  139.     queries performed:
  140.         read:                            24556
  141.         write:                           8770
  142.         other:                           28064
  143.         total:                           61390
  144.     transactions:                        1754   (49.26 per sec.)
  145.     deadlocks:                           0      (0.00 per sec.)
  146.     read/write requests:                 33326  (935.86 per sec.)
  147.     other operations:                    28064  (788.09 per sec.)
  148. ./sysbench_cluster.sh: line 9: 11905 Erreur de segmentation  sysbench --num-threads=32 --max-requests=10000 --test=oltp --oltp-table-size=1000000 --oltp-test-mode=complex --oltp-reconnect-mode=query --mysql-host=172.16.29.238 --mysql-user=cluster --mysql-password=blabla --mysql-port=3309 --oltp-skip-trx --mysql-table-engine=innodb $1