usertable. We also started to build an understanding of when MySQL can and shouldn't use an index for a query, but we omitted one fun fact. ... read more
Tagged with "innodb"
PRIMARYindex. Unfortunately, this same problem exists in secondary indices, and usually to an even greater effect since the data are rarely ordered at insertion time. ... read more
PRIMARYindex using a monotonic primary key. Before moving on to secondary indices, we'll consider random-order inserts. ... read more
auto_incrementmaybe wasn't as glowing as it should have been, but we really shouldn't let one little
auto_incrementreally is an invaluable tool, and today we'll consider why. ... read more
REPEATABLE READ(what a mouthful!), then today's Fun MySQL fact is for you! I ... read more