June 19, 2013

Post: What does Using filesort mean in MySQL?

…,” what would you say? I have asked this question in a bunch of interviews so far, with smart people, and not one… it right. So I consider it to be a bad interview question, and I’m going to put the answer here. If… too big, but EXPLAIN doesn’t show that. (If I interview you, I might ask you what “too big” means, or…

Post: Would you like to ask a question about PBXT?

… week, I’ll be interviewing Paul McCullagh, the architect behind the PBXT storage engine. If you have any questions for Paul, please post them here by Monday 16th November. Note: The idea for this interview was inspired by a previous interview

Post: Interviews for InfiniDB and TokuDB are next

I forwarded on a list of questions about PBXT to Paul McCullagh today.  While Paul’s …. Kuszmaul (TokuDB storage engine) have also accepted an interview. If you have any questions about either storage engine, please post them here…

Post: Baron Schwartz interviewed on WebPulp.tv

There’s an interview with Baron Schwartz (that’s me) on WebPulp.tv. Topics … web engineer himself, and he knows how to ask probing questions that bring out a lot of interesting details about various…

Comment: MySQL Server Variables - SQL layer or Storage Engine specific.

…/…… ??? Download EBooks Freely in .pdf,.chm formats and ready for interview questions…. http://hotsoftwareslist.blogspot.com/2007/08/download-ebook.html Download…

Comment: What does Using filesort mean in MySQL?

If people do not answer this question incorrectly, it simply means they do not read. The answer … quaestions are VERY bad on the interview. It is ok to test skills during the interview but it is bad to ask… test if the person can ~find~ the answer to the question. Someone who knows is not necessarily the best. Someone who…

Comment: What does Using filesort mean in MySQL?

… how to find such information. As for such questions being bad for interviews it depends on what do you want to understand about the candidate and even more what job you are interviewing for. If it’s about on-site consulting you definitely…

Post: What to tune in MySQL Server after installation

My favorite question during Interview for people to work as MySQL DBAs or be involved … many people fail to provide any reasonable answer to this question, and how many servers are where in wild which are…

Comment: MariaDB 5.3.4 benchmarks

…/blog/2011/09/mariadb-the-new-mysql-interview-with-michael-monty-widenius/ The obvious question is if so much benchmarking is being…

Comment: What does Using filesort mean in MySQL?

Gee, I wonder what it is like to be in an interview and get this question from Baron? I think I always had the general idea, but reading these posts gave an extra layer. T