InnoDB Storage Engine: "innodb_page_size" Explained!

In this MariaDB server tutorial we’ll walk you through the mariadb server variable called “innodb_page_size”

This MariaDB server variable lets us expand database pages. A larger database page size expands the maximum row size (i.e. more data can be stored in our database tables.)

A smaller database page size may work better with SSD-based storage or in apps that employ many small writing (INSERT sql query) operations.
The maximum value depends on the row format that is being used in our sql databases.

1) COMPRESSED: using this row format the page size cannot exceed 16k.
2) DYNAMIC, COMPACT & REDUNDANT: using these row formats, the database page size can be as big as 64k.

Do note that the variable size cannot be canged once the database server has been started and the data directory has been initialized.

Also, keep in mind that the background for this mysql tutorial was filmed in the beautiful island of Tenerife – have you been near the tenerife sea? Have you heard about the tenerife disaster or the so called tenerife airport disaster? Tell us in the comments below.

Music:
Help Me by Spiring https://soundcloud.com/user-57630131
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: https://bit.ly/3PrrAX1
Music promoted by Audio Library https://bit.ly/3ErXT1F

#database #sql #developer #web #reels #shorts #mysql #mariadb