Posted by Artem Russakovskii on April 2nd, 2008 in
Databases,
Linux,
Programming
Updated: July 8th, 2009
Today I was asked a question about defining custom extensions for vim syntax highlighting such that, for example, vim would know that example.lmx is actually of type xml and apply xml syntax highlighting to it. I know vim already automatically does it not just based on extension but by looking for certain strings inside the text, like <?xml but what if my file doesn't have such strings?
…
Read the rest of this article »
Posted by Artem Russakovskii on March 26th, 2008 in
Databases,
Linux,
Programming,
Technology
Updated: January 4th, 2009
Attention: Apparently since the release of 5.1.25, cluster is packaged separately. I need to do some reading and research first and then update the tutorial with the latest info.
Here are some quick links for now: http://blogs.mysql.com/kaj/2008/05/23/mysql-clusters-improved-release-model/, http://johanandersson.blogspot.com/2008/05/mysql-cluster-62-officially-released.html, http://blogs.sun.com/theaquarium/entry/improved_release_model_for_mysql.
This article contains my notes and detailed instructions on setting up a MySQL cluster. After reading it, you should have…
Read the rest of this article »
Posted by Artem Russakovskii on March 24th, 2008 in
Awesomeness,
Databases,
Linux,
Personal,
Programming,
Technology
Updated: March 26th, 2008
April 14-17th is going to be an exciting time. Why? Because the 2008 MySQL Conference and Expo is going to be held in Santa Clara, CA. Who would want to miss out on a chance to lurk around, let alone talk to, some of the smartest people in the MySQL world? Well, those who don't have at least $1000+, of course. A 3 day…
Read the rest of this article »
Posted by Artem Russakovskii on March 23rd, 2008 in
Linux
Pine is a UNIX command line mail application. So how do you delete all messages in a folder?
The combination is
If after pressing ; you see
1
|
[Command ";" not defined for this screen. Use ? for help]
|
then you don't have a check in the "Enable aggregate command set" settings checkbox. To enable it, go to the…
Read the rest of this article »
Posted by Artem Russakovskii on March 11th, 2008 in
Databases,
Linux,
Programming
Updated: March 18th, 2008
Today Robin Schumacher, MySQL's Director of Product Management, announced that the mysql Falcon storage engine has moved into a beta release stage. Falcon, a new transactional storage engine introduced in mysql 6 (aka 5.2), has been in alpha for years. Other popular storage engines include MyISAM, InnoDB, which Falcon is supposed to challenge (successfully? :-/), and the upcoming…
Read the rest of this article »
Posted by Artem Russakovskii on January 16th, 2008 in
Databases,
Linux,
Programming,
Technology
Updated: March 18th, 2008
"Didn't see that one coming. Their blog contains details to what this could mean for both companies. May as well be one of the most important takeovers of 2008 already!"
read more | digg story
Could this mean that the mysql cluster is finally going to get proper development attention? I don't know but sure as hell hope so. Congratulations to all mysql employees!

Posted by Artem Russakovskii on November 4th, 2007 in
Linux,
Programming
Updated: March 19th, 2008
I don't know about you but I've had a lot of problems making screen work nicely with YaST. Both putty and SecureCRT had major problems displaying YaST's ncurses interface. The screenshots below depict the problem quite clearly. If at this point you don't see anything like this, you are most likely not affected and can go get a beer.


If you…
Read the rest of this article »
Posted by Artem Russakovskii on October 12th, 2007 in
Linux,
Programming
Updated: March 19th, 2008
cpan is a perl module manager. To get into cpan, login as root and type in
Install a module:
Upgrade a module:
Reinstall a module or force install in case of failed tests:
See a list of upgradable modules:
See cpan configuration (that's the letter 'o'):
Update an option in cpan…
Read the rest of this article »
Posted by Artem Russakovskii on October 12th, 2007 in
Databases,
Linux
Updated: July 23rd, 2008
sysbench – Linux test bench. Easy as pie to test CPU, memory, threads, mysql, and disk performance.
Full description is available here: http://sysbench.sourceforge.net/docs/
install mysql, mysql-devel
wget http://superb-west.dl.sourceforge.net/sourceforge/sysbench/sysbench-0.4.8.tar.gz
tar xvzf sysbench*gz
cd sysbench*
./configure && make install
mysql tests
This will run 10 separate consecutive mysql tests using an InnoDB table type, each with 100 mysql threads, doing a total of 1000 various SQL operations…
Read the rest of this article »
Posted by Artem Russakovskii on August 29th, 2007 in
Beer Planet,
Linux,
Programming,
Technology
I've recently installed eAccelerator on the web server that hosts this site and I wanted to share some of my impressions after a few days.
- What does it do? Nobody put it better than the eAccelerator team itself: "eAccelerator is a free open-source PHP accelerator, optimizer, and dynamic content cache. It increases the performance of PHP scripts by caching them in their compiled state, so that the overhead of
…
Read the rest of this article »