… it _may_ not. > This base mysql version (5.1.56) supports partitions, but does not support partition pruning. Eh? Is that a NDB… and the app is CPU-intensive. Do not allow swapping; that will kill MySQL performance. “50 users” — a useless metric without knowing…
Post: RAID and Scale Out Discussions
…for OS hard drive. Indeed using RAID for OS partition (software) is what we use even for low end…I remember uses decent servers with RAID for their MySQL installations. I surely agree with Jeremy on Commodity …storage option. Ie find me 12 or more hot swap SATA hard drives in the case in Dell range…
Comment: Filling the tmp partition with persistent connections
… we can put temp directory on memory or swap memory for highly loaded MySQL server, where running stupid-coded scripts. what I… disk space used, or redirect the “disk space” to another partition – let say SSD or striped RAID0

