setting time zone on remote machine

1. edit php.ini file
/etc/php5/apache2/php.ini

date.timezone= Asia/Culcutta

sudo dpkg-reconfigure tzdata

How to increase open file limit for mysql

he solution is to modify the mysql.conf file that defines the upstart service, it is located at /etc/init/mysql.conf and add the following lines before the pre-start block:

# NB: Upstart scripts do not respect
# /etc/security/limits.conf, so the open-file limits
# settings need to be applied here.
limit nofile 32000 32000

check :

mysql> show global variables like 'open%';




Disable apache2 logging

don't forget to disable other vhost logging

at
etc/apache2/conf.d/other-vhost-access-log

debugging mysql failure

culprit # 1 : disk full

df -h

remove logs

repair databases
mysqlcheck --repair --all-databases -u root -p

individual

use <db>

check table <table>

repair table <table>

remove tmp overflow:

sudo umount overflow