Storage engines for MySQL

MySQL has a lot of storage engines. TokuDB is one of them, very fast (closed source)

Check out this post from mysqlperformanceblog.com: Countless storage engines

MySQL tuning guide

For the Dutch speaking: Trisco has released a small MySQL tuning guide. Many people just leave their MySQL installation standard without tweaking the parameters for their own server.

Trisco MySQL tuning

DQL Query: Select repeating attributes on one row

You’ve probably experienced it before: you’re querying an object and are selecting repeating attributes with DQL and what happens? You’ll get a row for each entry of a repeating attribute.

This is actually very simple to solve: select r_object_id in your query

select r_object_id, single_attribute, repeating_attribute from custom_type

Restart Apache with SSH access

If you need to restart Apache on your webserver and you only have SSH access:

• SSH to your server
• Login
• Enter the followig command and press enter: /etc/init.d/apache2 try-restart

Setting up your own nameserver with Plesk

If you have plesk installed on a server, it’s easy to use this server as your own nameserver.

• Create your domain in plesk
• Set up physical hosting for that domain and create A records for ns1 and ns2.domainname.com (use an additional ip for ns2)
• Click server – DNS and remove the old nameservers, add NS records for ns1 and ns2.domainname.com and remove the <IP>/24 record

That’s all