maria-developers team mailing list archive

[erkan yanar <erkan.yanar@xxxxxxxxxxxxx>]

Moin, 
I did some tmp-table tests. As it is told MariaDB is faster on tmp-tables because of the Aria-Engine.

Therefore Ive got 3 Severs running:
onyx:/data/dbod # for i in 6051  6053  6060; do mysql   -u erkan -h 10.255.128.4  -P $i -e 'select version()'; done
+------------+
| version()  |
+------------+
| 5.5.12-log |
+------------+
+-------------------+
| version()         |
+-------------------+
| 5.2.6-MariaDB-log |
+-------------------+
+------------+
| version()  |
+------------+
| 5.1.57-log |

key_buffer_size is 16MB. For MariaDB there is also:
mysql> show global variables like 'aria_pagecache_buffer_size';
+----------------------------+----------+
| Variable_name              | Value    |
+----------------------------+----------+
| aria_pagecache_buffer_size | 16777216 |
+----------------------------+----------+

To provoke tmp-tables I did:
onyx:/data/dbod # for i in 6051  6053  6060; do mysql   -u erkan -h 10.255.128.4  -P $i -e 'show global variables like "tmp_table_size"'; done
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| tmp_table_size | 1024  |
+----------------+-------+
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| tmp_table_size | 1024  |
+----------------+-------+
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| tmp_table_size | 1024  |
+----------------+-------+

We got two tables:
mysql> desc sort_id;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql> desc sort_1;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | YES  |     | NULL    |       |
| tea   | text    | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)

With 10000 Rows each.

Tests:
onyx:/var/tmp # for i in 6051 6053 6060; do mysqlslap -u erkan -P $i  -h 10.255.128.4 --create-schema=sbtest -q "SELECT * from sbtest.sort_1 group  by id;" --number-of-queries=20 -i 3; done
Benchmark [[5.5.12]]
        Average number of seconds to run all queries: 1.803 seconds
        Minimum number of seconds to run all queries: 1.791 seconds
        Maximum number of seconds to run all queries: 1.826 seconds
        Number of clients running queries: 1
        Average number of queries per client: 20

Benchmark [[MariaDB]]
        Average number of seconds to run all queries: 5.547 seconds
        Minimum number of seconds to run all queries: 5.542 seconds
        Maximum number of seconds to run all queries: 5.556 seconds
        Number of clients running queries: 1
        Average number of queries per client: 20

Benchmark [[5.1.57]]
        Average number of seconds to run all queries: 1.605 seconds
        Minimum number of seconds to run all queries: 1.603 seconds
        Maximum number of seconds to run all queries: 1.606 seconds
        Number of clients running queries: 1
        Average number of queries per client: 20

onyx:/var/tmp # for i in 6051 6053 6060; do mysqlslap -u erkan -P $i  -h 10.255.128.4 --create-schema=sbtest -q "SELECT * from sbtest.sort_id group  by id;" --number-of-queries=20 -i 3; done
Benchmark [[5.5.12]]
        Average number of seconds to run all queries: 1.146 seconds
        Minimum number of seconds to run all queries: 1.135 seconds
        Maximum number of seconds to run all queries: 1.170 seconds
        Number of clients running queries: 1
        Average number of queries per client: 20

Benchmark  [[MariaDB]]
        Average number of seconds to run all queries: 4.359 seconds
        Minimum number of seconds to run all queries: 4.352 seconds
        Maximum number of seconds to run all queries: 4.366 seconds
        Number of clients running queries: 1
        Average number of queries per client: 20

Benchmark [[5.1.57]]
        Average number of seconds to run all queries: 1.049 seconds
        Minimum number of seconds to run all queries: 1.032 seconds
        Maximum number of seconds to run all queries: 1.068 seconds
        Number of clients running queries: 1
        Average number of queries per client: 20


So MariaDb doesn't perform in this test. So I wonder I did something wrong ...

Regards
Erkan


-- 
über den grenzen muß die freiheit wohl wolkenlos sein