Find out the tables storage engine in your MySQL database

Problem

You would like to check the storage engine in a MySQL database.

Solution

Use the following query after logging in to the server:

Taken from here

Changing default editor for crontab from nano to vim

Problem

You would like to change the default editor for crontab from nano to vim.

Solution

Add the following to the ~/.selected_editor:

or run the select-editor and choose vim-basic (4)