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
