Guten Abend Liste, bräuchte mal ein paar Meinungen zur Interpretation zweier mysql Benchmark ergebnisse. Leider sagt die Mysql Doku gerade zu diesem Thema nichts aus :/ Hier mal das Ergebnis eines ./run-all-tests.pl Benchmark DBD suite: 2.15 Date of test: 2008-10-14 14:15:10 Running tests on: Linux 2.6.22.5-31-default x86_64 Arguments: Comments: Limits from: Server version: MySQL 5.0.45 log Optimization: None Hardware: alter-table: Total time: 7 wallclock secs ( 0.02 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.02 CPU) ATIS: Total time: 4 wallclock secs ( 2.56 usr 0.19 sys + 0.00 cusr 0.00 csys = 2.75 CPU) big-tables: Total time: 7 wallclock secs ( 1.59 usr 0.22 sys + 0.00 cusr 0.00 csys = 1.81 CPU) connect: Total time: 64 wallclock secs (14.87 usr 9.53 sys + 0.00 cusr 0.00 csys = 24.40 CPU) create: Total time: 129 wallclock secs ( 1.24 usr 0.89 sys + 0.00 cusr 0.00 csys = 2.13 CPU) insert: Total time: 459 wallclock secs (151.70 usr 32.59 sys + 0.00 cusr 0.00 csys = 184.29 CPU) select: Total time: 43 wallclock secs (14.72 usr 1.28 sys + 0.00 cusr 0.00 csys = 16.00 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 4 wallclock secs ( 1.17 usr 0.27 sys + 0.00 cusr 0.00 csys = 1.44 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 3.00 0.00 0.00 0.00 100 alter_table_drop 3.00 0.00 0.00 0.00 91 connect 5.00 2.07 0.89 2.96 10000 connect+select_1_row 5.00 2.31 0.72 3.03 10000 connect+select_simple 4.00 2.17 0.63 2.80 10000 count 3.00 0.00 0.00 0.00 100 count_distinct 0.00 0.08 0.00 0.08 1000 count_distinct_2 0.00 0.06 0.02 0.08 1000 count_distinct_big 3.00 2.29 0.03 2.32 120 count_distinct_group 1.00 0.30 0.02 0.32 1000 count_distinct_group_on_key 0.00 0.09 0.01 0.10 1000 count_distinct_group_on_key_parts 0.00 0.30 0.01 0.31 1000 count_distinct_key_prefix 0.00 0.07 0.01 0.08 1000 count_group_on_key_parts 1.00 0.29 0.01 0.30 1000 count_on_key 9.00 3.01 0.39 3.40 50100 create+drop 39.00 0.33 0.27 0.60 10000 create_MANY_tables 39.00 0.27 0.16 0.43 10000 create_index 1.00 0.00 0.00 0.00 8 create_key+drop 47.00 0.48 0.24 0.72 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 12.00 0.00 0.00 0.00 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 12.00 0.00 0.00 0.00 128 delete_key 1.00 0.09 0.17 0.26 10000 delete_range 2.00 0.00 0.00 0.00 12 drop_index 0.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 1.00 0.08 0.08 0.16 10000 insert 31.00 3.16 3.42 6.58 350768 insert_duplicates 7.00 0.91 1.10 2.01 100000 insert_key 25.00 1.58 1.32 2.90 100000 insert_many_fields 3.00 0.06 0.03 0.09 2000 insert_select_1_key 1.00 0.00 0.00 0.00 1 insert_select_2_keys 1.00 0.00 0.00 0.00 1 min_max 2.00 0.00 0.00 0.00 60 min_max_on_key 8.00 5.11 0.72 5.83 85000 multiple_value_insert 1.00 0.12 0.01 0.13 100000 once_prepared_select 15.00 2.09 1.43 3.52 100000 order_by_big 8.00 6.71 0.13 6.84 10 order_by_big_key 8.00 6.84 0.16 7.00 10 order_by_big_key2 8.00 6.65 0.09 6.74 10 order_by_big_key_desc 8.00 6.69 0.11 6.80 10 order_by_big_key_diff 8.00 6.66 0.12 6.78 10 order_by_big_key_prefix 8.00 6.60 0.10 6.70 10 order_by_key2_diff 1.00 0.63 0.00 0.63 500 order_by_key_prefix 1.00 0.34 0.02 0.36 500 order_by_range 1.00 0.33 0.00 0.33 500 outer_join 1.00 0.00 0.00 0.00 10 outer_join_found 1.00 0.00 0.00 0.00 10 outer_join_not_found 1.00 0.00 0.00 0.00 500 outer_join_on_key 1.00 0.01 0.00 0.01 10 prepared_select 19.00 6.01 1.42 7.43 100000 select_1_row 10.00 1.24 1.20 2.44 100000 select_1_row_cache 5.00 1.20 1.36 2.56 100000 select_2_rows 12.00 1.31 1.16 2.47 100000 select_big 8.00 6.67 0.13 6.80 80 select_big_str 3.00 1.16 0.56 1.72 10000 select_cache 1.00 0.60 0.09 0.69 10000 select_cache2 23.00 0.56 0.06 0.62 10000 select_column+column 11.00 1.14 0.76 1.90 100000 select_diff_key 0.00 0.04 0.01 0.05 500 select_distinct 0.00 0.49 0.02 0.51 800 select_group 1.00 0.37 0.04 0.41 2911 select_group_when_MANY_tables 3.00 0.08 0.14 0.22 10000 select_join 0.00 0.15 0.01 0.16 100 select_key 34.00 13.19 2.87 16.06 200000 select_key2 35.00 13.48 2.86 16.34 200000 select_key2_return_key 34.00 12.91 2.98 15.89 200000 select_key2_return_prim 34.00 12.91 2.87 15.78 200000 select_key_prefix 34.00 13.41 2.82 16.23 200000 select_key_prefix_join 2.00 1.25 0.02 1.27 100 select_key_return_key 33.00 12.99 3.00 15.99 200000 select_many_fields 3.00 1.53 0.19 1.72 2000 select_range 4.00 2.65 0.01 2.66 410 select_range_key2 2.00 1.36 0.23 1.59 25010 select_range_prefix 2.00 1.47 0.23 1.70 25010 select_simple 5.00 1.27 1.09 2.36 100000 select_simple_cache 4.00 0.99 1.16 2.15 100000 select_simple_join 0.00 0.17 0.00 0.17 500 update_big 8.00 0.00 0.00 0.00 10 update_of_key 6.00 0.43 0.76 1.19 50000 update_of_key_big 5.00 0.00 0.00 0.00 501 update_of_primary_key_many_keys 5.00 0.02 0.00 0.02 256 update_with_key 28.00 2.40 3.36 5.76 300000 update_with_key_prefix 9.00 1.75 1.05 2.80 100000 wisc_benchmark 1.00 0.93 0.04 0.97 114 TOTALS 724.00 184.91 44.92 229.83 3425950 Das System kam mir etwas "langsam" vor, denn wenn der sql Server läuft und Anfragen bedient, habe ich in TOP einen relativ hohen "wa" Wert... Ich denke die Platten kommen mit der Zahl der kleinen IOs nicht zurecht. Allerdings habe ich aus diesen Gründen schon ein Raid-10 eingerichtet, da ich bei Raid-5 und den vielen kleinen operationen der SQL Datenbank zu hohe Schreibverluste habe... Ein Dateisystem Benchmark mit bonnie und einem 10GB File (auf ext3) zeigt mir zwar recht akzeptable Leistungen, aber eine 100%ige CPU Auslastung: Bonnie 1.4: File '/tmp/Bonnie.9657', size: 10485760000, volumes: 1 Writing with putc()... done: 51031 kB/s 86.4 %CPU Rewriting... done: 100534 kB/s 14.1 %CPU Writing intelligently... done: 105044 kB/s 25.1 %CPU Reading with getc()... done: 66998 kB/s 100.0 %CPU Reading intelligently... done: 2601187 kB/s 100.0 %CPU Seeker 1...Seeker 2...Seeker 3...start 'em...done...done...done... ---Sequential Output (nosync)--- ---Sequential Input-- --Rnd Seek- -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --04k (03)- Machine MB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU /sec %CPU server 1*10000 51031 86.4105044 25.1 100534 14.1 66998 1002601187 100 98000.8 108 Vielleicht springt ja jemandem was ins Auge oder eine Idee ins hirn :) thx Stefan -- Um die Liste abzubestellen, schicken Sie eine Mail an: opensuse-de+unsubscribe@opensuse.org Um eine Liste aller verfuegbaren Kommandos zu bekommen, schicken Sie eine Mail an: opensuse-de+help@opensuse.org