Re: mysql performance on freebsd 7

2008-05-21 Thread t.pajor
> May I ask whether you are using innodb or myisam? both on freebsd and Linux. > And what filesystem are you using for mysql's data files? UFS, ZFS or anything > else? MySQL engine used is MEMORY, filesystem is ufs, but it's not relevant. > IIRC there's some hack to reduce gettimeofday()'s preci

mysql performance on freebsd 7

2008-05-21 Thread t.pajor
Hello, I'm using mysql 5.1.24-rc in 5 separate jails. Question: 10 clients are pushing queries (10 separate machines). 2 clients to 1 mysql daemon. One client is performing an update on param_stat_short_level_1_0, second on param_stat_short_level_1_1. Each client needs to push 15 queries