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 61 to 90 of 103 Next 13 Older Entries

Displaying posts with tag: Commentary (reset)

Hello world!
+0 Vote Up -0Vote Down

Yes, I’ve started yet another blog. You think I would learn.

This time it’s bout MySQL. The database we …


Cary Millsap: Thinking Clearly about Performance
+0 Vote Up -0Vote Down

Cary Millsap has a concise, readable paper on performance. Anyone involved in database performance optimization should read it. Cary’s writing has heavily influenced the mk-query-digest tool for analyzing MySQL/PostgreSQL/Memcached/HTTP query performance, and I think you’ll get a lot more from mk-query-digest if you read this paper — and you should also read his book, reviewed here. It’s one of the top books on my Essential Books List.

Related posts:

  •   [Read more...]
    InfiniDB gets the release process right
    +8 Vote Up -4Vote Down

    InfiniDB has a sensible Enterprise/Community release process, which seems similar to what I suggested for MySQL. Its simplicity also stands in stark contrast to MySQL’s new release policy, which is hard to understand and has been confusing people.

    Related posts:

  • Thank you for the MySQL 5.4 Community Release MySQL 5.4
  • How to find per-process I/O
  •   [Read more...]
    MySQL Enterprise/Community split could be renewed under Oracle
    +3 Vote Up -4Vote Down

    One of MySQL’s notable projects was splitting the product into two editions: Enterprise Edition and Community Edition. This move alienated many in the community, and failed to create meaningful differentiation on either side, even with a team of people beating the community bushes for “contributions.” The net differentiation was ultimately Jeremy Cole’s SHOW PROFILES functionality, which made Community better than Enterprise. Sun put less effort into making this split work, and eventually they abandoned it.

    But that could change under Oracle’s stewardship. Oracle’s

      [Read more...]
    How to tell if someone is bullshitting
    +4 Vote Up -3Vote Down

    Ever been around a group of people discussing some technology and heard Cool-Whip phrases like this?

    It’s not about MySQL versus PostgreSQL, it’s about using the right tool for the job.

    Or how about this one?

    You need to take the important factors into account before you decide whether [hot new fad] or [trusty old solution] is best suited for your application.

    Both are signs that someone might be trying to sound important. In situations like this, I’ve noticed that the people I look up to usually don’t make weighty-sounding statements about other people’s systems. They talk about what they are qualified to talk about: either they say something about their own systems, or if it’s warranted and invited, they ask intelligent questions about other

      [Read more...]
    Why MySQL might not benefit from having a mother ship
    +6 Vote Up -12Vote Down

    As I was driving with a colleague in California a couple of weeks ago during the conference, the topic of conversation turned to the notion that Percona and the rest of the MySQL community really need the presence of a central entity that provides a recognized home for the MySQL server. The conversation went something like “I was talking to so-and-so, and he said, you know, you guys really need Sun/MySQL, because without the mother ship, things will fall apart and your own business will fail.”

    I happen to believe this is FUD, and that the reverse might actually be true. (This is one reason why we’re competing head-on with MySQL.) Having a “mother ship” is in the long run, a very complex scenario to fully understand.

      [Read more...]
    Selena’s thoughts on a hacker’s cooperative
    +0 Vote Up -0Vote Down

    Selena Deckelmann has posted some ideas about a “hacker’s cooperative” for PostgreSQL.

    UC2009: How I Used Query Analysis to Speed up My Applications
    +3 Vote Up -0Vote Down

    The presentation slides for my Query Analysis talk here at the users conference are now available:

    How I Used Query Analysis to Speed up My Applications

    I’ll sort out the scripts and bits and pieces I use once I get back to the office next week, for those people waiting for that material.

    UC2009: On the Starting Blocks
    +1 Vote Up -0Vote Down

    Despite an annoying 3 hour flight delay from Heathrow (and no, I wasn’t connecting there, I was leaving from there), I’m here in San Francisco and Santa Clara again ready for the MySQL User Conference 2009.

    I obviously have my four presentations to get through, and there will be plenty of other stuff going on at the conference both in terms of other presentations, the show floor, the booths, and the Birds of a Feather sessions (which are terrific fun).

    But mostly, I see the UC2009 as the best opportunity to meet up with both other MySQL/Sun people, our customers, and the community at large and talk about the thing we are all passionate about – MySQL and the technologies surrounding it.

    And I don’t care if that sounds goofy. Nothing beats talking to face to face with like minded individuals, and one thing that MySQL – and Sun

      [Read more...]
    MySQL Conf 2009 Preview: Scalability and HA Tutorial
    +0 Vote Up -0Vote Down

    Like most people, and with just over a week to go before the conference, I’m putting the finishing touchs on my various presentations.

    First up for me, on Monday afternoon, is my tutorial: Scale Up, Scale Out, and High Availability: Solutions and Combinations.

    What will be doing?

    Very simply: Looking at every potential solution for maximum scalability and availability for your database environment.

    If you are attending, be prepared to:

    • Expand your mind as we think about scaling up.
    • Expand your horizons as we think about scaling out.
    • Divide and conquer, as we think about high-availability.

    We’re not not hands on in this session – but I will expect you to be brains on!

    Open-source database developer mailing lists
    +0 Vote Up -0Vote Down

    What’s going on at your favorite open-source database developer mailing list? Non-scientific memory of what I’ve been seeing lately:

    • The Drizzle list is talking about test coverage and completeness, and schedulers.
    • The MySQL internals list has recently been dominated with talk about coding standards.
    • The PostgreSQL hackers list is talking about a ton of stuff. I don’t even try to keep up.
    • The Percona launchpad list is talking about bugs, xtrabackup, and more bugs and patches for them. There’s also a Percona Google Group that is not very active. In fact there are several Percona lists; it looks a little confused.
    Towards more diversity of speakers at MySQL Conference and Expo
    +0 Vote Up -0Vote Down
    We (Percona) just announced our Percona Performance Conference, and I wanted to tell you a little more about what we hope to accomplish with this conference. Let me show you some simple math that anyone can do. There’s a handy iCal download of the conference schedule on the conference website. iCal is a plain [...]
    Does MySQL really have an open-source business model?
    +0 Vote Up -0Vote Down
    I’ve been thinking about the business of what’s variously come to be called commercial open-source and enterprise open-source. I’m interested in the gestalt — the product, development processes, marketing, licensing and so on. MySQL has tried many different ways to earn money. These include dual licensing, support subscriptions, a knowledgebase, consulting, an Enterprise/Community split, [...]
    Is MySQL 5.1 really a better 5.0?
    +0 Vote Up -0Vote Down
    With all the furor over MySQL 5.1 GA, its release schedule, its quality, etc etc I think a fundamental claim is being left un-examined. Lots of people are saying that if you leave out the new features in 5.1 and look only at the features that existed in 5.0, it’s better quality. The implication is [...]
    MySQL on Solaris Best Practices Presentation
    +0 Vote Up -0Vote Down

    A couple of weeks ago I was at the MySQL European Customer Conference in London, where I was presenting my talk on deploying MySQL on Solaris best practices. You can download a copy of the presentation here: MySQL on Solaris Best Practices.

    I cover both choosing the best release version, using tricks like mtmalloc (the threaded malloc library) before moving on to UFS and ZFS tricks, using DTrace and MySQL Cluster and Sun Cluster.

    MySQL Documentation Myths
    +0 Vote Up -0Vote Down

    There are a few myths surrounding the MySQL documentation and how it works, and I thought I’d try and dispel some of those myths if I can. If you have any more questions or misunderstandings you want clarified, let me know.


    MySQL Documentation is written by the developers.


    MySQL Documentation is written by a dedicated team of writers with help and input from the developers. There are four main writers, Paul DuBois, Tony Bedford, Jon Stephens, and MC Brown (me!), plus our Team Lead, Stefan Hinz.

    All the documentation staff are employed full time for the sole purpose of writing documentation. Sure, some of us get involved in other things too, but that’s basically the nature of the job. Some of us simply cannot help ourselves.


      [Read more...]
    DimDim and MySQL University
    +0 Vote Up -0Vote Down

    Stop the press! My boss, Stefan Hinz, has just started blogging, with his first post here: Using NetBeans with MySQL.

    So who is he? Well, Stefan is the guy that keeps the rest of us in the docs team in check and makes sure we do what we’re asked, when we’re are asked and that all of the machinery, legalities and management tasks happen in the background. Without him we really couldn’t function as effectively as we do.

    It’s wonderful to see some other Docs team members getting in on the act (to be fair to the rest of the team, Jon is also a blogger). We are all writers, you would think the blogging would come as a natural extension.

    Behind the tease is the simple fact that the improved system for MySQL University I was

      [Read more...]
    How to analyze memory leaks on Windows
    +0 Vote Up -0Vote Down

    We use valgrind to find memory leaks in MySQL on Linux. The tool is a convenient, and often enlightening way of finding out where the real and potential problems are location.

    On Windows, you dont have valgrind, but Microsoft do provide a free native debugging tool, called the user-mode dump heap (UMDH) tool. This performs a similar function to valgrind to determine memory leaks.

    Vladislav Vaintroub, who works on the Falcon team and is one of our resident Windows experts provides the following how-to for using UMDH:

  • Download and install debugging tools for Windows from here
    MS Debugging Tools
    Install 64 bit version if you’re on 64 bit Windows and 32 bit version

  • Change the

  •   [Read more...]
    Book: Intellectual Property and Open Source - the solution to IANAL
    +0 Vote Up -0Vote Down

    I’m reading Intellectual Property and Open Source by Van Lindberg at the moment, and despite being about a relatively dry topic, I must admit that it’s a fascinating read.

    Van Lindberg introduces the book by talking about the comments that end up on Slashdot.org, almost certainly prefixed by the expression IANAL (I Am Not A Lawyer) where people defend, discuss, and rip people up about the legalities of open source and the various licenses. Van Lindberg also talks about how he spends much of his time translating the contents of various legal documents into engineer speak and back again.

    Despite being a proponent and long time user of free software and open source for the best part of my working life, I’ll admit

      [Read more...]
    MySQL University - quick survey
    +0 Vote Up -0Vote Down

    MySQL University has been running for the last 18 months, and we’ve covered a wide range of topics, from the internals of MySQL right up to Amazon’s EC2, using MySQL in the Solaris/OpenSolaris Webstack and a description of the forthcoming MySQL Online Backup.

    Personally, I think they’re great. Obviously many times I am scribe and am there for the sessions, but I listen to lots of the sessions anyway, and I’m yet to be disappointed by the content. What’s really great is that in all the cases the person you are listening to is probably the person that either developed, or helped drive development of the particular function, or, in the case of some of the external tools (EC2, for example), these guys are expert in it. The experience is not quite as thrilling as attending the MySQL User

      [Read more...]
    Wanted: GUI developer for MySQL Enterprise Monitor
    +0 Vote Up -0Vote Down

    One of the great things about working on great products is that you get to meet such intelligent and interesting people. I can apply that to everybody that I work with, but there are some teams where not only are they working on great products, they are also all great people just to spend time with.

    I have had the good fortune of working with the MySQL Enterprise Monitor team as an advisor, and more recently in writing the documentation, for the last 18 months. We’ve had some great fun at meetings in Amsterdam, Heidelberg, Santa Cruz and recently Riga. In the meeting rooms we are professional, but fun. But in the evenings we’ve gone out and just had plain good fun. Unless you’ve experienced a full day, or even week, of non-stop meetings for 12 hours a day you have no idea how important it is to kick back in the evenings. That, as a

      [Read more...]
    Life as a consultant: my crooked arm for a pillow
    +0 Vote Up -0Vote Down
    Sometimes there are funny communication styles between people who are geographically distributed and working together all the time. Recently one of our team members echoed back to me some answers I gave over a chat session: Q: Is it OK for me to buy quad-core servers? A: The old man walks slow but carries much, whilst [...]
    Is agent-based or agentless monitoring best?
    +0 Vote Up -0Vote Down
    Rob Young has posted a few blog entries lately on the MySQL Enterprise monitoring software. His latest post claims that agent-based monitoring is equivalent to extensibility (MySQL Enterprise Monitor: Agent = Extensibility). I think this is conflating two completely distinct properties of a monitoring solution. Cacti is extremely extensible, with a plugin-based architecture and [...]
    Using BASE instead of ACID for scalability
    +0 Vote Up -0Vote Down

    My editor Andy Oram recently sent me an ACM article on BASE, a technique for improving scalability by being willing to give up some other properties of traditional transactional systems.

    It’s a really good read. In many ways it is the same religion everyone who’s successfully scaled a system Really Really Big has advocated. But this is different: it’s a very clear article, with a great writing style that really cuts out the fat and teaches the principles without being specific to any environment or sounding egotistical.

    He mentions a lot of current thinking in the field, including the CAP principle, which Robert Hodges of Continuent first turned me onto a

      [Read more...]
    MySQL 6.2 is GA, but 5.1 is RC and 6.0 is alpha
    +0 Vote Up -0Vote Down

    MySQL’s version numbering is getting harder and harder to understand. In fact, it’s getting surreal.

    Let me state up front that there’s probably a lot I don’t know here. But if I don’t know, how on earth can the general public figure it out?

    Before we begin, let’s define terms: GA is completely done, ready for use. RC is a release candidate: don’t change anything, just fix bugs because we’re charging towards a release here. Beta is possibly unsafe code, use at your own risk. Alpha is known to have significant bugs, but if you’re curious please play with it.

    Now for the releases/versions game. Let’s recap:

    • 5.0 has version numbers that leapfrog each other in features and functionality. SHOW PROFILES — now you see it, now you don’t.
    • 5.1
      [Read more...]
    Why is PostgreSQL getting dramatically more patches?
    +0 Vote Up -0Vote Down

    Bruce Momjian says

    …the volume of patches [to PostgreSQL] has risen dramatically during the past few years.

    This is total hearsay — I don’t have hard numbers, haven’t verified it myself, etc etc. But consider the source!

    What can be responsible for this increase in patches to PostgreSQL?

    Bruce Momjian, Open Source development, patches, PostgreSQL
    I moved this blog to pairLite with zero downtime, and it was easy
    +0 Vote Up -0Vote Down

    Did you notice that I moved this blog from pair Networks to pairLite hosting?

    Probably not, unless you check the DNS of xaprb.com regularly!

    Don’t you hate it when people say “I’m moving my blog, I hope there won’t be more than a few days of downtime, blah blah…” Why is this ever necessary, I wonder? I wonder the same thing about a lot of hosting providers — recently I had a client in my consulting practice whose (very large, well-known) hosting provider tried to help them with some very simple MySQL work and ended up causing them an obscene amount of downtime, like many many days, and there was no end in sight. As I spoke on the phone with him and asked him about his

      [Read more...]
    Why is MySQL more popular than PostgreSQL?
    +0 Vote Up -0Vote Down

    There is much discussion of why MySQL (http://www.mysql.com/) is more widely adopted than PostgreSQL. The discussion I’ve heard is mostly among the PostgreSQL community members, who believe their favorite database server is better in many ways, and are sometimes puzzled why people would choose an inferior product.

    There are also many comparison charts that show one server is better than the other in some ways. These don’t really seem to help people with this question, either!

    I can’t answer for everyone, but I can put it in the form of a question: if I were to replace MySQL with PostgreSQL, what things do I rely on that would become painful or even force a totally different strategy? The answer turns out to be fairly simple for me: replication and upgrades.


      [Read more...]
    MySQL: Free Software but not Open Source
    +0 Vote Up -0Vote Down

    The title of MySQL’s website (http://www.mysql.com/) states that they are the world’s most popular open-source database. This is false; MySQL is not an open-source database. That assertion is a fact, not an opinion.

    MySQL is Free Software, licensed under the GNU GPL. People frequently use the two phrases “Free Software” and “Open Source Software” as synonyms, but there are very large, very important differences.

    The difference between Free and Open Source

    Open Source is much more of a development methodology than a philosophical standpoint. The first thing on the Open Source Initiative’s website is this introduction:

    Open source is a development method for software that

      [Read more...]
    Like it or not, it is the MySQL Conference and Expo
    +0 Vote Up -0Vote Down

    The conference that many of us just went to is called the MySQL Conference and Expo, but a lot of people don’t call it that. They call it by the name it had in 2006 and earlier: MySQL User’s Conference. In fact, some people say (or blog) that they dislike the new name and they’re going to call it the old name, because [… insert reason here…].

    I call it by the new name that some people dislike so much. Why? Because it is a conference and expo, not a user’s conference. There’s no reason to pretend otherwise. The conference is organized and owned by MySQL, not the users. It isn’t a community event. It isn’t about you and me first and foremost. It’s about a company trying to successfully build a business, and other companies paying to be sponsors

      [Read more...]
    Previous 30 Newer Entries Showing entries 61 to 90 of 103 Next 13 Older Entries

    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.