• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
sharadchhetri

sharadchhetri

Tutorials On Linux, Unix & Open Source

  • Home
  • Linux Commands
  • Resources
    • Learn Linux
  • My WordPress plugins

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> 

Share this:

  • Twitter
  • Facebook
  • More
  • Print
  • Email
  • LinkedIn
  • Reddit
  • Tumblr
  • Pinterest
  • Pocket
  • Telegram
  • WhatsApp
  • Mastodon

Related posts:

  1. How to check default storage engine in MySQL server
  2. How to set default storage engine to MyISAM to InnoDB vice versa
  3. mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed
  4. How to copy existing table in mysql
  5. How to rename table in mysql using command line
  6. How To Add duckduckgo Search engine in WordPress Blog or website
  7. how to mount NAS storage in owncloud to keep all users data
  8. Find mysql commands history without mysql server login
  9. send email after mysql backup through bash script in simple way
  10. create noreply email id in postfixadmin mysql database

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

Our Social Media Presence

  • Facebook
  • GitHub
  • Twitter

Linux Command

What is Linux Internal And External Command

Linux Basic Commands With Examples For Every Beginner

tr command to convert lines to space , tab and vertical tab

smbpasswd command not found on CentOS 7 and RHEL 7

Solution : semanage command not found

Unix / Linux : How to print duplicate lines from file

More Posts from this Category

You Might Like These Articles!

simplecodesyntax wordpress plugin

SimpleCodeSyntax : My Another WordPress Plugin

Install Nginx

How To Install Nginx On Ubuntu 22.04 LTS

Install Latest Git package in Ubuntu Operating System

How To Always Install Latest Git Package In Ubuntu Operating System

Bash script for installing VirtualBox on Ubuntu 22.04 LTS Desktop

Install VirtualBox On Ubuntu 22.04 LTS Desktop (Bash Script)

libfuse

dlopen(): error loading libfuse.so.2 – Got Error On Ubuntu

Failed to open/create the internal network

VirtualBox Error: Failed to open/create the internal network

Always Useful Tips And Tricks

How to see system load average in terminal with graphical representation

send email after mysql backup through bash script in simple way

error could not configure a c compiler Linux

Change the default port number of ssh server

Nagios HTTP WARNING: HTTP/1.1 403 Forbidden

How to see line numbers in file through cat command

Convert hyphen to underscore in between all filenames shell script

Explore 90+ Article On "Linux Tips And Tricks"

Copyright © 2023 ยท
The material in this site cannot be republished either online or offline, without our permission.
Proudly Blogging From Bharat.

  • Contact
  • About Me
  • My WordPress plugins
  • Privacy Policy