Hi!

It looks like the latest Innodb has significant regression for DDL operations, but... other operations are showing decent gain (though none of the DML/READ changes seem to be affecting medium/high concurrency performance).

Anyone else have an interpretation?

Cheers,
   -Brian


On Oct 16, 2009, at 7:16 AM, orisndriz05 wrote:

staging-1182    alter_table_add 13.00   0.04    0.02    0.06
staging-1183    alter_table_add 22.00   0.02    0.00    0.02

--

staging-1182    alter_table_drop        12.00   0.01    0.00    0.01
staging-1183    alter_table_drop        20.00   0.00    0.00    0.00

--

staging-1182    connect+select_1_row    2.00    1.27    0.51    1.78
staging-1183    connect+select_1_row    2.00    1.04    0.67    1.71

++

staging-1182    delete_all_many_keys    999.99  0.01    0.01    0.02
staging-1183    delete_all_many_keys    337.00  0.01    0.00    0.01

++

staging-1182    delete_big_many_keys    999.99  0.01    0.01    0.02
staging-1183    delete_big_many_keys    337.00  0.01    0.00    0.01
staging-1184    delete_big_many_keys    308.00  0.04    0.01    0.05

++

staging-1182    insert_key      517.00  5.39    2.06    7.45
staging-1183    insert_key      330.00  3.98    1.64    5.62

++

staging-1182    update_of_key_big       43.00   0.00    0.02    0.02
staging-1183    update_of_key_big       18.00   0.02    0.00    0.02

++

staging-1182    update_of_primary_key_many_keys 999.99  0.03    0.02    0.05
staging-1183    update_of_primary_key_many_keys 884.00  0.02    0.01    0.03

++



_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to