Currently Viewing Posts Tagged log

Lots of favicon.ico requests from Mainland China

I check the Nginx error log file regularly. I noticed that a lot of attempted accesses to favicon.ico coming from mainland China.

They come from different IP addresses and with different User Agents.  Each of these IPs is only doing this, sometimes repeatedly.

They are just waste my server’s time and CPU.  How to stop them or reduce the effect on my VPS.

Continue reading “Lots of favicon.ico requests from Mainland China”

Performance improved by XCache 2.0.0

XCache is a open-source opcode cacher, which means that it accelerates the performance of PHP on servers. It optimizes performance by removing the compilation time of PHP scripts by caching the compiled state of PHP scripts into the shm (RAM) and uses the compiled version straight from the RAM. This will increase the rate of page generation time by up to 5 times as it also optimizes many other aspects of php scripts and reduce serverload.
The XCache has improved my sites performance. Look at the admin page of XCache below.
XCache-admin-page

The XCache Init Time is 2012-10-28 02:41:05. Until now, 2012-10-30 14:59:00, there are 373,367 hits on cache.

Continue reading “Performance improved by XCache 2.0.0”

Install vnstat on Centos at Burst.net to monitor the traffic

The traffic graphic on Burst.net portal is not correct. It is what Burst.net support stuff said. So I would like to install my own traffic monitoring service to track home much I use during the month.

vnStat is the one we are going to go through the installation.

The screen shot below is the report I have for last two weeks.

vnstat0

1) Install vnstat
SSH to VPS

Continue reading “Install vnstat on Centos at Burst.net to monitor the traffic”

The results of PAM-abl

Web, as a wild place, is not a safe playground to me. I have a server, got so many attacking everyday. It is only two small sites running on it.

What can I do? I have to protect myself by my computer skills.

I install and enabled PAM_abl black list function for SSH security.
Now four days passed. Let us see how the result.

pam_abl_ip_blocking

One IP tried 424 times to login.

The other tried more than one thousand times.

I have to say, it is a good tool to protect my SSH server and save a lot of resource.

Continue reading “The results of PAM-abl”

Slow queries log for MySQL

To enable slow query log, it is have to add one line into my.cnf.
I have MySQL installation on a Centos server.
It is MySQL 5.0.22 i686.
Let’s go through the details of setting of it.
Open my.cnf which is located at /etc/
add following under mysqld section.

log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 5
log-queries-not-using-indexes

The key point is to manually create the mysql-slow.log file.

cd /var/log
mkdir mysql
touch mysql-slow.log
chmod mysql.mysql -R /var/log/mysql

Last step is to restart mysql server.

Continue reading “Slow queries log for MySQL”

  • Archives