1. Log in to your account using SSH. 2. mysql -u username -p 3. SELECT table_schema “Data Base Name”, sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”, sum( data_free )/ 1024 / 1024 “Free Space in MB” FROM information_schema.TABLES GROUP BY table_schema ;
Month: February 2017
UBUNTU- automatic package install – check if system needs reboot
Automatic packages – how to know if system needs to restart: Update manager suggests to restart when kernels are upgraded or some other system packages with services that are marked for reboot when upgraded. In this case /var/run/reboot-required is set by a package installation script.
Solaris Fibre Channel Commands
To see info on all fc ports: fcinfo hba-port -l To see port status: luxadm -e port Show link errors: luxadm -e rdls /dev/cfg/c3 Examine and individual path: luxadm disp /dev/rdsk/c2t500601603022431Ed0s2 Run an inquiry on a disk: luxadm inq /dev/rdsk/c2t500601603022431Ed0s2 Display info on scsi devices: cfgadm -al Sun Multipather examples Shows the fc ports: mpathadm […]
PHP – change max execution time
First, you need to find out what max_execution_time is set on your PHP installation: Locate your php.ini file and check what the value of the max_execution_time directive is: [root@server ~]# php -i | grep php.ini Configuration File (php.ini) Path => /etc Loaded Configuration File => /etc/php.ini [root@server ~]# grep -i max_execution /etc/php.ini max_execution_time = 30 […]
How to downgrade kernel and redhat-release to a previous minor version of Red Hat Enterprise Linux
Source: How to downgrade kernel and redhat-release to a previous minor version of Red Hat Enterprise Linux SOLUTION VERIFIED – Updated July 24 2014 at 11:03 AM – English Environment • Red Hat Enterprise Linux (RHEL) 6 • Red Hat Enterprise Linux (RHEL) 5 Issue • The kernel and redhat-release packages have been upgraded to a version later […]
Enable Netapp Autosupport
• Connect to the filer via telnet, ssh or through the console. • Enter the following commands options autosupport.mailhost [your mail server MX record or IP address] options autosupport.to support@example.com,name@yourcompany.com (ex: person@company.com) options autosupport.from (Add anything here; we like to use filername@domain.com) options autosupport.enable on options autosupport.support.enable off • If your Data OnTap has the option, enter these […]