If I have a computer with many cores and multiple disks, disjoint
filesystems on those disks, and enough I/O bandwidth in the machine to
keep the disks busy, can MySQL keep those disks busy if I have it working
on different databases at the same time? If so, can one MySQL server
process do that, or do I need multiple server processes? If one process
is enough, presumably I have to say something clever in my.cnf to make it
happen; what would that be? If it can be done with multiple server
processes, can I get that from one MySQL installation (and if so, how) or
do I need to somehow fool my package management system (RPM on RHEL) into
doing multiple installations?
Thanks,
Mike Spreitzer
