VPS

Where are Log Files for SSH, FTP, Apache Stored in cPanel/WHM

If you have cPanel/WHM VPS or dedicated server & would like to view all log files, these are the locations

All cpanel related logs are in (mostly similar to apache logs)

/usr/local/cpanel/logs

Apache logs are in

/usr/local/apache/logs

Individual domain logs are in

/usr/local/apache/domlogs

POP/IMAP logins are in

/var/log/maillog

FTP Logins are in

/var/log/messages

SSH Logins are in

/var/log/secure

Increase MySQL Maximum No Connection in CentOS VPS

In you have rather busy VPS, the default MYSQL Maximum No Connection maybe not sufficient. To increase follow the steps below.

1. SSH to your VPS

2. Check the current maximum no connection limit

echo "show variables like 'max_connections';" | mysql

3. Edit my MySQL file. Remember to backup your /etc/my.cnf prior to that.

vi /etc/my.cnf

4. Add or edit connection limit in the MySQL configuration file

max_connections = 250

5. Save MySQL configuration file

6. Restart mySQL

service mysql restart

7. Confirm the new maximum no connection limit

echo "show variables like 'max_connections';" | mysql