Entries by olof

innodb_file_per_table for existing MySQL database

So you want to toggle innodb_file_per_table on for your existing MySQL database? This is a step by step guide explaining how to do just that. Should I really enable innodb_file_per_table? Some people prefer it on: I do http://www.mysqlperformanceblog.com/2007/11/01/innodb-performance-optimization-basics/ http://code.openark.org/blog/mysql/reasons-to-use-innodb_file_per_table https://tools.percona.com/wizard Some people prefer it off: http://umangg.blogspot.se/2010/02/innodbfilepertable.html Other Articles Other people have already written articles on […]

Convert MyISAM tables to InnoDB

Did you know that InnoDB replaces MyISAM as the default storage engine since MySQL 5.5.5? For this reason you may want to convert most (if not all) of your current MyISAM tables to InnoDB. WordPress does for example make use of the default storage engine. That means old WordPress installations will make use of MyISAM […]

Backups for your linux server

In this guide I describe how to setup backups for your Linux server. We will backup both locally and remotely for extra security. We will backup… MySQL-databases using automysqlbackup. Normal files using rdiff-backup. Special large folders per weekday using rsync. To a remote server using rsync. Setting up the folder structure We start out with […]

Adding a new storage-device

This guide covers how to add a new storage device (such as a platter or a solid state drive) to your Linux machine. All work is done from the command-line. Selecting the right storage device This guide does not cover selecting the right model or kind of storage device. Plugging the device into the computer […]

Bukkit read timed out

Are you perhaps familiar with the two phrases: read timed out connection reset Since recently I have become quiet familiar with them myself and in this post I will describe how to get rid of them. Reason 1 – Rouge plugin Reason Description Minecraft is mainly single-threaded. The main thread has a formal name when […]

Searching for bukkit memory leaks

In this post I will describe how to search for memory leaks in your bukkit minecraft SMP server. Getting a heap dump The first step is to obtain a java heap dump to inspect. This is a nice article on the subject: http://blog.emptyway.com/2007/04/02/finding-memory-leaks-in-java-apps/ That article describes some different ways to obtain a heap dump. If […]

Persistent ramdisk with tmpfs and rsync

Minecraft reads and writes a lot from disk. In order to speed this up we can store the files in memory instead. If you google “minecraft tmpfs” you will find a lot of info on this. The main issue is that ramdisks created using tmpfs are temporary. The content is wiped on a system reboot. […]

Quick link to edit the hosts file on windows 7

If you edit your hosts-file often it can be practical to have a shortcut that opens the file in a texteditor. This is how you would create such a shortcut on windows 7: Create a normal shortcut to the program notetad on your desktop. Edit the target of the link by adding “%SystemRoot%\system32\drivers\etc\hosts” at the […]

Creating 301 redirects between many pairs of URLs

I recently upgraded a website. The website consisted of static html documents and some simple php scripts. I transformed it into a wordpress blog. In this process every url was changed. In order to keep the pagerank and not break any inlinks I created 301 redirects between them. If there had been an obvious pattern […]

Reading browser saved passwords

Assume you forgot you gmail password but you allowed the browser to remember it for you. You can still log in as the browser fills out the password for you, but you can not find out what the password is as all you see is some stars or dots. The situation is cool for now, […]