This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB innodb Tablespace on a Raspberry Pi

Hi Everyone, I'm on a very steep learning curve here, just hoping someone on here may be able to answer my question.

I understand most databasey things having been a Visual FoxPro developer in the past, and have installed MariaDB on to a Raspberry Pi. I am using Node-Red all working very well.

The question I have is about table file sizes.

On the Pi in the "50-server.cnf" file which replaces the "mysql.cnf" it states "# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/". So this got me wondering about table sizes for my data files as my database will ultimately hold only 10 tables but several with a possible 500,000 small (4-10 columns) records. I will move the database folders off to an SSD when development has finished. (whenever that may be!).

I have found that the site MariaDB Knowledge Base is a fantastic resource but my question is still unanswered.

Does the statement "# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/" only refer to the "ibdata1" table?

ibdata1:12M:autoextend (from MariaDB 10.0), ibdata1:10M:autoextend (before MariaDB 10.0)

There is a reference to the increment value " innodb_autoextend_increment" which states " this setting does not apply to the resulting per-table tablespace files, which are automatically extended in their own way."

I'm at the point where I believe I'm overthinking this and it seems it will take care of itself. Anybody able to put my mind at rest?

To help others:

I have found that the "MySQL Workbench" is an excellent gui for administering the databases on my Pi from my windows desktop.

The "50-server.cnf" file replaces the "mysql.cnf" for configuring the installation. This is where the bind-address setting amongst many others is now to be found.

Cheers. Paul.

Answer Answered by Daniel Black in this comment.

Your assumptions about ibdata1 are correct. We probably should remove that comment in the configuration file.

For your purpose there shouldn't be a need to change any innodb system server variables/configuration except maybe the innodb_buffer_pool_size depending how much RAM you have.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.