Planet MySQL

Taxi rides and packed rooms at Athens Open Source Conference

+0

-0

posted by Giuseppe Maxia on Thu 12 Mar 2009 14:03 UTC
Tags:

(edit) mysql, conference, sun, 5.1, athens, greece

I arrived in Athens shortly before midnight. An unusual sight. Most of the taxi drivers in the queue are female. My driver is a middle aged woman wearing a torn leather jacket and with no understanding of English beyond numbers. She said "yes. Liberian hotel", and she adds the name of a mysterious location that I don't understand. I show her the hotel name and address, written in both Latin and Greek alphabet. "Yes. Iberian hotel. I know where." "Not Iberian - I say patiently, pointing at the hotel name on the paper - Imperial.
She says yes, and off we go.
After a minute she fishes a cell phone from her jacket, and asks something. It's a flurry of incomprehensible Greek, but the hotel name I hear very clearly "yadda yadda yadda Liberia hotel yadda yadda". I lean forward and I repeat "Not Liberia. Imperial". "yes, she says. Iberia".
I tell her to stop the

[Read more...]

FOSDEM 2009 - Boosting performance with MySQL 5.1 partitions

+0

-0

posted by Giuseppe Maxia on Sun 08 Feb 2009 21:43 UTC
Tags:

(edit) mysql, sun, performance, partitioning, 5.1, partitions

The MySQL Developers Room at FOSDEM was a success. There was a full room (about 80 seats, and many sitting on the floor) throughout the day. We started at 9am with a talk on PBXT, and ended at 17:00. My talk had a large audience and was very well received.

The enthusiasm was quite high also because of a stunt I did during the presentation. It was a creative way of explaining the difference between physical and logical partitioning. I will repeat this stunt at the MySQL Users Conference, during my Tutorial on Partitioning.
Those who were

+0

-0

posted by Giuseppe Maxia on Sun 08 Feb 2009 13:43 UTC
Tags:

(edit) mysql, sun, performance, partitioning, 5.1, partitions

The MySQL Developers Room at FOSDEM was a success. There was a full room (about 80 seats, and many sitting on the floor) throughout the day. We started at 9am with a talk on PBXT, and ended at 17:00. My talk had a large audience and was very well received.

The enthusiasm was quite high also because of a stunt I did during the presentation. It was a creative way of explaining the difference between physical and logical partitioning. I will repeat this stunt at the MySQL Users Conference, during my Tutorial on Partitioning.
Those who

+0

-0

posted by Giuseppe Maxia on Sun 08 Feb 2009 13:43 UTC
Tags:

(edit) mysql, sun, performance, partitioning, 5.1, partitions

The MySQL Developers Room at FOSDEM was a success. There was a full room (about 80 seats, and many sitting on the floor) throughout the day. We started at 9am with a talk on PBXT, and ended at 17:00. My talk had a large audience and was very well received.

The enthusiasm was quite high also because of a stunt I did during the presentation. It was a creative way of explaining the difference between physical and logical partitioning. I will repeat this stunt at the MySQL Users Conference, during my Tutorial on Partitioning.
Those who

[Read more...]

Q&A on MySQL 5.1

+0

-0

posted by Giuseppe Maxia on Sun 04 Jan 2009 16:35 UTC
Tags:

(edit) mysql, Replication, Events, Presentation, partitioning, 5.1, RBR, logs, microsecond, slow, sheeri

Listening to Sheeri's presentation on MySQL 5.1, I saw that there are a few questions left unanswered. I am listing here some of the questions that I found interesting, plus a few from an early webinar on the same topic.

Q: does Partitioning physically split data?A: No. Some engines (MyISAM, Archive) do a physical split, but this is not necessary, as you see if you apply partitioning to a InnoDB table. Partitioning is a logical split of data, for easy retrieval. It is completely transparent to the user.Q: Can you set partitions to different servers?A: No. Partitions are logical parts of one table within one server. Partitioning through the Federated engine is not supported.Q: How efficient are Row-Based Replication operations compared to Statement based

[Read more...]

New in MySQL 5.1: Sheeri’s Presentation

+0

-0

posted by Sheeri K. Cabral on Fri 02 Jan 2009 21:10 UTC
Tags:

