Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 54

Displaying posts with tag: 5.1 (reset)

Taxi rides and packed rooms at Athens Open Source Conference
+0 Vote Up -0Vote Down
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
Employee +0 Vote Up -0Vote Down

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

  [Read more...]
FOSDEM 2009 - Boosting performance with MySQL 5.1 partitions
Employee +0 Vote Up -0Vote Down

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...]
FOSDEM 2009 - Boosting performance with MySQL 5.1 partitions
Employee +0 Vote Up -0Vote Down

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 Vote Up -0Vote Down
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 Vote Up -0Vote Down

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

  [Read more...]
Speaking about the Event Scheduler at the Users Conference 2009
+0 Vote Up -0Vote Down



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?
Employee +0 Vote Up -0Vote Down

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
Employee +0 Vote Up -0Vote Down

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

  [Read more...]
The partition helper - Improving usability with MySQL 5.1 partitioning
+0 Vote Up -0Vote Down


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 Vote Up -0Vote Down
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 Vote Up -0Vote Down

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
Employee_Team +0 Vote Up -0Vote Down

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
Employee +0 Vote Up -0Vote Down

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:


  [Read more...]
Seeding to the mirrors
Employee +0 Vote Up -0Vote Down

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
Employee +0 Vote Up -0Vote Down

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 Vote Up -0Vote Down



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 Vote Up -0Vote Down




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
Employee_Team +0 Vote Up -0Vote Down

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 Vote Up -0Vote Down

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 Vote Up -0Vote Down

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 Vote Up -0Vote Down

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 Vote Up -0Vote Down

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 Vote Up -0Vote Down
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...]
Previous 30 Newer Entries Showing entries 31 to 54

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.