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 中文
Showing entries 1 to 15

Displaying posts with tag: 5.4 (reset)

Thoughts on MySQL 5.1 and later
+3 Vote Up -0Vote Down

It’s been a while since I’ve posted anything new. In the meantime I’ve been pretty busy. Working on production systems often means that you are not running bleading edge. That’s fine but sometimes you need to look at doing the upgrade and to do that you have to do quite a few checks to see how well newer versions of the software you use will work.

I’ve been in that situation with MySQL. I have quite a few boxes most of which are 5.0 and have been working fine. MySQL-5.1 has been GA now for some time, and I have started to look at it as support for 5.0 is about to end.  I’ve already found quite a few 5.1 bugs, good enough to crash the server, but again that’s to be expected. Heavy loads and odd usage of the server means that MySQL can never be able to test all things.  Replication problems caused a few issues with the

  [Read more...]
The search for MySQL 5.5
+3 Vote Up -3Vote Down

So, MySQL 6.0 was ditched, and a few weeks ago 5.4 was also – its features to be added in other (earlier) versions (I’m told 5.2 but not sure). I reckon that’s good news, regardless of the version number. There was also an announcement about a change in the release mechanism at Sun/MySQL.

Now for practicals. If I look on Launchpad, the 5.1 branch is the only active one (next to 5.0 fixes, of course). 5.4 was last updated 15 weeks ago. There is no 5.2 on there that I can find. Wasn’t looking for it really, just happened to notice its absence while I was trying to find 5.5. And the reason for that was that Miguel closed a bug I was following, noting it was no longer reproducible in 5.5. He pastes some code that reports mysql as 5.5, so it’s not a

  [Read more...]
Notes for installing MySQL 5.4.2 on OSX 10.5.8 PPC
+0 Vote Up -0Vote Down