(edit) mysql, bdb, metadata, storage engine, release, api, partitioning, stored procedure, plugin, partition, log, 5.1, general log, information_schema, federated, new release, Stored function, logs, version, isam, query log, slow query, stored routine

In a nutshell: What’s New in MySQL 5.1.

Release notes: Changes in release 5.1.x (Production).

And yes, very early on (at about two minutes in), I talk about my take on Monty’s controversial post at Oops, we did it again.

To play the video directly, go to http://technocation.org/node/663/play. To download the 146 Mb video to your computer for offline playback, go to http://technocation.org/node/663/download. The slides can be downloaded as a

+0

-0

posted by Giuseppe Maxia on Tue 09 Dec 2008 08:42 UTC
Tags:

(edit) mysql, conference, sun, uc2009, 5.1

The approvals are coming. I will be speaking at the MySQL Users Conference 2009.
Using the event scheduler. The friendly behind-the-scenes helper. My co-speaker will be none other than Andrey Hristov, the designer and implementer of the Event scheduler, one of the main features of MySQL 5.1.

What's going on in MySQL land?

+0

-0

posted by Giuseppe Maxia on Mon 08 Dec 2008 15:37 UTC
Tags:

(edit) mysql, bugs, 5.1, ga

Enough of one-sided stories. Let's see a different angle of MySQL 5.1.

First, let me thank my colleague Chris Powers for taking a stand in defense of the management. But saying "everyone does so" is not a good explanation. The truth is much more complex and requires some narrative.

MySQL 5.1 didn't start on the right foot. The effort to produce its features was underestimated, mostly because, at the time when it was designed, the company was still unearthing the architectural bugs that were haunting MySQL 5.0.

MySQL 5.0 was GA in October 2005. One month later, MySQL 5.1 started its alpha stage, while a rain of bugs fell on the freshly released server.

[Read more...]

MySQL 5.1 for impatient Italians

+0

-0

posted by Giuseppe Maxia on Sun 07 Dec 2008 15:37 UTC
Tags:

(edit) mysql, 5.1, ga, Italian

I have just started a blog in Italian. Although Italian is my mother tongue, most of my technical writing is in English. Since my tasks are more widespread than a single country, it was easier and simpler to write in English straight away.

After Sun acquisition, the MySQL presence in Italy is growing, and then it makes sense to employ my birth speaking abilities to spread the word in my country.

Today, thanks to a convoluted introduction, set in motion by Kaj and Google Translate, I started contributing to Giuseppe Guerrasio's blog, pettinix.org, with a post on

+0

-0

posted by Giuseppe Maxia on Mon 01 Dec 2008 15:55 UTC
Tags:

(edit) mysql, perl, partitioning, usability, 5.1

I talked several times about partitioning usability. In my many tests of partitioning I found myself in need of generating list of partitions for a given range.
I made the Partition Helper to scratch this particular itch, i.e. making partitions reasonably quickly and without thinking too much.
The Partition Helper is a Perl script that converts some simple options into lots of

[Read more...]

Monty Rants or Yet Another Case Of Developers vs Users

+0

-0

posted by Amelia on Mon 01 Dec 2008 09:30 UTC
Tags:

(edit) mysql, release, partitioning, Monty, 5.1

I saw Monty's latest rant and I told myself "here we go again." I blogged before about deaf developers, and here's another symptom of the same disease.
This is another case of a developer, a brilliant one, mind you, one of the brightest in the open source arena, but a developer nonetheless, who has a non-user oriented mindset and is inflicting his view on the users.
I will stay clear of the reasons. Why the co-founder of MySQL decides to spoil the party on release day and ambushes his colleagues with a truckload of blame is beyond my understanding.
What concerns me is the patronizing plea that Monty uses against the users. "Don't use MySQL 5.1"? Really? What about the

[Read more...]

Quality of 5.1 GA release

+0

-0

posted by Ryan Thiessen on Sun 30 Nov 2008 01:17 UTC
Tags:

(edit) Uncategorized, bugs, partitioning, Monty, 5.0, 5.1, ga, RBR, release model

With all due respect to Monty (and I mean that — much respect is due), I have some serious issues with his portrayal of the 5.1 release. I hate to make my first entry on Planet MySQL about a controversy, but he encouraged people to blog about their experience with 5.1, so that’s what I’ll do here.

Overall Quality

