473,325 Members | 2,671 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Benchmark differences: Mac OS X - Linux

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" = @.
Jul 19 '05 #1
0 1430

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Duncan Lissett | last post by:
I'd appreciate any suggestions on how to make faster Python implementations of Richards benchmark. Perhaps there are obvious problems that can be corrected? http://www.lissett.com/ben/bench1.htm
6
by: Franco Fiorese | last post by:
Hi all, I am relatively new about Python benchmarks. After some experiments I found that Python on my PC Windows XP has a relevant higher performance than on Linux. The simple test using...
0
by: julio | last post by:
Hello Guys, AlphaServer EV6 processor 500mhz/1Gm memory with Linux mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye")); +----------------------------------------------+ |...
0
by: Jan Pieter Kunst | last post by:
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...
5
by: SARS | last post by:
Here's all the OSS Benchmarks run so far -- so far no Windos challengers... http://home.earthlink.net/~jabailo/OSS%20Benchmark.pdf The source is here: ...
3
by: Steve | last post by:
Hi, I'm currently looking a porting our Windows Codewarrior based C++ projects to MinGW and/or Visual Studio and I'm just wondering if there is a 'standard' suite of benchmark programs I can...
2
by: Matthijs van Waveren | last post by:
"Your opportunity to be a RECOGNIZED EXPERT in the HPC Community" The SPEC High Performance Group is seeking candidates for a benchmark suite based on Message Passing Interface (MPI)...
2
by: um | last post by:
When the POSIX pthreads library for w32 release 2-2-0 (http://sources.redhat.com/pthreads-win32/) is compiled with VC++6 then it compiles and passes all the benchmark tests in the subdirectory...
5
by: shawn.oda | last post by:
What are the diferences between ms visual c++ compiler and linux c++ compiler? Best regards, shawn.oda@bankarea.com http://www.poweroversoftware.com
2
by: Mike P | last post by:
Hi All, I'm trying to use the CSV module to read in some data and then use a hashable method (as there are millions of records) to find unique ids and push these out to another file, can...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.