Some notes from my recent installation of MySQL 5.4.2-beta on a PPC G5 box running OSX 10.5.8. Hopefully these notes will save someone a bit of time when they begin the “I want to make my mac a development box” process. I’m not going to cover installing/configuring Apache and PHP since the web is full of those articles already.  So, first things first,  I downloaded the pkg file  – not the tarball – from the MySQL downloads site and installed the following files in the following order:

  • mysql-5.4.2-beta-osx10.5-powerpc-64bit.pkg
  • MySQLStartupItem.pkg
  • MySQL.prefPane
  • CNF File Settings

    Here are some interesting settings that you may want to be aware of with 5.4 and OSX

    • Do not set innodb_flush_method=fdatasync – it’s not a valid option, and the default after install is actually
      [Read more...]
    Wordcamp in Milan - slides on MySQL 5.x performance
    +1 Vote Up -0Vote Down



    I am attending WordCamp 2009 in Milan.
    I presented MySQL 5.1 and 5.4, with stress on performance.
    People are interested. And many questions are flying around, some of which are answerable and some aren't. The questions about Oracle were swiftly avoided, and the ones about forks comparisons were answered with live examples.
    The attendees have appreciated it.
    MySQL 5.4 - performance at your fingertips
    +2 Vote Up -0Vote Down



    The session at the Boston MySQL User Group was very enjoyable. There was a full room, and the presentation was followed with attention and curiosity.
    The slides I used for this presentation include the deck used by Allan Packer and Mikael Ronström at the MySQL Conference 2009, followed by a testimony of my own experience with 5.4.
    Here is the final deck: MySQL 5.4 theory and practice

    While preparing the slides, I realized that, for the first time, we have a product that allows a painless performance gain. Unlike all the tuning and technological improvements






      [Read more...]
    MySQL 5.4 at the MySQL Boston User group
    +2 Vote Up -0Vote Down



    The MySQL Boston User group will meet on May 11 at 7pm.
    I will speak about my experience using MySQL 5.4, with some general information on the release.
    BTW, you know that there has been some trouble about MySQL meetup groups. We are looking into the matter, and we will release information as soon as possible. For now, I can tell you that the current agreement between MySQL and Meetup is valid at least until June 10, 2009.
    Finding the source for MySQL 5.4
    Employee +0 Vote Up -0Vote Down
    In order to really check what currently has made it into 5.4(there has been rumors...) I wanted to branch the code and see for myself.

    Couldn't find it at first in our internal code repository since it's actually not named 5.4 there yet. Fortunately it's also pushed out to launchpad, that means you can easily get a copy of the code using bazaar

    $> bzr branch lp:mysql-server/5.4

    There is of course also tar balls available from our download page
    http://dev.mysql.com/downloads/mysql/5.4.html#source

    Anyone curious about what our internal name is? :)
    MySQL 5.4 performance with logging
    +8 Vote Up -0Vote Down


    About a month ago, I published the results of MySQL 5.x performance with logging. The results covered several versions, from 5.0.45 to 5.1.33. Among the conclusions of the post was the consideration that MySQL 5.0.x is faster than MySQL 5.1 in read only operations. I hinted that better results may come for MySQL 5.1. When I wrote that post I had, in fact, an ace up my sleeve, because I had already benchmarked the performance of MySQL 5.4, using the same criteria shown in my previous post. The results, as you can

      [Read more...]
    MySQL DTrace presentation slides
    Employee +0 Vote Up -0Vote Down
    For some reason my presentation slides have not been posted to on MySQL Users Conference site. Here it is, a pdf format of "Introduction to Using DTrace with MySQL".
    MySQL DTrace presentation slides
    Employee +0 Vote Up -0Vote Down
    For some reason my presentation slides have not been posted to on MySQL Users Conference site. Here it is, a pdf format of "Introduction to Using DTrace with MySQL".
    MySQL DTrace presentation slides
    Employee +0 Vote Up -0Vote Down
    For some reason my presentation slides have not been posted to on MySQL Users Conference site. Here it is, a pdf format of "Introduction to Using DTrace with MySQL".
    MySQL Replication Heartbeat
    +0 Vote Up -1Vote Down

    Well isn’t that interesting, hidden all the way at the end of the MySQL 5.4 information are two words that really peaked my interest: Replication Heartbeat. And it wasn’t even using caps or other highlighting in the original text. Reading through the feature list of 5.4, I’m very impressed. All necessary/useful stuff for the real world, no marketing or enterprise blah.

    Of course we’ll have to explore it in detail to have more opinion. Proof is in production, not paper. As this is the first most of us have heard/seen of it, it’ll take time to explore. Someone who tried to install the tarball this morning got an assertion during the system table installation. That’s not the best first impression, but that might be a build issue. I’m really pretty excited about the

      [Read more...]
    mysql dtrace provider now enabled in MySQL 5.4
    Employee +0 Vote Up -0Vote Down

    Over the last year there has been alot of work done to instrument MySQL with static dtrace probes. The mysql provider first became available in MySQL 6.0.8 but required a build with the --enable-dtrace flag to enable it. Starting with MySQL 5.4 the mysql provider and it's static probes are now enabled by default and ready to be used on Solaris 10, OpenSolaris and Mac OS X.

    The static probes in MySQL 5.4 have been designed to follow the execution path of a query


    with the level getting deeper as the query execution proceeds. However the probes are implemented so that you don't have to traverse the entire hierarchy to get the information you want.




      [Read more...]
    mysql dtrace provider now enabled in MySQL 5.4
    Employee +0 Vote Up -0Vote Down

    Over the last year there has been alot of work done to instrument MySQL with static dtrace probes. The mysql provider first became available in MySQL 6.0.8 but required a build with the --enable-dtrace flag to enable it. Starting with MySQL 5.4 the mysql provider and it's static probes are now enabled by default and ready to be used on Solaris 10, OpenSolaris and Mac OS X.

    The static probes in MySQL 5.4 have been designed to follow the execution path of a query


    with the level getting deeper as the query execution proceeds. However the probes are implemented so that you don't have to traverse the entire hierarchy to get the information you want.




      [Read more...]
    mysql dtrace provider now enabled in MySQL 5.4
    Employee +0 Vote Up -0Vote Down

    Over the last year there has been alot of work done to instrument MySQL with static dtrace probes. The mysql provider first became available in MySQL 6.0.8 but required a build with the --enable-dtrace flag to enable it. Starting with MySQL 5.4 the mysql provider and it's static probes are now enabled by default and ready to be used on Solaris 10, OpenSolaris and Mac OS X.

    The static probes in MySQL 5.4 have been designed to follow the execution path of a query


    with the level getting deeper as the query execution proceeds. However the probes are implemented so that you don't have to traverse the entire hierarchy to get the information you want.




      [Read more...]
    Showing entries 1 to 15

    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.