As a long time user, I am very confident that the quality of 5.1 GA far exceeds that of the initial 5.0 GA release (5.0.15). In fact, I would go further and suggest that the MySQL organization has if anything been too conservative about declaring 5.1 GA.

It’s obviously true that there are still many bugs open. However no software is bug free, especially not those with codebase as large as MySQL. So the question is not if they are bug free,

[Read more...]

MySQL 5.1-GA released

+0

-0

posted by The Aquarium on Thu 27 Nov 2008 11:00 UTC
Tags:

(edit) mysql, sun, release, 5.1, ga

MySQL, the most popular open source database, releases today, November 27, 2008, its version 5.1 GA (General Availability). Downloads are available for all operating systems.

Version 5.1 introduces several enhancements to the already rich set of features. Most notable are partitioning, row based replication, the event scheduler, a new plugin infrastructure, and

[Read more...]

MySQL 5.1-GA is available

+0

-0

posted by Giuseppe Maxia on Thu 27 Nov 2008 10:14 UTC
Tags:

(edit) mysql, sun, 5.1, ga

MySQL 5.1 finally RELEASED!

MySQL 5.1 GA is now available for download.

The time has come. MySQL 5.1 is ready for production use.

In case you weren't paying attention while it it was still under development, here's what you get:

Better performance with partitioning
Easy manageability with the event scheduler
Improved Plugin interface

[Read more...]

Seeding to the mirrors

+0

-0

posted by Giuseppe Maxia on Tue 25 Nov 2008 23:37 UTC
Tags:

(edit) mysql, sun, release, 5.1

If you hear a distant rumble in the air, it could be either Dups testing his new mountaineering gear, or, more likely, MySQL 5.1-GA seeding to the mirrors.

We promised that it would come soon, and it's coming. All internal QA automated tests were passed, a batch of additional manual tests with the packaged binaries (called "smoke tests" internally) were performed to make sure that no embarrassing errors were left, and now the train of bits is traveling to the mirrors. Once the mirrors are loaded, expect the announcement, within a few days.

MySQL 5.1-GA is coming

+0

-0

posted by Giuseppe Maxia on Tue 18 Nov 2008 09:00 UTC
Tags:

(edit) mysql, sun, 5.1, ga

Sheeri has already commented on this, but I want to stress that MySQL 5.1.30 will be GA by December 6th, 2008.

Using the event scheduler to purge the process list

+0

-0

posted by Giuseppe Maxia on Mon 06 Oct 2008 05:00 UTC
Tags:

(edit) mysql, Events, DBA, 5.1, purge

Two of the most common tasks for database administrators are cleaning the process list from unresponsive queries and remove idle connections that are filling the connection pool.
Both tasks are related to poor usage of the database. In a perfect world, users would only run queries designed, tested, and benchmarked by the DBA or the project manager, and the application servers would never allocate more connections than planned.
But users are human, and an unpredictable amount of unplanned events can happen everywhere. When I was consulting, the above cases were quite common.
Before MySQL 5.1, the only method to clean up the process list was by hand, or using a cron job to do it from

[Read more...]

Is the Federated engine useful to you?

+0

-0

posted by Giuseppe Maxia on Mon 06 Oct 2008 01:00 UTC
Tags:

(edit) mysql, 5.1, federated

Followers of my blogs and talks know that I am partial to the Federated engine. Not much as a normal way of storing data, but more as an auxiliary device to create innovative schemes.
A few years ago I wrote an article, Federated: the missing manual where I listed most of the gotchas that you can meet when using the Federated engine. This article alone would be enough to discourage you from using Federated in production. If you attempt to use a Federated table like a normal one, your server will suffer, and possibly crash.

Add the sad fact that the Federated engine is

[Read more...]

MySQL Use case Competition - When theory meets practice

+0

-0

posted by The Aquarium on Fri 12 Sep 2008 17:00 UTC
Tags:

(edit) mysql, Features, 5.1, Competition, users, feedback

MySQL 5.1 is almost ready for prime time, but in the meantime some brave users have already started putting it to work in production environment.

MySQL wants to hear from these intrepid souls. The MySQL 5.1 use Case competition is under way. We want feedback from users who have found a practical usage for 5.1 features, and also from the ones who have met usability challenges.

Two articles have already been published from the competition submissions. One showing

[Read more...]

A 5.1 QEP nicety - Using join buffer

+0

-0

