Software Engineer, Facebook
Rongrong is currently a software engineer on MySQL Engineering team in Facebook. She has been working on MySQL for over two years now, mostly focusing on InnoDB. So far she has worked on statistics, defragmentation, logical read ahead, compression, and whatever comes up in production.
Merge consecutive leaf pages together to release storage space. Unless the insertion pattern is sequential, an insertion to a full page will result in a page split producing two half full pages. Depending on the application, many times lots of the split pages never get more than 70% full. Furthermore, deletions sometime make pages less than 50% full and many times these nearly empty pages... [read more]