each. Multiple queries
on the same MyISAM table will queue up if there is a writer amongst them.
If you are using a table engine that supports parallel access (innodb for
example) then multiple queries can write to the same table without blocking
readers. Also, note that MySQL doesn't do q
Hi Mike,
The way we do it is installing each mysql instance from a
precompiled binary.
So if you had an 8 core box, and you wanted to use each of the 8
cores, you could install a mysql binary installation and then make 7
copies of it. We use an internal naming convention like the followi
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 tha
Rather a tall order (still reading docs, can't see anything about this), but
can two MySQL instances on two servers be connected to the same disks? For
failover purposes.
Any pointers to documentation on the subject greatly appreciated.
J.
--
Justin Rowles
Technical Consultant
Sellers Informa