posted by Ronald Bradford on Wed 27 Aug 2008 17:56 UTC
Tags:

(edit) mysql, General, Databases, Professional, explain, 5.1, QEP

I was surprised to find yesterday when using MySQL 5.1.26-rc with a client I’m recommending 5.1 to, some information not seen in the EXPLAIN plan before while reviewing SQL Statements.

Using join buffer

+----+-------------+-------+--------+---------------+--------------+---------+------------------------+-------+----------------------------------------------+
| id | select_type | table | type   | possible_keys | key          | key_len | ref                    | rows  | Extra                                        |
+----+-------------+-------+--------+---------------+--------------+---------+------------------------+-------+----------------------------------------------+
|  1 | SIMPLE      | lr    | ALL    | NULL          | NULL         | NULL    | NULL                   |  1084 | Using where; Using temporary; Using filesort |
|  1 | SIMPLE

[Read more...]

Discover MySQL 5.1, Italian Webinar

+0

-0

posted by Luca Olivari on Fri 08 Aug 2008 13:17 UTC
Tags:

(edit) mysql, 5.1

On Wednesday, September 17 there will be a web based seminar on MySQL 5.1.

Seminar will be in Italian and anyone who is interested is invited to join us!

You can find details here. (http://www-it.mysql.com/news-and-events/web-seminars/display-185.html)

If you are a database administrator or a developer and you are courious about new features coming with MySQL 5.1 then this is the right webinar to attend. In the meantime, to better understand MySQL 5.1, take have a look at "Inside MySQL 5.1" (http://www.mysql.com/why-mysql/white-papers/whatsnew-mysql-51.php) white paper.

See you soon!

Discover MySQL 5.1, Italian Webinar

+0

-0

posted by Luca Olivari on Fri 08 Aug 2008 06:17 UTC
Tags:

(edit) mysql, 5.1

On Wednesday, September 17 there will be a web based seminar on MySQL 5.1.

Seminar will be in Italian and anyone who is interested is invited to join us!

You can find details here. (http://www-it.mysql.com/news-and-events/web-seminars/display-185.html)

If you are a database administrator or a developer and you are courious about new features coming with MySQL 5.1 then this is the right webinar to attend. In the meantime, to better understand MySQL 5.1, take have a look at "Inside MySQL 5.1" (http://www.mysql.com/why-mysql/white-papers/whatsnew-mysql-51.php) white paper.

See you soon!

Discover MySQL 5.1, Italian Webinar

+0

-0

posted by Luca Olivari on Fri 08 Aug 2008 06:17 UTC
Tags:

(edit) mysql, 5.1

On Wednesday, September 17 there will be a web based seminar on MySQL 5.1.

Seminar will be in Italian and anyone who is interested is invited to join us!

You can find details here. (http://www-it.mysql.com/news-and-events/web-seminars/display-185.html)

If you are a database administrator or a developer and you are courious about new features coming with MySQL 5.1 then this is the right webinar to attend. In the meantime, to better understand MySQL 5.1, take have a look at "Inside MySQL 5.1" (http://www.mysql.com/why-mysql/white-papers/whatsnew-mysql-51.php) white paper.

See you soon!

Some quirks of circular and row-based replication

+0

-0

posted by Giuseppe Maxia on Mon 21 Jul 2008 13:30 UTC
Tags:

(edit) mysql, Replication, 5.1

One of the new features introduced by MySQL 5.1 is row-based replication.

Unlike the classic statement-based replication, used in MySQL up to version 5.0, row-based replication transfers the data instead of the statement used to create it.

If you want to have a taste of row-based replication, you can do some experiments with MySQL Sandbox.

First, we create a sandbox of circular replication with MySQL 5.0

./make_replication_sandbox --topology=circular --how_many_nodes=3 \
/path/to/mysql-5.0.51a-YOUR_OS.tar.gz

cd $HOME/sandboxes/rcsandbox_5.0.51
./n1 -e "create table test.t1(i int)"
./n3 -e "insert into test.t1 values (@@server_id)"
./use_all "select * from test.t1"
# server: 1:
i
101
# server: 2:
i
102
# server: 3:
i
103

[Read more...]

Search

Profile

Top Voted (Last Week)

Top Voted (Last Month)

MySQL Links

Top 20 Most Active Authors

Oracle MySQL Blogs

Top 10 Vendor Blogs