Monday, 13 June 2011

MySQL management interview questions

 How do you show the currently running queries? - SHOW FULL PROCESSLIST;
    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.
    I need to find out how many client connections were aborted by MySQL server. - It’s displayed in SHOW STATUS query, alternatively accessible via mysqladmin extended-status.
    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

No comments:

Post a Comment

Twitter Bird Gadget