Explain what is DBA and your day to day work schedule at current employer.
Mysql Database Administrator Interview Questions
43 mysql database administrator interview questions shared by candidates
I was asked to diagnose an actual problem they were having with a database. I was given access to their performance visualization tools so I could see the DB's vital signs. I was asked to explain why a spike in DB response time occurred at a specific time (as shown on a graph). I was able to log into the database and examine statistics and performance counters, but the best tools were their extensive graphs.
Question about troubleshooting in Linux (how to fix problem with overloaded cpu, ram, disk), How to understand which process making problems. Some questions about iptables. About fixing problems with replication in MySQL.
How would you approach troubleshooting a slow MySQL server?
How would you fix replication when the relay log is corrupted?
What backup methods are you familiar with?
innodb engine stats
What's the main difference between Innodb and MyISAM storage engines.
Basic questions about mysql experience.
Test assignment. Focusing on scaling and other more general items. Parsing Apache logs. For a DBA role I expected more MySql based questions
Viewing 21 - 30 interview questions