Setting MySQL innodb_buffer_pool_size

I was confused how big i should set my “innodb_buffer_pool_size” value. Then i find this post in stackexchange. I can run this query to get what is the suggestion of “innodb_buffer_pool_size” value. SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM (SELECT SUM(data_length+index_length) Total_InnoDB_Bytes FROM information_schema.tables WHERE engine=’InnoDB’) A; The result will be in GB.

How to Install PECL Memcache in WHM / CentOS

You can run these commands to install PECL memcache (not memcached). However, this memcache will work with memcached. wget tar xvfz memcache-3.0.8.tgz cd memcache-3.0.8 phpize ./configure make make install Take note of the php extensions directory that memcache is installed in. Mine is: /usr/local/lib/php/extensions/no-debug-non-zts-20020429/ Then add this line to your php.ini extension=”/usr/local/lib/php/extensions/no-debug-non-zts-20020429/”

How to Install ConfigServer Security & Firewall (CSF) in WHM

To install ConfigServer Security & Firewall (CSF) in WHM, please run this commands in your SSH terminal one by one. wget tar -xzf csf.tgz cd csf sh After it completes, there is a new menu in WHM which is under “Plugins” category, named “ConfigServer Security & Firewall”. 🙂