Getting type of engine of Mysql’s tables.

# mysql -u root -pXXXXX -e 'select table_schema,table_name,engine from tables' information_schema +--------------------+---------------------------------------+--------+ | table_schema | table_name | engine | +--------------------+---------------------------------------+--------+ | information_schema | CHARACTER_SETS | MEMORY | | information_schema | COLLATIONS | MEMORY | | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | MEMORY | | information_schema | COLUMNS | MyISAM | .......

Changing PHP Memory Limit : 3 ways

If you have seen an error like ”Fatal Error: __PHP Allowed Memory Size Exhausted” in apache logs or in your browser, this means that PHP has exhausted the maximum memory limit. This post will show 3 different ways on how you can increase the php memory limit and also explain when you should use...

How to Clear Memory Cache on Linux

By default, every Linux OS has an efficient memory management system used to clear the buffer cache periodically. You can manually free up the memory cache with the following simple command: # echo 3 > /proc/sys/vm/drop_caches" However, if you want to force the Linux OS to do clearing memory cache on a particular interval,...

TIPS: “stdin is not a tty” when using SCP

SCP / SSH may not need a (pseudo-)terminal but something may expect it regardless on the remote end. Does any global or personal shell resource files contain “stty” or “mesg” (‘egrep -r “stty|mesg” /etc/bashrc /etc/profile /etc/profile.d ~/.bashrc ~/.bash_profile;’)? For example: root@server # egrep -r "stty|mesg" /etc/bashrc /etc/profile /etc/profile.d ~/.bashrc ~/.bash_profile /etc/bashrc:mesg y root@server #...

Scroll to top