PHP / MySQL

Repair and Optimize MySQL databases in SSH

Posted Tue, 10/05/2010 - 12:38pm

SSH repair and optimize all MySQL databases:

/usr/bin/mysqlcheck --repair --all-databases --password

/usr/bin/mysqlcheck --optimize --all-databases --password=xxxxxx

Add new comment

RESOLVED: mysqld won't start

Posted Sun, 06/21/2009 - 7:24pm

In case your mysqld won't work with

# service mysqld restart
or
# service mysqld start
or
# service mysqld stop

do this:

# killall mysqld

followed by:

HOW-TO: Install Eaccelerator (Turck MMCache replacement)

Posted Mon, 05/14/2007 - 8:09pm

Install/Update eaccelerator:

cd /ea
rm -rf ./eaccelerator* 
rm -rf /usr/local/lib/php/extensions/no-debug-non-zts-* 
wget http://downloads.sourceforge.net/project/eaccelerator/eaccelerator/eAccelerator%200.9.6.1/eaccelerator...
tar xvfj eaccelerator-0.9.6.1.tar.bz2
cd eaccelerator-0.9.6.1
export PHP_PREFIX="/usr/local" 
$PHP_PREFIX/bin/phpize 
./configure --enable-eaccelerator=shared --with-php-config=$PHP_PREFIX/bin/php-config 
make
make install
cd /tmp
rm -fr /tmp/eaccelerator
mkdir /tmp/eaccelerator
chmod 0777 /tmp/eaccelerator
vi /usr/local/lib/php.ini

Add/Edit right after "Windows Extensions":
zend_extension="/ea/eaccelerator-0.9.5.3/modules/eaccelerator.so" eaccelerator.shm_size="32"