How to Redirect a Directory Using Htaccess

There is occassion where you want to do a silent redirect (not a 301 redirect) from a directory to another directory.
Doing silent redirect will make browser to assume that this redirection is a brand new URL, not like 301 redirect which tells browser to open (redirected to) another URL.

We can use htaccess to do this 🙂
Continue reading “How to Redirect a Directory Using Htaccess”

Redirect Single URL with Htaccess

Sometimes you want to change some of your URL. For example you renamed your old html file. Or you have removed some of your old files and you want to redirect them to a new URL.

But maybe other websites have linked to your old URL. You can’t contact them to change the URL, or you are too lazy to contact them, or maybe there are just so many backlinks pointed to the old URL so it is quite hard to change them all.

To avoid losing link juice from other websites, we must redirect the old URL to the new URL, with permanent redirection.
Continue reading “Redirect Single URL with Htaccess”

Integrate reCAPTCHA v2 Into Pligg

Pligg supports some CAPTCHA, including Solve Media, and old reCAPTCHA.
Now i will write how to use reCAPTCHA v2 (click captcha) into Pligg.

First, you must get Google reCAPTCHA keys.
Second, open your Pligg admin, set the site & secret key under “CAPTCHA” sub menu and click “configure” next to reCAPTCHA.
Continue reading “Integrate reCAPTCHA v2 Into Pligg”

Regularly Runs MySQL FLUSH QUERY CACHE

In some situation, like suggested in some mysql optimization script, you may want to regularly run “FLUSH QUERY CACHE”.

First, open your terminal and try to run this command :

mysql -e 'FLUSH QUERY CACHE'

If there is no error, you can add that command in your cron job, such as this command to run it every 10 minutes :

*/10 * * * * mysql -e 'FLUSH QUERY CACHE'

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.