Find the answer to your Linux question:
Results 1 to 4 of 4
Hi all, I am newbie to mysql, i know all standard location where we can get database. I wanted to know which storage engine (myisam, innodb, etc) is used to ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Newbie
    Join Date
    Feb 2008
    Location
    Bangalore, India
    Posts
    112

    how to recongnize which storage engine used for database.


    Hi all,

    I am newbie to mysql, i know all standard location where we can get database. I wanted to know which storage engine (myisam, innodb, etc) is used to store data.
    bigunix.blogspot.com
    Registered Linux User: #476440

  2. #2
    Just Joined!
    Join Date
    Jul 2008
    Location
    Lithuania
    Posts
    4
    use:
    Code:
    SHOW TABLE STATUS
    table engine will be in column 'Engine'

  3. #3
    Linux Newbie
    Join Date
    Feb 2008
    Location
    Bangalore, India
    Posts
    112
    Isnt there anything which will result database details. I mean when its created, type, storage engine, size etc......
    bigunix.blogspot.com
    Registered Linux User: #476440

  4. #4
    Just Joined!
    Join Date
    Jul 2008
    Location
    Lithuania
    Posts
    4
    Code:
    SHOW TABLE STATUS
    Shows what do you need - tables creation date, engine, last update date and so on. It shows info about all tables in database that is using (command USE)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •