Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Database storage engine

ittecittec ContributorInactive User Role Beginner
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 )

Comments

  • xaprbxaprb Mentor Inactive User Role Beginner
    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.
  • ittecittec Contributor Inactive User Role Beginner
    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 )
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.