Category

Development Platform
Home > SourceCode/Document > Database system > MySQL > View Code
RUN-mysql-Linux_2.2.14_my_SMP_i686
Package: mysql-3.23.35.tar.gz　[view]
Upload User: tsgydb
Upload Date: 2007-04-14
Package Size: 10674k
Code Size: 7k
Category:

MySQL

Development Platform:

Visual C++

RUN-mysql-Linux_2.2.14_my_SMP_i686：Code Content
  1. Benchmark DBD suite: 2.12
  2. Date of test:        2000-12-24 15:30:34
  3. Running tests on:    Linux 2.2.14-my-SMP i686
  4. Arguments:           
  5. Comments:            Intel Xeon, 2x550 Mhz, 1G ram, key_buffer=16M
  6. Limits from:         
  7. Server version:      MySQL 3.23.29a gamma
  9. ATIS: Total time: 44 wallclock secs ( 9.18 usr  4.06 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  10. alter-table: Total time: 468 wallclock secs ( 0.25 usr  0.12 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  11. big-tables: Total time: 31 wallclock secs ( 8.67 usr  6.87 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  12. connect: Total time: 79 wallclock secs (34.39 usr 17.84 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  13. create: Total time: 126 wallclock secs (10.09 usr  3.20 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  14. insert: Total time: 2227 wallclock secs (451.81 usr 170.75 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  15. select: Total time: 1379 wallclock secs (61.35 usr 18.95 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  16. wisconsin: Total time: 16 wallclock secs ( 3.25 usr  1.72 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  18. All 8 test executed successfully
  20. Totals per operation:
  21. Operation             seconds     usr     sys     cpu   tests
  22. alter_table_add                      263.00    0.10    0.05    0.00     992 
  23. alter_table_drop                     197.00    0.05    0.03    0.00     496 
  24. connect                               12.00    7.18    2.61    0.00   10000 
  25. connect+select_1_row                  15.00    7.75    3.29    0.00   10000 
  26. connect+select_simple                 14.00    7.39    3.61    0.00   10000 
  27. count                                 47.00    0.05    0.00    0.00     100 
  28. count_distinct                       119.00    0.66    0.17    0.00    2000 
  29. count_distinct_big                   111.00    7.48    5.86    0.00     120 
  30. count_distinct_group                  80.00    1.02    0.43    0.00    1000 
  31. count_distinct_group_on_key           60.00    0.40    0.08    0.00    1000 
  32. count_distinct_group_on_key_parts     81.00    0.79    0.41    0.00    1000 
  33. count_group_on_key_parts              54.00    1.00    0.47    0.00    1000 
  34. count_on_key                         559.00   17.07    3.00    0.00   50100 
  35. create+drop                           29.00    2.43    0.82    0.00   10000 
  36. create_MANY_tables                    29.00    2.27    0.46    0.00   10000 
  37. create_index                           4.00    0.00    0.00    0.00       8 
  38. create_key+drop                       40.00    3.97    0.87    0.00   10000 
  39. create_table                           0.00    0.00    0.00    0.00      31 
  40. delete_all                            20.00    0.00    0.00    0.00      12 
  41. delete_all_many_keys                 151.00    0.03    0.01    0.00       1 
  42. delete_big                             0.00    0.00    0.00    0.00       1 
  43. delete_big_many_keys                 151.00    0.03    0.01    0.00     128 
  44. delete_key                             4.00    0.56    0.45    0.00   10000 
  45. drop_index                             4.00    0.00    0.00    0.00       8 
  46. drop_table                             0.00    0.01    0.00    0.00      28 
  47. drop_table_when_MANY_tables           12.00    0.63    0.43    0.00   10000 
  48. insert                               131.00   22.93   14.02    0.00  350768 
  49. insert_duplicates                     24.00    3.18    3.05    0.00  100000 
  50. insert_key                           154.00   10.52    4.42    0.00  100000 
  51. insert_many_fields                     9.00    0.44    0.07    0.00    2000 
  52. insert_select_1_key                    7.00    0.00    0.00    0.00       1 
  53. insert_select_2_keys                   9.00    0.00    0.00    0.00       1 
  54. min_max                               32.00    0.01    0.00    0.00      60 
  55. min_max_on_key                       238.00   27.34    5.17    0.00   85000 
  56. multiple_value_insert                  9.00    1.88    0.06    0.00  100000 
  57. order_by_big                          52.00   22.29   15.95    0.00      10 
  58. order_by_big_key                      34.00   23.91   10.39    0.00      10 
  59. order_by_big_key2                     33.00   22.58   10.06    0.00      10 
  60. order_by_big_key_desc                 36.00   23.89   10.41    0.00      10 
  61. order_by_big_key_diff                 50.00   22.07   16.43    0.00      10 
  62. order_by_big_key_prefix               32.00   22.21   10.50    0.00      10 
  63. order_by_key2_diff                     5.00    1.12    0.07    0.00     500 
  64. order_by_key_prefix                    3.00    1.10    0.38    0.00     500 
  65. order_by_range                         5.00    1.14    0.41    0.00     500 
  66. outer_join                            72.00    0.00    0.00    0.00      10 
  67. outer_join_found                      67.00    0.00    0.01    0.00      10 
  68. outer_join_not_found                  50.00    0.00    0.00    0.00     500 
  69. outer_join_on_key                     57.00    0.01    0.00    0.00      10 
  70. select_1_row                           2.00    0.45    0.57    0.00   10000 
  71. select_2_rows                          3.00    0.59    0.61    0.00   10000 
  72. select_big                            62.00   32.48   15.99    0.00   10080 
  73. select_column+column                   3.00    0.58    0.68    0.00   10000 
  74. select_diff_key                      191.00    0.33    0.03    0.00     500 
  75. select_distinct                       11.00    1.84    0.70    0.00     800 
  76. select_group                          67.00    1.60    0.52    0.00    2911 
  77. select_group_when_MANY_tables         16.00    0.79    0.62    0.00   10000 
  78. select_join                            2.00    0.57    0.28    0.00     100 
  79. select_key                           126.00   68.35   14.42    0.00  200000 
  80. select_key2                          132.00   69.41   13.86    0.00  200000 
  81. select_key_prefix                    134.00   71.19   14.71    0.00  200000 
  82. select_key_prefix_join                13.00    4.13    1.96    0.00     100 
  83. select_many_fields                    22.00    8.22    6.80    0.00    2000 
  84. select_range                         194.00    9.08    3.79    0.00     410 
  85. select_range_key2                     18.00    6.36    1.64    0.00   25010 
  86. select_range_prefix                   20.00    6.82    1.38    0.00   25010 
  87. select_simple                          2.00    0.47    0.71    0.00   10000 
  88. select_simple_join                     2.00    0.68    0.19    0.00     500 
  89. update_big                            64.00    0.00    0.00    0.00      10 
  90. update_of_key                         23.00    2.80    2.29    0.00   50000 
  91. update_of_key_big                     33.00    0.11    0.03    0.00     501 
  92. update_of_primary_key_many_keys       65.00    0.02    0.01    0.00     256 
  93. update_with_key                      113.00   17.01   12.17    0.00  300000 
  94. update_with_key_prefix                32.00    5.68    4.36    0.00  100000 
  95. wisc_benchmark                         4.00    1.80    0.69    0.00     114 
  96. TOTALS                              4519.00  578.85  223.47    0.00 2046247