MySQL Benchmark – updates by primary vs secondary keys

wrong_tool_for_the_job_by_raresdk-d35viqj

(Note: when I’m talking about MySQL I usually assume InnoDB storage engine. Any other case I explicitly tell this is MyISAM or Memory etc.)

I’ve heared an interesting aproach of using Master-slave replication in MySQL.

Thesis

So the theory was that since updates by primary keys are fast and by … Continue reading