Mysql Questions

  1. What is mysqladmin?
  • Answer:
  • mysqladmin is a client for performing administrative operations. Use it to check the server's configuration and current status, to create and drop databases, and more.
Added By : Deeksha

  1. What is the difference between "KILL CONNECTION" AND "KILL QUERY"?
  • Answer:
  • KILL CONNECTION - It is same as KILL statement. It terminates the connection associated with the given thread_id.
    Syntax - KILL CONNECTION thread_id

    KILL QUERY - terminates the statement that the connection is currently executing, but leaves the connection itself intact.
    Syntax - KILL QUERY thread_id

Added By : Deeksha


  1. What is the difference betweeen InnoDB and MyISAM storage engine?
  • Answer:
  • InnoDB

    1. The InnoDB storage engine supports full ACID properties.

    2. The InnoDB storage engine supports checking of foreign key constraints.


    MyISAM

    1. MyISAM tables effectively always operate in autocommit = 1 mode. MyISAM does not support full ACID properties.

    2. MyISAM does not support foreign key.

Added By : Sumit

Social Sharing
Search