Please just select the choice(s) you want to highlight. I'm looking for your personal choice as the best performing in your experience (please only people who have used this in production and have actually thrown a load at it)
What version of MySQL?
- MySQL 3.x
- MySQL 4.0
- MySQL 4.1
- MySQL 5.0
What OS?
- Linux - which distro? What kernel version?
- FreeBSD 4.x
- FreeBSD 5.x
- FreeBSD 6.x
Which I/O scheduler:
- anticipatory (Linux)
- deadline (Linux)
- CFQ (Linux)
- SCHED_ULE (FreeBSD)
- SCHED_4BSD (FreeBSD)
What FS?
- XFS
- JFS
- ext3
- Reiser
- UFS (with or without soft updates?)
- UFS2 (with or without soft updates?)
- other (please specify)
What hardware platform?
- i386
- amd64 (running as amd64)
- amd64 (running as i386)
- em64t (running as amd64)
- em64t (running as i386)
CPU type?
- Opteron
- Xeon
- Pentium 4
- other (please specify)
Any processor options?
- Hyperthreading
- Dual-core
- SMP (multiple physical processors)
Storage engine?
- MyISAM
- InnoDB
Threading library?
- LinuxThreads
- pthread
- libkse
- other (please specify)
Storage hardware?
- ATA RAID
- ATA (no RAID)
- SATA RAID
- SATA (no RAID)
- SCSI RAID
- SCSI (no RAID)
- Software RAID
Storage RAID setup?
- RAID1
- RAID5
- RAID10
- other (please specify)
Overall performance? Threads per second? Are you satisfied?
I would like to use this feedback to determine the most popular/best performing platform (in general) - since right now my setup is performing horribly, and I don't know why - this also may help people in the future to decide what platform to choose prior to buying/installing.
Thanks!
please reply to my thread about mysql usage - i'd like to collect some data! thanks!
http://forums.mysql.com/read.php?11,57080