Tagged with "innodb"
Fun MySQL fact of the day: OR not
We started discussing secondary indices yesterday, and we considered how we might create two separate indices on our user table. 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
Fun MySQL fact of the day: it's all secondary
In the last couple weeks ending with yesterday, we'd discussed secondary indices a few times, but we never really discussed why you may want to use them. So, over the next several days, we will do just that. ... read moreFun MySQL fact of the day: change buffering
Yesterday, we considered the consequences of random-order inserts on aPRIMARY index. 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
Fun MySQL fact of the day: splitting pages
Last week, we looked at how InnoDB uses records, pages, and extents to organise data, and we mostly considered inserts on thePRIMARY index using a monotonic primary key. Before moving on to secondary indices, we'll consider random-order inserts. ... read more
Fun MySQL fact of the day: to a greater extent
Yesterday, we discussed that an InnoDB index (remember: there is no table) consists of a collection of records stored in a collection of pages. Well, the fun doesn't stop there: pages are stored in a collection of extents, and like how records are stored in insertion-order ... read moreFun MySQL fact of the day: descending means ascending
If you'd believe it, I told you only a partial truth again yesterday and Tuesday. While it's true that records are sorted in key-order in an InnoDB index, there's some yet more interesting finesse to it. In fact, would you believe me if I told you that records are ... read more
Fun MySQL fact of the day: in defence of auto_increment
Monday's introduction to auto_increment maybe wasn't as glowing as it should have been, but we really shouldn't let one little auto_increment really is an invaluable tool, and today we'll consider why. ... read more