Re: MySQL and Hyperthreading

2006-03-02 Thread Hiro Yoshioka
Hi Atle, We are using Asianux 2.0 (RHEL 4 compatible, linux kernel 2.6.9) MySQL is the latest one. 5.0.x Thanks in advance, Hiro From: Atle Veka <[EMAIL PROTECTED]> Subject: Re: MySQL and Hyperthreading Date: Thu, 2 Mar 2006 10:12:09 -0800 (PST) Message-ID: <[EMAIL PROTECTED]> &

Re: MySQL and Hyperthreading

2006-03-02 Thread Atle Veka
Hi Hiro, we have noticed severe performance loss with HT enabled under FreeBSD but not with MySQL. However, we could be having problems with MySQL as well without knowing as we haven't done any testing as it is operating fine. What operating system are you running? We now disable HT on all servers

MySQL and Hyperthreading

2006-03-01 Thread Hiro Yoshioka
Hi, We found a severe performance degradation when Hyperthreading is on and thread_concurrency=20. We are using OSDL DBT-1 as the benchmark and got about 200 to 250 BT (bogotransactions per second) HT is OFF normal case but 30 to 50 BT on HT is ON. innodb_thread_concurrency=20 So we did profil