To show the storage engines used by each tables in a database

-


1. Login to Mysql as root user.

2. Use db_name;

3. Execute the query "show table status ; ". It'll show the engine used by each tables in the database you have selected.

Comments

Post a Comment

Popular posts from this blog

Logical volume vmxxxx_img is used by another device - Error on LVM removal

-
Hi Folks, I've faced error while trying to remove an LVM from the server. The exact LVM error will be "Logical volume vmxxxx_img is used by another device" on executing the lvremove command. Feel free to remove the following steps to remove the LVM from the server. Note: Please remember to replace <id> with your  VMID in the below section. ---------------------------------------------------------- dmsetup ls dmsetup info -c xen-vm<id>_img dmsetup remove xen-vm<id>_img lvremove -f /dev/xen/vm<id>_img ----------------------------------------------------------
Read more

Open VZ cheat Sheet

-
VZCTL COMMANDS --------------------- vzctl set 101 --diskspace 1000000:1100000 --save  To set diskspace for container with ID 101 vzctl set 101 --diskinodes 90000:91000 --save     To set inodes for container with ID 101 vzctl set 101 --quotatime 600 --save              To set quotatime for container with ID 101 (The time limit by                                                        which container is allowed to temporarily exceed  its quota soft limits) vzctl exec 101 df                                  To execute command df at the server with the CTID 101 vzctl set 101 --quotaugidlimit 100 --save          Set number of user/group id's allowed for internal disk                                                                      quota,if 0 UID/GUID quota will not be allowed\  vzctl set 0 --dcachesize 5G --save        Set dcachesize of the hardware node sysctl fs.fsync-enable=0     or  echo 0 > /proc/sys/fs/fsync-enable        disable fsync calls inside cont
Read more

Cheat sheet for Hardware RAID health check - Megaraid, Adaptec, 3wareraid and HPraid.

-
Hi Folks, In another post " raid type " I've mentioned how to find if the server is running with Software or Hardware RAID. Here, we can go ahead and check the health of the Hardware RAID array in the server. The first thing we need to detect is the controller in which the raid is configured and you can easily get it from the another post that I mentioned earlier. However, I'm providing it here again for your convenience. 1. Login to the server as the root user. 2. Execute the following command. /sbin/lspci -vv | grep -i raid 3. This will show the raid controller running on the server. The different types of controller I've worked with includes a. Megaraid which uses megacli b. Adaptec which uses arcconf . c. 3ware raid which uses tw_cli d. HPraid which uses hpacucli . How to check the Megaraid array health status? The Megaraid is usually installed in the /opt/MegaRAID and you can execute the following command to verify the health of the arr
Read more