Hostgator Banned my account hosted eSyndicat script

[John Yap]

I was just received an email from Hostgator support, mentioned that they disabled my database running the eSydicate script because it consumes a lot of server resources. This is the log file they sent..

root@gator148 [~]# top -c
top - 16:37:49 up 73 days, 11:16, 1 user, load average: 14.04, 13.76, 12.37
Tasks: 223 total, 28 running, 195 sleeping, 0 stopped, 0 zombie
Cpu(s): 2.2% us, 2.3% sy, 8.7% ni, 85.8% id, 0.9% wa, 0.0% hi, 0.1% si
Mem: 4143516k total, 3889168k used, 254348k free, 287124k buffers
Swap: 2618552k total, 112k used, 2618440k free, 2606956k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
27740 mysql 15 0 451m 301m 4356 S 123 7.4 10458:54 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/g

| 8576354 | wh79_admin | localhost | wh79_directory | Sleep | 0 | | |
| 8576355 | wh79_admin | localhost | wh79_directory | Query | 0 | Copying to tmp table | SELECT *, t1.`title` `title` FROM `dir_links` t1 LEFT JOIN `dir_link_categories` t2 ON t2.`id_link` |
| 8576356 | wh79_admin | localhost | wh79_directory | Sleep | 0 | | |
| 8576362 | wh79_admin | localhost | wh79_directory | Query | 0 | Copying to tmp table | SELECT *, t1.`title` `title` FROM `dir_links` t1 LEFT JOIN `dir_link_categories` t2 ON t2.`id_link` |
| 8576363 | wh79_admin | localhost | wh79_directory | Query | 0 | Copying to tmp table | SELECT *, t1.`title` `title` FROM `dir_links` t1 LEFT JOIN `dir_link_categories` t2 ON t2.`id_link` |

I am now wondering is the script consume a lot of server resources or Hostgator problems, or anything else???/?

Please advise...

John

[Bakyt N.]

John Yap
Hello, there may be several possible reasons of it.

1. There is a memory leakage either in PHP or MySQL
2. You've tremendous amount of categories and links (over than a million)
3. Very very high traffic
4. Malicious user making some operations on their server
5. something else.

Could you send me PM with the following information

1. version of PHP (also if it is installed as CGI or as apache module)
2. version of MySQL
3. How much links and categories do you have
4. how long do you run your directory
5. some traffic information (in general...is very big... may be pagerank or alexa traffic)
6. the version of eSyndiCat
7. could you provide us with SQL long queries log.

Thank you!