High overhead in new mysql table

Question

Does anyone know why I am getting 131.0 MiB overhead on a newly created table (zero rows)? im using phpmy admin and my script code is

CREATE  TABLE IF NOT EXISTS `mydb`.`mytable` (
  `idRol` INT NOT NULL AUTO_INCREMENT ,
  `Rol` VARCHAR(45) NOT NULL ,
  PRIMARY KEY (`idRol`) )
ENGINE = InnoDB;

early.

Answer 1

InnoDB uses a common table space. This means that by default, all tables, regardless of the database, are stored in a single file in the file system. This is different from, for example, MyISAM, which stores each table as a single file.

InnoDB's behavior is subject to change, although I do not think this is really necessary in this case. See Using table table tables .

- , , , , InnoDB . .

Answer 2

, mysql 'idRol'

, , . . .