This last week was the first time we have this kind event here in Argentina, of course this is a great initiative and a good starting point for next events. My impressions: being the first time that these kind of conferences were done in Argentina I have to say it was great, small but great. [...]

Polystar delivers and supports systems that increase the quality, revenue and customer satisfaction of telecommunication services. Headquarted in Sweden, Polystar helps operators worldwide including Telia, Tele2, Telekom Malysia and T-Mobile to monitor their network performance and improve service levels.

Challenges

• Deliver complete turnkey solutions to customers integrating a database ensuring high performance at scale, while being very easy to use, manage and optimize.
• Enable the implementation of distributed architectures including one database per server while maintaining a low Total Cost of Ownership (TCO).
• Avoid growing database complexity as the volume of mobile data to monitor and analyze drastically increases.

Solution

• Evaluation of several databases and selection of MySQL based on its high performance, manageability, and low TCO.
• The …

What do you think of this piece of C code?

  void foo(long v) {
    unsigned long u;
    unsigned sign;
    if (v < 0) {
      u = -v;
      sign = 1;
    } else {
      u = v;
      sign = 0;
    }
    ...

Seems pretty simple, right? Then what do you think of this output from MySQL:

  mysql> create table t1 (a bigint) as select '-9223372036854775807.5' as a;
  mysql> select * from t1;
  +----------------------+
  | a                    |
  +----------------------+
  | -'..--).0-*(+,))+(0( | 
  +----------------------+

Yes, that is authentic output from older versions of MySQL. Not just the wrong number, the output is complete garbage! This is my all-time favorite MySQL bug#31799. It was caused by code like the above C snippet.

So can you spot what is wrong with the code? Looks pretty simple, does it not? But the title of this post …

Example using a mysql cursor in a stored procedure. Mysql Cursor example DELIMITER $$   DROP PROCEDURE IF EXISTS mysql_cursor_example $$ CREATE PROCEDURE mysql_cursor_example ( IN in_name VARCHAR(255) ) BEGIN -- First we declare all the variables we will need DECLARE l_name VARCHAR(255); -- flag which will be set to true, when cursor reaches end [...]

If you don’t know what HandlerSocket is read Yoshinori Matsunobu’s blog post.

Because I’m starting with a minimum install of CentOS 6.2,  You’ll need to make sure you have a few utilities and development tools installed:

yum install git perl openssl-clients wget telnet lsof  
yum install gcc gcc-c++ libtool make openssl-devel perl-DBI perl-DBD-MySQL.x86_64

Installing the MySQL source

You’ll also need the MySQL source and a few more supporting packages.

wget http://vault.centos.org/6.2/os/Source/SPackages/mysql-5.1.52-1.el6_0.1.src.rpm 
yum install rpm-build gperf readline-devel ncurses-devel time perl-Time-HiRes 
rpm -i …

MySQL Connect is approaching and I started making note of the sessions I am going to want to attend. There are 77 great sessions and the following ten caught my interest. Hopefully I will see you in some of the following:

1. BOF8978 – MySQL Cluster: From Zero to One Billion in Five Easy Steps

   Bernhard Ocklin – Director MySQL Cluster, Oracle
   Andrew Morgan – MySQL Senior Product Manager, Oracle
   Matthew Keep – MySQL Product Manager, Oracle

   Of course it takes more than five steps to scale to more than one billion queries per minute, but the new configuration …

Everyone has their preferred method of communication, which they tend to overuse at the cost of other methods. At MySQL AB, email was preferred in many situations where picking up the phone would have saved loads of work, frustration and distractions. SkySQL Ab as a company is equally distributed across continents and time zones. Not surprisingly, we have inherited some of MySQL's bad habits, and created a set of new habits, good and bad. The purpose of this write-up is to take a step back and reflect upon which tool fits which purpose, focusing on a virtual company with colleagues spanning many time zones.

read more

It's from a log time now that I wanted to share the following stuff, but running time was always against me.. ;-)

I'd say that during last years there were plenty incredible events around MySQL Performance. And one of them is a story about Read-Only performance in MySQL 5.6 -- it's quite fun to tell it now, but, believe me, it's even more fun to live it yourself ;-)) Every important milestone around performance improvement in MySQL was similar to resolve a Detective Story ;-) Probably one day somebody will take a time to write a book about ;-)) But for my part, I'm just sharing what I've found interesting and important..

First of all: why even care about Read-Only performance in MySQL/InnoDB ?.. - Well, except if your database is "write-only", but usually data reads are representing a significant part in OLTP activity. And if your database engine is transactional, the reads from such a database are not "simple …

Get started on MySQL for Beginners training within 24 hours with the newly released MySQL for Beginners Training on Demand. With Training on Demand, you get:

- Trained by top MySQL Instructors

- Access to hands-on practice environment

- Full classroom content available 24/7

- And no travel expenses to worry about

The MySQL for Beginners course covers all the basics and gets you on your way with a solid foundation. This hands-on class covers the fundamentals of SQL and relational databases, using MySQL as a teaching tool.

In addition to the …

The MySQL Cluster engineering team recently ran a live webinar, available now on-demand demonstrating the ClusterJ and ClusterJPA NoSQL APIs for MySQL Cluster, and how these can be used in building real-time, high scale Java-based services that require continuous availability.

Attendees asked a number of great questions during the webinar, and I thought it would be useful to share those here, so others are also able to learn more about the Java NoSQL APIs.

First, a little bit about why we developed these APIs and why they are interesting to Java developers.

ClusterJ and Cluster JPA

ClusterJ is a Java interface to MySQL Cluster that provides either a static or dynamic domain object model, similar to the data model used by JDO, …