MySQL DBA Interview Questions - Series 1

1. Describe MySQL architecture.
2. What are the major differences between MySQL 5.1 and 5.5?
3. What are the different database engines available in MySQL? (explain)
4. What are the major differences between MyISAM and InnoDB?
5. Which engine would you prefer for production OLTP environment and why?
6. What are the best installation practices for MySQL?
7. Which RAID level is best suited for MySQL?
8. How do you upgrade from one mysql version to another mysql version?
9. How many types of logs are there in mysql?
10. How do you find out slow queries in mysql?
11. How do you go through the MySQL slow query log?
12. How do you check the uptime of a mysql server?
13. If the mysql server is performing slow than how to find out the process which is causing problem.
14. What do you do if the end user complains about the performance of the DB?
15. What do you do about the slow queries?
16. Where do you change the performance parameters of mysql and by default where is the file located on a unix system?
17. Which are the important performance parameters for MyISAM and InnoDB?
18. Should we have Query_cache enabled?
19. what are the disadvantages of having a big Query cache size?
20. what should be the optimum size of InnoDB buffer cache?
21. How do you backup InnoDB tables?
22. How to take incremental backup in MySQL?
23. Can the database be renamed in MySQL?
24. How to check the table fragmentation and resolve if the fragmentation is found?
25. How to change the root password if the root password is lost?
26. What do you do if the data disk is full?
27. How to take consistent backup in mysql?
28. How do you restrict the users in mysql?
29. what is advantage of having file per table parameter enabled?
30. How do you setup replication?