Optimize MySQL for speed and memory use

October 11th, 2009 Jacken No comments
Jamison Judd

Jamison Judd

I found this great shell script to test your MySQL server. You need to have your MySQL server up and running a while before running the test to get valid data. With all the possible setting variations this is can be a handy tool.

Get MySQL Performance tuner here.

No migration for Google Apps Gmail

September 23rd, 2009 Jacken No comments

Just wasted a good half hour trying to find a migration tool in Google Apps Standard Edition. After a lot of searching, I found out that there is none. Tip to Google. Write this in your guide!

So back to proven trusted tools like IMAPSync

Lenn-Art Tang Band W8-740C subwoofers

September 16th, 2009 Jacken 2 comments
A Tangband W8-740C

Lenn-Art Subwoofer

Last time I ordered some speaker elements from Germany I ordered some extra Tang Band W8-740C subwoofer elements for a later build. I’ve been oogling this design to go with my home-built?ProAc 2.5 clones. Micke, a friend will make the boxes for me, provided I sent him the drawings. What an exellent excuse to try to learn Solidworks. Amazing program. I have designed my own version of the venerable GainClone amplifier with a beefed up power supply and will use two subwoofers in stereo. Nice to not have to build the boxes. Last time when I built the clones the apartment was filled with MDF dust for months.

DNS problems with Snow Leopard 10.6

September 8th, 2009 Jacken 7 comments

I’ve had some bizarre problems with my DNS today. I checked /etc/resolv.conf but everything looked ok. Checked the settings dialog for my network and at first glance, that one seemed ok as well.

Screen shot 2009-09-09 at 00.34.55

But normally there should be a dimmed version of the DHCP assigned values there.

Screen shot 2009-09-09 at 00.35.08

Just select the empty one and press the minus sign. Sneaky little bug there!

Dimmed DNS values

Save your settings and you should be good to go.

Time to get my Squeezebox and Brutefir to work

August 20th, 2009 Jacken 2 comments

I’m going to do the last installations tomorrow. And finally start measuring my listening-room so I can create a DRC setup. I’ve done some experiments, and the sound improvement is amazing! So there’s going to be a lot of sweep sounds in my apartment tomorrow.

Getting Perian 1.1.4 to work Snow Leopard 10.6 to work

August 14th, 2009 Jacken 1 comment

There?s a problem with getting Perian to work in Snow Leopard. But there?s a quick fix outlined here, but If the PreferencePane is installed to only the current user, you need to paste the following into the terminal:

cd
cd Library/PreferencePanes/Perian.prefPane/Contents/Resources/Components
cp Perian.zip ~/Downloads
<code> cp CoreAudio/A52Codec.zip ~/Downloads
cp QuickTime/AC3MovieImport.zip ~/Downloads
cd ~/Downloads
unzip AC3MovieImport.zip
unzip A52Codec.zip
unzip Perian.zip
sudo mv Perian.component/ /Library/QuickTime/
sudo mv AC3MovieImport.component/ /Library/QuickTime/
sudo mv A52Codec.component/ /Library/Audio/Plug-Ins/Components/

Time to try blogging from ipod

June 25th, 2009 Jacken No comments

Well, the iPad version seems to work ok. It’s actually quite nice to be able to write in landscape mode.

Upgrading to Nginx and getting WordPress to work

June 24th, 2009 Jacken 2 comments

So, after doing an upgrade of my Apache installation all my web content stopped working. It continued to give 403 errors. After spending hours changing permissions and checking every little detail I gave up. So I installed Nginx instead. It’s a bit scary to start using a totally new web server software, but why not live dangerously? Anyway, it’s fast! Really fast. The only problem I had was to get all the redirects to work. And I also removed my gallery2 installation and moved the blog to /

Problems

It took longer than I had anticipated, mainly because I had to learn how to set up Nginx, but also because of the trouble of getting answers when searching the net. But here’s my working config (mostly saved for me if I forget :)

server {
    listen   80;
    server_name  www.jackenhack.com
            jackenhack.com;
    keepalive_timeout  5;
    tcp_nodelay        on

    access_log  /var/log/nginx/access.log;
location ~* ^.+\.(xml|jpg|jpeg|gif|png|ico|css|zip|tgz|gz|rar|bz2|doc|xls|exe|pdf|ppt|txt|tar|mid|midi|wav|bmp|rtf|js)$
{
root /var/www/nginx-default;

}

    location / {
        root   /var/www/nginx-default;
        index  index.php index.html index.htm;
gzip            on;
  gzip_http_version 1.0;
  gzip_comp_level 2;
  gzip_proxied any;
  gzip_types      text/plain text/html text/css application/x-javascript text/xml application/xml application/xml+rss text/javascript;

    #include /etc/nginx/wordpress_params.super_cache
    #include /etc/nginx/enable_wordpress;

    # rewrite old blog url
    rewrite ^/blog/(.+)$ /$1 permanent;

# if the requested file exists, return it immediately
if (-f $request_filename) {
break;
}

set $supercache_file '';
set $supercache_uri $request_uri;

if ($request_method = POST) {
set $supercache_uri '';
}

# Using pretty permalinks, so bypass the cache for any query string
if ($query_string) {
set $supercache_uri '';
}

if ($http_cookie ~* "comment_author_|wordpress|wp-postpass_" ) {
set $supercache_uri '';
}

# if we haven't bypassed the cache, specify our supercache file
if ($supercache_uri ~ ^(.+)$) {
set $supercache_file /wp-content/cache/supercache/$http_host/$1index.html;
}

# only rewrite to the supercache file if it actually exists
if (-f $document_root$supercache_file) {
rewrite ^(.*)$ $supercache_file break;
}

# all other requests go to Wordpress
if (!-e $request_filename) {
rewrite . /index.php last;
}

}
# setup for jackeniax
        location /jackeniax {
            root   /var/www/nginx-default/jackeniax;
            index  index.php index.html;

            if (!-f $request_filename) {
                rewrite  ^(.*)$  /jackeniax/index.php?q=$1  last;
                break;
            }

            if (!-d $request_filename) {
                rewrite  ^(.*)$  /jackeniax/index.php?q=$1  last;
                break;
            }

        }

        location ~ \.php$ {
                fastcgi_pass   127.0.0.1:9000;
                fastcgi_index  index.php;
                fastcgi_param  SCRIPT_FILENAME  /var/www/nginx-default$fastcgi_script_name;
                include        /etc/nginx/fastcgi_params;
        }

    # deny access to .htaccess files, if Apache's document root
        # concurs with nginx's one
        #
        location ~ /\.ht {
                deny  all;
        }

}

Categories: web Tags: , , ,