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 both 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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
