What is the Key Buffer?
The key buffer is MyISAM specific, a structure for index blocks that contains a number of block buffers where the most-used index blocks are placed. It's mean for minimizing disk I/O, because memory is still faster than hard drives [currently]. The MyISAM key buffer is described in more detail in the documentation.
Locks in InnoDB storage engine:
The InnoDB storage engine handles most locking issues without involvement from you, allowing for better concurrency in the database and reducing the amount of experimentation and tuning for your code.
Stored Procedure & Triggers in MySQL:
A stored procedure is only executed when it is invoked directly; a trigger is executed when an event associated with a table such as insert, update, or delete event occurs, while an event can be executed at once or more regular intervals.
Please come again, I'll be adding some more topics...
The key buffer is MyISAM specific, a structure for index blocks that contains a number of block buffers where the most-used index blocks are placed. It's mean for minimizing disk I/O, because memory is still faster than hard drives [currently]. The MyISAM key buffer is described in more detail in the documentation.
Locks in InnoDB storage engine:
The InnoDB storage engine handles most locking issues without involvement from you, allowing for better concurrency in the database and reducing the amount of experimentation and tuning for your code.
Stored Procedure & Triggers in MySQL:
A stored procedure is only executed when it is invoked directly; a trigger is executed when an event associated with a table such as insert, update, or delete event occurs, while an event can be executed at once or more regular intervals.
Please come again, I'll be adding some more topics...
No comments:
Post a Comment