Pagination in MySQL

And here I was thinking I knew all there was to know about pagination: do cursor pagination, offset-pagination is bad. Good to see the tradeoffs fleshed out fully.