Tag Info

New answers tagged


Technically speaking, there is no single answer for "MySQL" itself, because MySQL has a pluggable storage engine architecture and the server itself is essentially unconcerned with and unaware of how the physical storage of data is accomplished. Those details are handled by the storage engines. The most relevant storage engine in MySQL is InnoDB. Can ...


The way MySQL stores data depends on storage engine. A concept of a page exists in InnoDB while in MyISAM there are blocks. In InnoDB a page is fixed 16k while a block in MyISAM is of fifferent size depending on type of the block and the size of the record in it. InnoDB stores tables in B+ tree data structures that they call indexes. The table itself ...

Top 50 recent answers are included