Uncategorized

Enable MySQL slow query log

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 […]

Linux * Python * WHM/Cpanel

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 […]