Does Directadmin counts InnoDB tables?

zEitEr · Mar 3, 2009

Hi!

Does Directadmin consider InnoDB tables while counting user's disk quota?

scsi · Mar 3, 2009

It counts everything.

zEitEr · Mar 4, 2009

scsi said:
It counts everything.

Checked, it really counts InnoDB databases. But how?
We've got one big /usr/local/mysql/data/ibdata1 file for all users.

LawsHosting · Mar 4, 2009

zEitEr said:
Checked, it really counts InnoDB databases. But how?
We've got one big /usr/local/mysql/data/ibdata1 file for all users.

Thats a general MySQL log isn't it? Hence not included

zEitEr · Mar 4, 2009

No.

Two important disk-based resources managed by the InnoDB storage engine are its tablespace data files and its log files. If you specify no InnoDB configuration options, MySQL creates an auto-extending 10MB data file named ibdata1 and two 5MB log files named ib_logfile0 and ib_logfile1 in the MySQL data directory.

See http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html for details.

LawsHosting · Mar 4, 2009

Still cant see how it'll be counted as the Innob databases are via *.idb's, the data/log files are just there for backup incase they crash? No? I've only worked with Innob's with <cough>Plesk<cough>, so excuse my ignorance.

Does Directadmin counts InnoDB tables?

zEitEr

Super Moderator

scsi

Verified User

zEitEr

Super Moderator

LawsHosting

Verified User

zEitEr

Super Moderator

LawsHosting

Verified User