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. 07-17-2008 #1
    ynilesh
    ynilesh is offline
    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
    Reply With Quote Reply With Quote
  2. 07-17-2008 #2
    Gediminas
    Gediminas is offline
    Just Joined!
    Join Date
    Jul 2008
    Location
    Lithuania
    Posts
    4
    use:
    Code:
    SHOW TABLE STATUS
    table engine will be in column 'Engine'
    Reply With Quote Reply With Quote
  3. 07-17-2008 #3
    ynilesh
    ynilesh is offline
    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
    Reply With Quote Reply With Quote
  4. 07-17-2008 #4
    Gediminas
    Gediminas is offline
    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)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules