Increase size of a tmpfs mounted drive

When you are using a tmpfs drive to speed up certain files/folders (eg var/cache from a Magento webshop), and your assigned amount of memory is too small, you can easily increase this by doing  the following:

Modify your tmpfs mount in /etc/fstab to look something like this: (let’s say that I’ve changed the size of 64M to 128M

You can then remount the tmpfs drive by typing

To verify, simply type

Note: Be careful not too increase it too much! Your system will deadlock since the Out-Of-Memory handler can not free up that space if needed

Install MySQL with Sphinx Search Engine support

Recently I had some problems with a Sphinx search server which was upgraded through

This caused the Sphinx Storage engine inside my MySQL server fail to work.

When doing a search inside Mysql, eg by:

I got the follwoing error:

Also, when i was looking inside MySQL, to show the Engines, did not see any Sphinx engine active:

After searching my google friend, I never really found a straightforward solution to this problem. That’s why I bundled all steps I had to take to fix this problem.

I know my Shpinx was installed by enabling the from within MySQL, but then i got this error:

Time to redo Sphinx – MySQL integration it seems…. This is because your sphinx plugin is build on the installed release version of MySQL :'(

These are the steps you need to perform to do this:

1. Look up the current installed version of MySQL

It seems that i have MySQL 5.1.63 installed on this system.

2. Download the MySQL source for THIS version and also the latest Sphinx version from the site

I got mine as follows:

Extract the archives

Copy the mysqlse directory from sphinx to mysql engine directory from the sources:

Build your sphinx files by:

Your newly created files can now be copied to the mysql live instyalltion directory:

* You night need some pre-requisits to perform this:


But 1st check your plugin dir details in


or /etc/mysql/my.cnf

Time to load your sphinx plugin :



Forgot MySQL root password

I you forgot your MySQL root password, you can recover MySQL database server password with following five easy steps.

  • Stop the MySQL server process.
  • Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password.
  • Connect to mysql server as the root user.
  • Setup new mysql root account password i.e. reset mysql password.
  • Exit and restart the MySQL server.

Here are commands you need to type for each step (login as the root user):

  • Stop mysql service
  • Start to MySQL server without password:
  • Connect to mysql server using mysql client:
  • Setup new MySQL root user password
  • Stop MySQL Server:
  • Start MySQL server and test it