Re: 6.2 Stable + Mysql 5.0 poor performance

2007-05-14 Thread Steven Hartland
- Original Message - From: "Volodymyr Kostyrko" <[EMAIL PROTECTED]> I`ll be very thankful if someone can give me any ideas:) Try looking at hard drive usage. Totally idle during the test ( all in cache ) This e.mail is private and co

Re: 6.2 Stable + Mysql 5.0 poor performance

2007-05-14 Thread Volodymyr Kostyrko
ivo tasev wrote: Hi all, i have machine with 2 x Quad Core Xeon cpu`s 2G ram and 4 3ware disks in raid10. There is 6.2 Stable on it and mysql 5.0 from the ports. The mysql is installed with the following build options: WITH_XCHARSET=all WITH_OPENSSL=yes BUILD_OPTIMIZED=yes WITH_ARCHIVE=yes W

Re: 6.2 Stable + Mysql 5.0 poor performance

2007-05-14 Thread Cheffo
Alexandr wrote: Do you need more info? I think you should look at this http://people.freebsd.org/~kris/scaling/mysql.html What exactly you suggest ? :) Increasing thread_concurrency from 8 to 16 brings me worst results (I have only 4 cores not 8, and this is supposed to be CPUs*2 ) Or I

Re: 6.2 Stable + Mysql 5.0 poor performance

2007-05-14 Thread Steven Hartland
- Original Message - From: "Cheffo" <[EMAIL PROTECTED]> CPU: Intel(R) Xeon(R) CPU5130 @ 2.00GHz (2002.99-MHz K8-class CPU) avail memory = 8265285632 (7882 MB) FreeBSD/SMP: Multiprocessor System Detected: 4 CPUs da0 at arcmsr0 bus 0 target 0 lun 0 da0: Fixed Direct Access SCS

Re: 6.2 Stable + Mysql 5.0 poor performance

2007-05-14 Thread Cheffo
Hello, Michael K. Smith - Adhost wrote: Hello Taseff: -Original Message- From: [EMAIL PROTECTED] [mailto:owner-freebsd- [EMAIL PROTECTED] On Behalf Of ivo tasev Sent: Friday, May 11, 2007 2:02 AM To: freebsd-performance@freebsd.org Subject: 6.2 Stable + Mysql 5.0 poor performance Hi

RE: 6.2 Stable + Mysql 5.0 poor performance

2007-05-11 Thread Michael K. Smith - Adhost
Hello Taseff: > -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-freebsd- > [EMAIL PROTECTED] On Behalf Of ivo tasev > Sent: Friday, May 11, 2007 2:02 AM > To: freebsd-performance@freebsd.org > Subject: 6.2 Stable + Mysql 5.0 poor performance > > Hi all, > i have machine with 2