diff options
| author | unknown <monty@donna.mysql.fi> | 2001-03-11 21:20:15 +0200 |
|---|---|---|
| committer | unknown <monty@donna.mysql.fi> | 2001-03-11 21:20:15 +0200 |
| commit | 97acb7b3d17dc60f6b879044aa53b7f422f553c2 (patch) | |
| tree | 3ffab1dce3f9b12f0d98de2289a2022d1e7f3327 /sql-bench/TODO | |
| parent | 74ea7333032ebc1d396f1939fd5a84c7a6ecc50c (diff) | |
| download | mariadb-git-97acb7b3d17dc60f6b879044aa53b7f422f553c2.tar.gz | |
Added new tests to benchmark suite
Docs/manual.texi:
Updated some typos in the innobase section
client/mysql.cc:
Added print of field types (for debugging)
client/mysqladmin.c:
Added timeout for shutdown
mysql-test/mysql-test-run.sh:
Use timeout for shutdown
sql-bench/test-select.sh:
Added test of query cache and new tests for count(distinct)
sql/ha_myisam.cc:
Don't give warnings for RESTORE TABLE
sql/mysqld.cc:
Added printing of innobase options
sql/sql_lex.cc:
Fixed possible bug when OEM
sql/sql_table.cc:
cleanup
Diffstat (limited to 'sql-bench/TODO')
| -rw-r--r-- | sql-bench/TODO | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql-bench/TODO b/sql-bench/TODO new file mode 100644 index 00000000000..8a103e89199 --- /dev/null +++ b/sql-bench/TODO @@ -0,0 +1,21 @@ +When comparing with ms-sql: + +Check how to get MySQL faster mysql ms-sql + +count_distinct (2000) | 89.00| 39.00| +count_distinct_big (120) | 324.00| 121.00| +count_distinct_group (1000) | 158.00| 107.00| +count_distinct_group_on_key (1000) | 49.00| 17.00| +count_distinct_group_on_key_parts (1| 157.00| 108.00| +order_by_big (10) | 197.00| 89.00| +order_by_big_key (10) | 170.00| 82.00| +order_by_big_key2 (10) | 163.00| 73.00| +order_by_big_key_desc (10) | 172.00| 84.00| +order_by_big_key_diff (10) | 193.00| 89.00| +order_by_big_key_prefix (10) | 165.00| 72.00| + + +Why is the following slow on NT: + NT Linux +update_of_primary_key_many_keys (256| 560.00| 65.00| + |