Types of buffers in mysql with examples

Table cache :

When users request row from tables, the rows to be given to client are stored in table cache.

Grant table buffer :

it stores the privileges of user created tables and user privileges.

Key buffer :

it contains index information of tables.

Query Cache :

it contains the execution plans of the previously executed statements.

buffer is divided into pages that can potentially hold multiple rows.

When we kill a connection thread then it will automatically create a new connection with a new thread id to the server with same user credentials.