MySQL Forums
Forum List  »  Performance

Something awfull with latest mysql on latest FreeBSD
Posted by: Aga Aga
Date: October 22, 2009 10:17AM


I have tested myisam tables performance with multi threaded sysbench benchmark on various last versions of mysql and freebsd and I've got very weird figures.

Machine is dual quad-core Xeon, sysbench most options at default for freebsd port.
Number of threads: 1,2,4,6,8,12,16
This was the last "good" config -- freebsd 7.0 + mysql 5.0.81
Tps was: 437,620,580,584,600,604,602.

All other combinations I've tried and these are freebsd 7.1 and 7.2 (with ULE and BSD schedulers) plus mysql 5.0.81 and 5.1.34 (builded with or without mutexes) ended in a pattern like this: 415,587,701,322,224,166,149. Speedup to the 4 threads and then fast decline.
For comparison performance for innodb in this conditions was: 392,718,1293,1580,1807,1698,1678.

Unfortunately we are forced to use myisam and heavy multithreading as we are using search for polygon intersection against pretty big table filled with polys for our application and this is the most costly operation.

So maybe? Anyone?

Options: ReplyQuote

Written By
Something awfull with latest mysql on latest FreeBSD
October 22, 2009 10:17AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.