• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
sharadchhetri.com

sharadchhetri.com

Linux,Cloud Computing And DevOps

  • Home
  • Linux
  • CloudComputing
    • Introduction Cloud Computing
    • Amazon AWS
  • Free E-Books
  • About Me

How to know storage engine of mysql table

August 10, 2013 by Sharad Chhetri Leave a Comment

When you are working in mysql server sometimes you need the information about what is the storage engine of table in database. Mostly we use Innodb and MyISAM but it might be the case in mysql server other storage engine can also be used.

In mysql to know storage engine of mysql table,use the below given command

Step 1 : Login into mysql server

mysql -u root -p

Step 2: Connect to database

use database-name

Step 3: Now hit the below given command in mysql prompt. See the second field “Engine”
Replace table-name with name of your mysql table name.

show table status where `Name` = 'table-name' G;

For live example from my system,below given is the reference

linux@tuxworld:~/Desktop/data3/data2$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 190
Server version: 5.5.29-0ubuntu0.12.10.1 (Ubuntu)

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> use linux
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show table status where `Name` = 'tutorials_tbl' G;
*************************** 1. row ***************************
           Name: tutorials_tbl
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 1
 Avg_row_length: 16384
    Data_length: 16384
Max_data_length: 0
   Index_length: 0
      Data_free: 7340032
 Auto_increment: 2
    Create_time: 2013-08-10 16:16:13
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options: 
        Comment: 
1 row in set (0.00 sec)

ERROR: 
No query specified

mysql> 

Do'nt be greedy, share the knowledge!

  • Click to share on Facebook (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Pocket (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Related

Filed Under: Linux

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Follow Us

  • Facebook
  • Twitter
  • GitHub
  • YouTube

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Handpicked Posts

  • terraform

    how to install terraform in Linux : CentOS-Ubuntu

  • docker image

    How to create Ubuntu docker base image

  • install ansible

    Install Ansible in Ubuntu 18.04 LTS with pip3

  • Install Ansible on Ubuntu / CentOS / RHEL

Top Posts & Pages

  • How to delete mail queue in Postfix
  • How to start / stop / restart / reload iptables on CentOS 7 / RHEL 7
  • How to setup Jenkins Credentials for Git repo access
  • How to install MySQL Server 5.6 on CentOS 7 / RHEL 7
  • How to set hostname and FQDN on CentOS 7 and RHEL 7
  • 4 different commands to check the load average in linux
  • How to fix read only USB pen drive in Ubuntu
  • How to find absolute path of command on Linux / Unix : which command
  • How to zip the directory in linux with command line
  • How to print particular line number by using sed command

Recent Posts

  • Install Docker on CentOS 7
  • Install and setup maven in Linux for Jenkins
  • How to setup Jenkins Credentials for Git repo access
  • How to manage Jenkins Credentials
  • Managing Jenkins plugins from command line and GUI

Footer

Sharad Chhetri is an experienced Linux - Cloud Engineer & freelancer. Working on Open Source Technology since RHEL 4.0 (Red Hat Enterprise Linux). He loves sharing the knowledge which earned from real scenarios. Don't be surprised if you find him in technology seminars and meetup groups. You can contact him on email for freelance projects at admin@sharadchhetri.com. Read More…

Help To Needy

If you like our posts and tutorials, please support/donate to ANY “Open Source Project” or do some Charity work. Hope this will make someone happy in this world. Drop me an email if you want to inspire others!

Thank You!

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Our GitHub Repo

sharadchhetri @ GitHub
  • scripts
    Cassandra Backup Script
    September 22, 2019 - 11:51 pm UTC
  • aws
    AWS related stuff like Cloudformation, python boto3 scripts etc.
    August 3, 2019 - 2:45 am UTC
  • cf-prometheus
    prometheus-2.11.1.linux-amd64 for Cloudfoundry
    July 22, 2019 - 9:04 am UTC
  • tomcat

    June 13, 2019 - 12:20 pm UTC
  • maven-sample
    Maven Sample repo
    June 13, 2019 - 10:01 am UTC

Recent Comments

  • Suhas on System settings not opening on Ubuntu 16.04 LTS
  • Kuldeep on How to install own git server with ssh and http access by using gitolite and gitweb in CentOS
  • DD on convert space into new line using sed command
  • Andrew on How to fix read only USB pen drive in Ubuntu
  • ari on Squid proxy server to block websites listed in file
  • Michael on Managing Jenkins plugins from command line and GUI
  • Sharad Chhetri on Secondary Logging : save all users history command output as log
  • Datta on How to fix read only USB pen drive in Ubuntu

Copyright © 2009 - 2019 · All Rights Reserved sharadchhetri.com · · Privacy Policy ·
· sitemap.xml · ·The content is copyrighted to sharadchhetri.com and may not be reproduced on other websites without our permission. ·

Copyright © 2019 · Genesis Sample on Genesis Framework · WordPress · Log in