A GUID as the MySQL table's Primary Key or as a separate column
- by Ben
I have a multi-process program that performs, in a 2 hour period, 5-10 million inserts to a 34GB table within a single Master/Slave MySQL setup (plus an equal number of reads in that period).
The table in question has only 5 fields and 3 (single field) indexes. The primary key is auto-incrementing.
I am far from a DBA, but the database appears…