# MariaDB innodb Tablespace

**URL:** <https://discourse.nodered.org/t/mariadb-innodb-tablespace/41242>\
**Category:** General\
**Created:** [18 February 2021 14:36 UTC](https://discourse.nodered.org/t/mariadb-innodb-tablespace/41242 "2021-02-18T14:36:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![FatPilot](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/fatpilot/32/38329_2.png) [@FatPilot](https://discourse.nodered.org/u/FatPilot)\
**Post date:** [18 February 2021 14:36 UTC](https://discourse.nodered.org/t/mariadb-innodb-tablespace/41242/1 "2021-02-18T14:36:53Z")

</div>

Hi Everyone,  
I'm on a very steep learning curve here.  
I know this is not a Node-Red issue 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 Pi 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](https://mariadb.com/kb/en/) 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](https://mariadb.com/kb/en/what-is-mariadb-100/)), `ibdata1:10M:autoextend` (before [MariaDB 10.0](https://mariadb.com/kb/en/what-is-mariadb-100/))

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:

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

2. 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.

---

<div class="post-metadata">

**Author:** ![FatPilot](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/fatpilot/32/38329_2.png) [@FatPilot](https://discourse.nodered.org/u/FatPilot)\
**Post date:** [19 February 2021 10:56 UTC](https://discourse.nodered.org/t/mariadb-innodb-tablespace/41242/2 "2021-02-19T10:56:33Z")

</div>

Hi Everyone,

I had a reply to my query from MariaDB!  
I thought I would post it here for others who may be interested.

> 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

Cheers.  
Paul.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [20 April 2021 10:57 UTC](https://discourse.nodered.org/t/mariadb-innodb-tablespace/41242/3 "2021-04-20T10:57:06Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.