Updated: as Blaxter notes, it’s necessary to open a new terminal after editing the bashrc file for the changes to take effect. Also, I’ve replaced the tail -n+2 with the -ss option. Thanks Baron Schwartz!

One of the things I’ve been doing lately is doing some cleanup on my laptop.

There are two things I’m constantly using on the shell:

• Open a project folder
• Connect to a MySQL Database

Bash Functions

I first made a bash function to help me with the projects paths:

function cdp {
case $1 in
  "foo")
    cd /Users/golo/devel/svn/foo/src ;;
  "bar")
    cd /Users/golo/devel/svn/bar/src ;;
  *)
    echo "Options:"
    echo ""
    echo "  foo"
    echo "  bar"
esac
}

I placed that on my /etc/bashrc , so I write:

$ …

One of the ways to import data into MySQL is using the LOAD DATA INFILE. It is a faster method than recovering from a dump, as it’s raw data instead of SQL sentences.

The import time depends on the table engine, for example, MyISAM can be 40 times faster than Innodb. Let’s benchmark this:

Preparation

I’m gonna make some benchmarking using MySQL 5.1.36 (64 bits MacOS X). I’ll need a big table, so I’ll take City from the World Database and create a huge table called “city_huge”:

CREATE TABLE city_huge LIKE CITY;

INSERT INTO city_huge 
    SELECT NULL, name, CountryCode, District, Population FROM city;
# Run this sentence 100 times,
# so city_huge table will be 100 times bigger than city.
# Tip: use a script, temporary table, stored procedure...
# or tell your monkey to do so.

SELECT COUNT(*) FROM …

This month we’ll deliver this season’s last warptalk.

Koke and me will repeat our talk from MySQL Users Conference.

• Title: Testing MySQL cluster with ANSTE
• Time: 18:00 CEST
• Place: Justin.tv
• Updated News: Twitter

Our talks are recorded and uploaded to Vimeo and presentations are available on …

Yesterday, the ebox and warp staff went to Alagon (25km from Zaragoza) to have a very nice BBQ, or should I say WBQ?

We had delicious food, drinks, music, a swimming pool and weather couldn’t be more perfect.

And also we ended up with a new guest in our home

View …

This wenesday I’ll be at the MySQL Conference & Expo 2009 as speaker :):

koke and me will show how ANSTE can be used to test the MySQL Cluster.

ANSTE is a testing tool for complex scenarios. It allows to run tests loading some virtual machines, configuring it’s network interfaces and runing some scripts on them.

Finally we got our proposal approved for the the MySQL conference and Victor and I will be speaking on April 22 about Testing the cluster with ANSTE.

This week we had our first WarpTalks session. Once a month we’ll gather in our meeting room and someone will deliver a talk, workshop or debate about topics considered interesting.

We opened this Monday with two talks. They are in Spanish but you can get the idea.

Introduction to Subversion by Victor Jimenez

Subversion is the RCS we currently use, and the developers know it well enough to do their everyday job, but the not-so technical people at the company have been expecting some training for a while.

Introduccion a Subversion from Jorge Bernal on Vimeo.

10 things you might not know about MySQL by Jorge Bernal (me)

MySQL is the obvious choice when we need a database for our projects, so many of the developers use …

2009 Starts quite interesantly.

This Monday took place the first Warp Talks, a project of training between employees at Warp Networks. The last Monday of the month will take place a new Warp Talk.

koke and me where the first speakers.

I made an introduction to subversion, and he did a talk about 10 things you might not know about MySQL.

Koke took a camera and recorded our talks at the same time they were being broadcasted at justin.tv. Videos are available at vimeo (spanish):

http://www.vimeo.com/tag:warptalks

After my awful Drunken-Blogging experiment, i’m gonna try to write a real post.

This Thursday, Koke and me attended the MySQL Conference at London. Talks were customer oriented, that’s great for me as I’m used to a developer vision of MySQL, and i’ll have to talk to customers in training sessions.

There was some things that everyone was repeating on every talk. Replication, backup, high availability and sacalbility. I’m sure that I’ll be asked about those things while training.

Another interesting thing to know were the MySQL release plans. It’s supposed that 5.1 will be released at the end of this year, and 6.0 at the end of the next. Falcon will be the new storage engine included in 6.0, it’s …