The slow query log consists of SQL statements that took more than long_query_time seconds to execute and required at least min_examined_row_limit rows to be examined. It is very helpful in troubleshooting bad queries. Add the following to /etc/my.cnf file to enable the slow query log: Code: After that, then do the following commands to create […]
Install Python for a user
Log into server as user via SSH : Download Python package of required version from : http://www.python.org/getit/releases/ Say, version required is 2.6.6 Code: # wget http://www.python.org/ftp/python/2.6.6/Python-2.6.6.tgz Code: # tar -xvf Python-2.6.6.tgz Code: # cd Python-2.6.6 Configure and Install Python for user : Code: #./configure –prefix=/home/user_name/Python-2.6.6 Code: # make Code: # make install Python Binary for […]
Extend Xen Disk Space
Xen VMs use lvms and extending disk space from SolusVM control panel may not work properly. So, we will need to extend the lvm manually. Shutdown VM from SolusVM control panel or use the following command on node : # xm shutdown vm_ID (Replace vm_id with the xen ID of the VPS) Extend LVM : […]