# Database storage engine

**URL:** <https://forums.percona.com/t/database-storage-engine/1375>\
**Category:** Other MySQL® Questions\
**Created:** [March 29, 2010, 2:37am UTC](https://forums.percona.com/t/database-storage-engine/1375 "2010-03-29T02:37:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ittec](https://avatars.discourse-cdn.com/v4/letter/i/e274bd/32.png) [@ittec](https://forums.percona.com/u/ittec)\
**Post date:** [March 29, 2010, 2:37am UTC](https://forums.percona.com/t/database-storage-engine/1375/1 "2010-03-29T02:37:47Z")

</div>

Hi

few days ago, developers told me that they want a INNODB database. Well if im not wrong MySQL supports innodb storage engine ) but I don’t know the way to specifiy this. I only know we can ALTER TABLE to INNODB when we are working with the new database.

The problem is when developers WATCH database throught PHPMYADMIN, they see MYISAM as Storage Database. They see all tables like INNODB but in the bottom of phpmyadmin, they see MYISAM and they are complaining about this.

Im not sure if I created database wrong or something…

I hope I have explained well my doubt 😕

We are running MYSQL 5.0.77

Thanks a lot guys )

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [March 29, 2010, 7:51am UTC](https://forums.percona.com/t/database-storage-engine/1375/2 "2010-03-29T07:51:55Z")

</div>

InnoDB is available. If you set default\_storage\_engine=innodb in my.cnf, then all new tables will be created as InnoDB by default, unless you choose a different engine explicitly.

---

<div class="post-metadata">

**Author:** ![ittec](https://avatars.discourse-cdn.com/v4/letter/i/e274bd/32.png) [@ittec](https://forums.percona.com/u/ittec)\
**Post date:** [March 29, 2010, 8:22am UTC](https://forums.percona.com/t/database-storage-engine/1375/3 "2010-03-29T08:22:52Z")

</div>

Hi xaprb

I understand Innodb is available, my doubt is, if all tables are Innodb, they will take advangtage of innodb configuration of my.cnf? even if phpmadmind shows database is MyISAM?

I know is a silly question!

Thanks )
