Questions for mysql programmers

These are some questions I have used when interviewing mysql programmers. I’m sure they can be improved, but they worked for me :)

Q: Can you tell me of a scaling incident with mysql (when a scaling or performance problem occured) and how you fixed it?
a: –

Q: can you explain the cardinality of an index in mysql?
a: how much it distinguishes unique rows

Q: how can you increase the cardinality of an index?
a: make length longer

Q: how could you increase it for an index on a field that contains urls, for example?
a: reverse urls

Q: How do innodb vs myisam tables affect performance in large tables?

Q: How do you analyze the slow query log?

Q: how is the size of a table limited in mysql
a: by storage filesystem

Q: what are the things a master/slave setup doesn’t solve for scaling?
a: writes

Q: Show them a query and the explain output: what’s going on here?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s