MySQL management interview questions
Quick Revision Summary
1 How do you show the currently running queries? - SHOW FULL PROCESSLIST; 2. How do you kill a MySQL query? - See the ID of it from the question above, then KILL id. You can sep...
Interactive Practice Mode
Formulate your thoughts or take notes before revealing the model solution.
Saved automatically
Model Answer & Deep-Dive Explanation
1
How do you show the currently running queries? - SHOW FULL PROCESSLIST;
2. How do you kill a MySQL query? - See the ID of it from the question above, then KILL id. You can separate multiple IDs by space.
3. I need to find out how many client connections were aborted by MySQL server. - It’s displayed in SHOW STATUS query, alte
atively accessible via mysqladmin extended-status.
4. What does SET SQL_AUTO_IS_NULL =1 do? - you can find the last inserted row for a table that contains an AUTO_INCREMENT column by issuing WHERE auto_increment_column IS NULL
Interviewer Evaluation Points & Scoring Rubric
- 1 Structure answer clearly: Core concept, Practical example, and Pitfalls to avoid.
- 2 Demonstrate clear communication without unnecessary buzzwords.
- 3 Relate concept to real-world software development scenarios.
Related Questions in Database
DBA Interview Questions
Intermediate level • 742 views
MS-SQL Server developer interview questions
Advanced level • 263 views
What is normalization, and when might denormalization be justified?
Easy level • 3 views
Why can a replica return stale data immediately after a successful write?
Medium level • 3 views
How do a primary key, foreign key, and unique constraint serve different purposes?
Easy level • 2 views