Heigh-ho, heigh-ho, it’s down to Asheville we go

Thanks to Pythian’s philosophy of keeping their employees on the bleeding edge of technology, at the end of this month I’ll be crossing the American borders to join the YAPC::NA festivities. Am I thrilled? Ooooh heck yeah, I sure am. I looked at the list of talks and divided them into two groups, talks I want to see, and talks I really, want to see. Here is what my own personal schedule tentatively looks like:

Designing Index to Eliminate Sorting

Using algorithm described in “Relational Database Index Design and the Optimizers by Tapio Lahdenmaki and Mike Leach”, I quickly came up with two indexes and while first one looked fine, I was really confused by the second one for the elimination of the sort. Let me show an example, not copy one from the book, but rather show a test I did with MySQL.


If we are observing more and more swapping in (ver frequent si in vmstat) then we could look at decreasing swappiness.
In order to play with the swappiness, you can temporarily set it by doing the following…

Page 80 of 241« First...102030...7879808182...90100110...Last »