DBT-2 is a TPC-C like OLTP benchmark, and very popular amongst
many MySQL users. It is used by MySQL QA team to test the
stability and performance before release. However, steps to setup
DBT-2 is a little bit messy, and its README files include some
dummy information. So I introduce you these steps below:
1. Download it!
You can download the source code from here: http://osdldbt.sourceforge.net/
2. Required packages
The following perl packages are required to build DBT-2.
Unfortunately, configure script doesn't complain even if they are
missing. Install them using, e.g. CPAN.
shell> sudo cpan Statistics::Descriptive
shell> sudo cpan Test::Parser
shell> sudo cpan Test::Reporter
If you want to make a graph from the output, you have to install
gnuplot in advance. e.g. Ubuntu …
Just a small tip for using Bazaar on OpenSolaris: set the BZR_SSH environment
variable to openssh if you don't have the Python module
Paramiko installed.
For example, in your ~/.bashrc:
export BZR_SSH=openssh
Could be useful if you're pulling MySQL stuff from Launchpad and use
(Open)Solaris. Could also be useful on other Unix-like operating
systems when the default is missing (Bazaar uses Paramiko as
default).
I just bumped into the Sun BluePrints Wiki and I think it is worth a visit. It is a companion to the BluePrints Blog and part of the move towards Self-Published Content at Sun, which increases agility and responsiveness to user's needs.
The Recent Content page lists chronologically the latest changes. The more recent entries are created in Wiki format, while the earlier ones are PDF attachments.
Some of the documents that caught my attention include:
|
• … |
Recently, I came upon Baron Swartz's (xaprb's) great now_usec
UDF:
http://www.xaprb.com/blog/2007/10/30/how-i-built-the-now_usec-udf-for-mysql/
I use an Intel Macbook Pro for my primary development
environment. GCC on OS X has some interesting quirks. Usually to
compile a UDF on GNU/Linux I use the following command
line:
gcc -fPIC -Wall -I/usr/include/mysql -shared -o udf_now_usec.so
udf_now_usec.cc
When I tried to execute the above on my OS X box, I got some
errors:
$ gcc -fPIC -Wall -I../include -shared -o udf_now_usec.so udf_now_usec.cc i686-apple-darwin8-gcc-4.0.1: unrecognized option '-shared' /usr/bin/ld: Undefined symbols: _main ___gxx_personality_v0</b> collect2: ld returned 1 exit status
The …