… one .. My standard answer is “filesort refers to the algorithm MySQL is using and has nothing to do with files on… of many bad names you can find in MySQL. It’s bad question for job interviews though especially the way you present it…
Comment: What does Using filesort mean in MySQL?
March 14, 2009 By 27 Comments
Dmitry, You will be amazed how many MySQL “experts” don’t read the manual. They either “know” or …. At the other had digging out such information is difficult. MySQL manual is not easy to navigate and it changes all… for interviews it depends on what do you want to understand about the candidate and even more what job you are interviewing for…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
Interviewing people for our Job Openings I like to ask them a basic question – if … you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb… about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM…
