Rilson Nascimento
Guest
|
 Posted: Tue Oct 10, 2006 3:00 am Post subject: RES: MySQL Performance Tuning |
 |
|
Hi Toasty,
Thanks for your reply, and sorry for delaying to answer you.
Please, see comments inline.
Best,
-Rilson
_____
De: Toa Sty [mailto:toastytoastytoasty (AT) gmail (DOT) com]
Enviada em: Mittwoch, 4. Oktober 2006 06:02
Para: Rilson Nascimento
Cc: benchmarks (AT) lists (DOT) mysql.com; Equipe TPC
Assunto: Re: MySQL Performance Tuning
Hi Rilson,
I saw your post on the mysql performance forum last week but haven't run the DBT benchmarks so am not sure what to suggest really.
I suppose it would be useful to see 'iostat -x' output or similar - can you tell whether your IOWAIT is a result disk seeking? It usually is 
If so, and if you're using InnoDB (I assume you are), then you might want to look at the innodb_flush_log_at_trx_commit setting if you've not already.
See HYPERLINK "http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html"http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html for more info.
| Quote: | I’m using 0 (zero) for this parameter. I understand that this value is the best for performance, and bad for ACID.
|
Alternatvely Peter Zaitsev responded to my post here:
HYPERLINK "http://forums.mysql.com/read.php?24,100894,100894#msg-100894"http://forums.mysql.com/read.php?24,100894,100894#msg-100894
with some pretty useful comments regarding configuring InnoDB for good performance, and he has a bunch more great stuff on his site at HYPERLINK "http://mysqlperformanceblog.com"mysqlperformanceblog.com
It might be worth looking at that as a starting point to see if your setup/config is as good as it could be.
| Quote: | I have already downloaded a couple of presentations of Peter Zaitsev, which are really good. I’m trying to apply some of the tips
Thanks for pinpointing the sites.
I’m attaching the my.cnf file for your review.
|
Sorry if you know all this already :)
Good luck,
Toasty
( PS There seems to be very little traffic on the mysql benchmark list - the forum seems to be more active...)
On 03/10/06, Rilson Nascimento <HYPERLINK "mailto:rilson (AT) itautec (DOT) cin.ufpe.br"rilson (AT) itautec (DOT) cin.ufpe.br> wrote:
Hi there,
I thought you guys could help me with a performance problem I'm experiencing with MySQL. Please, let me explain very briefly.
The problem is: high cpu i/o wait during a performance run using a MySQL database engine. Please, see system resources graphs in HYPERLINK " HYPERLINK "http://www.cin.ufpe.br/~ron2/plots.htm"http://www.cin.ufpe.br/~ron2/plots.htm"HYPERLINK "http://www.cin.ufpe.br/~ron2/plots.htm"http://www.cin.ufpe.br/~ron2/plots.htm
depicting cpu, i/o, memory, context switches and interrupts usage. (this link is from my personal page at the university)
I'm using OSDL DBT-2 workload to stress a MySQL database. I'm very used to run this workload on different systems without problems, this is the first time I'm getting so high cpu i/o wait. The i/o subsystem is well equipped: 28 SCSI 15k rpm disks in hardware raid-0 (two storages), where the database and log are located. These storages are connected to an external i/o controller, which also has good performance (LSI logic 4 channels). The system has 4 GB RAM and one 3.0 GHz Xeon CPU 2MB cache with HT enabled.
Thank you for your time and consideration,
-Rilson Nascimento
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.12.12/462 - Release Date: 03.10.2006
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.13.0/465 - Release Date: 06.10.2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.13.1/466 - Release Date: 07.10.2006 |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
