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 […]
Increase size of a tmpfs mounted drive Read More »
Recently I had some problems with a Sphinx search server which was upgraded through apt-get update && apt-get upgrade This caused the Sphinx Storage engine inside my MySQL server fail to work. When doing a search inside Mysql, eg by: select * from dbname.content_index; I got the follwoing error: Error Code: 1286. Unknown table engine
Install MySQL with Sphinx Search Engine support Read More »
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.
Forgot MySQL root password Read More »