I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac
OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0.
Both installations used the same my.cnf file.
The results are comparable in all benchmarks except one: the 'insert'.
In that one, the Mac is more than twice as slow. Below are the benchmark
results for boch machines, and the my.cnf I used.
I was wondering if there is something I can do, configuration-wise, to
do something about those very slow 'inserts' (and 'updates') on the Mac?
Thanks in advance for any insight,
Jan Pieter Kunst
Benchmark results:
Dual 1GHz G4/Mac OS X Client 10.2/MySQL 3.23.57:
===============================================
alter-table: Total time: 186 wallclock secs
ATIS: Total time: 37 wallclock secs
big-tables: Total time: 78 wallclock secs
connect: Total time: 57 wallclock secs
create: Total time: 118 wallclock secs
insert: Total time: 6811 wallclock secs
select: Total time: 1340 wallclock secs
wisconsin: Total time: 21 wallclock secs
.... snip ...
insert 137.00
insert_duplicates 23.00
insert_key 3099.00
insert_many_fields 10.00
insert_select_1_key 4.00
insert_select_2_keys 6.00
.... snip ...
update_big 93.00
update_of_key 180.00
update_of_key_big 29.00
update_of_primary_key_many_keys 478.00
update_with_key 228.00
update_with_key_prefix 22.00
800 Mhz Intel/SuSE Linux 8.0/MySQL 3.23.57:
===========================================
alter-table: Total time: 230 wallclock secs
ATIS: Total time: 36 wallclock secs
big-tables: Total time: 32 wallclock secs
connect: Total time: 89 wallclock secs
create: Total time: 90 wallclock secs
insert: Total time: 2895 wallclock secs
select: Total time: 1502 wallclock secs
wisconsin: Total time: 20 wallclock secs
.... snip ....
insert 190.00
insert_duplicates 39.00
insert_key 140.00
insert_many_fields 10.00
insert_select_1_key 5.00
insert_select_2_keys 7.00
.... snip ....
update_big 33.00
update_of_key 35.00
update_of_key_big 22.00
update_of_primary_key_many_keys 28.00
update_with_key 178.00
update_with_key_prefix 44.00
These are hopefully relevant parts of the my.cnf I used:
[mysqld]
skip-locking
set-variable = key_buffer=64M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=4M
set-variable = net_buffer_length=8K
set-variable = record_buffer=1M
set-variable = thread_cache=8
set-variable = myisam_sort_buffer_size=8M
log-bin
server-id = 1
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.