Author Archives: Xrvel

Sphinx Search Engine for vBulletin 4

Posted on by
3

Sphinx search engine is a free search engine software that supports MySQL, PostgreSQL etc. Sphinx can work on normal script, and vBulletin too.
Why sphinx? With fully configured sphinx search engine, your script can search on large amount of data very very quickly, like a speed of light compared with normal way.

On vBulletin 4, rebuilding search index takes very long time especially if you have lot of posts (more than one million) on your forum. My forum has about 1,5 million of posts. And to rebuild search index of about 10,000 posts, it can take hours. So to rebuild search index of 1,5 million posts, it takes days.
Because rebuilding search index was a painful process for my forum, i was thinking to use sphinx search engine for my vBulletin forum.

So first important point is : if your forum has lot of posts, you’d better to use Sphinx. But if your forum has small amount of posts, you do not need Sphinx search engine.
Continue reading →

MySQL Table “In Use” Repair

Posted on by
Reply

Recently when i optimized some mysql tables from phpmyadmin, some of the tables were “locked” and showed as “in use” on phpmyadmin. The tables could not be used, read, etc. So the script was stopped working.
I have tried to repair / check / analyze from phpmyadmin but i couldn’t repair it.
So i tried to repair the mysql tables from SSH.

Go to your database directory. Usually it is located on
/etc/var/lib/mysql/YOUR_DATABASE_NAME/

So use this command first
cd /etc/var/lib/mysql/YOUR_DATABASE_NAME/

Next, use this command
myisamchk --safe-recover --force YOUR_TABLE_NAME

And the MySQL table should be repaired now.

Use ScrapeBox to Monitor Your Competitor

Posted on by
3

ScrapeBox is one of useful SEO tools. One of its cool feature is you can use it to monitor your competitor’s backlink Gambar Use ScrapeBox to Monitor Your Competitor Image
Backlink is one of important factor on SEO. So by monitoring and knowing where your competitor’s backlinks are, you can try to compete with them and put more backlinks than theirs.

To do this, you can use ScrapeBox add-ons, called “Backlink Checker”. Just load your competitor URLs and ScrapeBox will show you where their backlinks are. Gambar Use ScrapeBox to Monitor Your Competitor Image

Now your next task is getting more backlinks Gambar Use ScrapeBox to Monitor Your Competitor Image