[Mysqlfs-general] mysqlfs tests and timings

[Smart W. G. F. W. <f.w...@sm...>]

hi all,


i have done the following setup:

server1: amd athlon 64 x2, 2gb ram, 2x250gb hdd software raid1
server2: intel p4 1.8ghz, 256mb ram, 1x20gb ide disk

the servers are connected via 100mbit, but with async routing over 7 
hops with about 10ms latency.

i have mounted a mysqlfs with ndb-cluster and put my website on it 
(www2.smart-weblications.de is now dns-round-robin with mysqlfs 
underneath), to benchmark the performance:

http://www2.smart-weblications.de/mysqlfs-strace.txt

it takes about 6-8 seconds to render the page - most of the time the 
system waits on lstat64() (which is query_inode_full() in our case...)

i also copied files from and to the mysqlfs mountpoint:

time cp mysqlfs-strace.txt /tmp/foo

real    0m0.394s
user    0m0.002s
sys     0m0.001s

time cp /tmp/strace4 mysqlfs-strace.txt

real    0m5.677s
user    0m0.001s
sys     0m0.002s

which means that reading from the fs is quite fast (approx. 700kb/sek), 
writing is awful slow (approx. 10kb/sek)...

http://www2.smart-weblications.de/mysqlfs-strace-write.txt

so somehow we should cache write()

-- 

Mit freundlichen Grüßen,

Florian Wiessner

Smart Weblications GmbH
Martinsberger Str. 1
D-95119 Naila

fon.: +49 700 762 789 32 - 0,12 EUR/Min*
fax.: +49 700 762 789 32 - 0,12 EUR/Min*
24/7: +49 900 311 886 00 - 1,99 EUR/Min*
http://www.smart-weblications.de

--
Sitz der Gesellschaft: Naila
Geschäftsführer: Florian Wiessner
HRB-Nr.: HRB 3840 Amtsgericht Hof
*aus dem dt. Festnetz, ggf. abweichende Preise aus dem Mobilfunknetz