1. PlacementQuestion
2. Mysql Questions
3. True False Choice Question

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.

---

2. 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

---

---

3. 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.

---