… interviews so far, with smart people, and not one person has gotten it right. So I consider it to be a bad interview question, and I’m going to put the answer here. If anyone gets it wrong from…. I refer you to Sergey Petrunia’s article on How MySQL executes ORDER BY. You can also read about it in…
Post: Would you like to ask a question about PBXT?
November 12, 2009 By 5 Comments
… questions for Paul, please post them here by Monday 16th November. Note: The idea for this interview was inspired by a previous interview with Heikki Tuuri – creator of InnoDB. You can see the answers here and here.
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
My favorite question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server… surprised how many people fail to provide any reasonable answer to this question, and how many servers are where in wild which are…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
Interviewing people for our Job Openings I like to ask them a basic question – if you have a… publish the answer I would like to hear extending it with basics of Hardware OS And Application optimization….especially in locking in 5.0 and even more to come with MySQL 5.1 and row level replication. There…
Comment: What does Using filesort mean in MySQL?
March 5, 2009 By 27 Comments
… .. My standard answer is “filesort refers to the algorithm MySQL is using and has nothing to do with files on disk” and if I… of many bad names you can find in MySQL. It’s bad question for job interviews though especially the way you present it… table to disk, but I might be wrong and will check it” and will show the door to a candidate who says…
Comment: What does Using filesort mean in MySQL?
March 9, 2009 By 27 Comments
… not answer this question incorrectly, it simply means they do not read. The answer is clean and clear at the MySQL web site: ========================= Using filesort MySQL… quaestions are VERY bad on the interview. It is ok to test skills during the interview but it is bad to ask…
Comment: What does Using filesort mean in MySQL?
March 14, 2009 By 27 Comments
… such information is difficult. MySQL manual is not easy to navigate and it changes all the time…questions being bad for interviews it depends on what do you want to understand about the candidate and … interviewing for. If it’s about on-site consulting you definitely prefer one being able to answer…
