posidev.com

Running Sysbench 0.4.12 on Ubuntu 9.04

ivanov — Sat, 17 Oct 2009 10:14:57 PDT

I decided to try benchmarking MySQL 5 with Sysbench 0.4.12 but as it turned out it was not so easy task.First I followed the steps as described by the dbadojo blog: Download last version of Sysbench tar -xzvf sysbench-0.4.XX.tar.gz cd sysbench-0.4.XX ./configure && make && make install But the compiling wasn’t done and I get a strange error: ../libtool: line 2412: [...] Related posts:

Tunning MySQL InnoDB performance

ivanov — Tue, 30 Jun 2009 08:04:03 PDT

Tunning MySQL InnoDB storage engine is not an easy task. It’s more like a game where you set mini goals and then try to find the right value and achieve them. Playing with the InnoDB variables is an art where you have to check your performance results each time you change a configuration parameter. [...] Related posts:

EXSLT

ivanov — Mon, 22 Jun 2009 09:49:24 PDT

Today I needed to do some dateTime formatting in XSLT 1.0 and I found that it was not an easy task. After digging in Google I found really nice dateTime functions but all of them were available in XSLT 2.0 .Of course I am using MSXML 6.0 coming with .NET and that’s the last version. [...] Related posts:

Discover XAML and WPF

Set ulimit parameters on ubuntu

ivanov — Thu, 04 Jun 2009 02:34:10 PDT

By default the number of open files pro user in Ubuntu 8.04 is 1024. In my case this number was too small so I have to increase it.This is done with the ulimit command: $ulimit -a # see all the kernel parameters $ulimit -n #see the number of open files $ulimit -n 9000 # set the number open [...] Related posts:

Benchmarking with DBT2

ivanov — Sun, 10 May 2009 06:36:24 PDT

DBT2 is an open source benchmark like TPC-C for databases (mainly MySQL and PostgreSql ). The goal of this post is to list some links on DBT2 usage: DBT2 report example DBT2 scores Jenny Chen’s Weblog on Performance DBT2 Core Dev Team MySQL Cluster Database 7: Performance Benchmark PostgreSql Git repository with all materials PostgreSQL Portland Performance Practice Project – [...] Related posts: