Support Analyst’s Talk

errorlog.php in forumdata does recorded mysql error. however it is not complete,

so I have to find mysql error log file and check what went wrong with the database.

also in backend of database, under system tools, it has system error record, which bring the details from errorlog.php.

the last error shows:

MySQL         07-5-30 10:24     forumdisplay.php : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘-3, 30′ at line 5 - SELECT t.*, p.rate FROM cdb_threads t LEFT JOIN cdb_posts p USING(tid, dateline) WHER …

so after sleep , I got to find check the details of each wrong query from mysql error log, though i don’t even know where the mysql error log is.

got eaccelerator installed

http://www.shell-tips.com/2006/11/25/fine-tuning-a-linux-apache-mysql-php-lamp-server/
http://www.chedong.com/blog/archives/001154.html
http://www.minatica.be/archive/index.php/t-28693.html
http://eaccelerator.net/wiki/InstallFromSource

got problem of phpize
command not found

should install

Zend Optimizer 3.2.2 is incompatible with eAccelerator 0.9.4 in Unknown on line 0

Address already in use: make_sock: could not bind to address - Apache - HTTPD Error

problem solved on http://frankmash.blogspot.com/2005/11/address-already-in-use-makesock-could.html

php-v check whether eaccelerator is installed

install php -del using yum

check /etc/sysctl.conf files

compare
http://forums.theplanet.com/index.php?s=fc512994fb0de9b9ae9de4fb5744a696&showtopic=48880&st=0
and

http://www.shell-tips.com/2006/11/25/fine-tuning-a-linux-apache-mysql-php-lamp-server/

change some values.

modules path:

/usr/lib/php/modules/

check two setting of eaccelerator.ini, the first one doesn’t work , second one works.

zend_extension=”/usr/lib/php/modules/eaccelerator.so”
eaccelerator.shm_size=”32″
eaccelerator.cache_dir=”/tmp/eaccelerator”
eaccelerator.enable=”1″
eaccelerator.optimizer=”1″
eaccelerator.check_mtime=”0″
eaccelerator.debug=”0″
eaccelerator.filter=”"
eaccelerator.shm_max=”0″
eaccelerator.shm_ttl=”3600″
eaccelerator.shm_prune_period=”1″
eaccelerator.shm_only=”0″
eaccelerator.compress=”1″
eaccelerator.compress_level=”9″
eaccelerator.keys = “shm_and_disk”
eaccelerator.sessions = “shm_and_disk”
eaccelerator.content = “shm_and_disk”

zend_extension=”/usr/lib/php/modules/eaccelerator.so”
eaccelerator.shm_size=”16″
eaccelerator.cache_dir=”/tmp/eaccelerator”
eaccelerator.enable=”1″
eaccelerator.optimizer=”1″
eaccelerator.check_mtime=”1″
eaccelerator.debug=”0″
eaccelerator.filter=”"
eaccelerator.shm_max=”0″
eaccelerator.shm_ttl=”0″
eaccelerator.shm_prune_period=”0″
eaccelerator.shm_only=”0″
eaccelerator.compress=”1″
eaccelerator.compress_level=”9″