Planet MySQL

+2

-0

posted by Stewart Smith on Thu 28 Jun 2012 05:10 UTC
Tags:

(edit) Java, code, drizzle, Percona, bzr, bazaar, jenkins

For Drizzle and for all of the projects we work on at Percona we use the Bazaar revision control system (largely because it’s what we were using at MySQL and it’s what MySQL still uses). We also use Jenkins.

We have a lot of jobs in our Jenkins. A lot. We build upstream MySQL 5.1, 5.5 and 5.6, Percona Server 5.1, Percona Server 5.5, XtraBackup 1.6, 2.0 and 2.1. For each of these we also have the normal trunk builds as well as parameterised ones that allow a developer to test out a tree before they ask for it to be merged. We also have each of these products across seven operating systems and for each of those both x86 32bit and 64bit. If we weren’t already in the

+1

-0

posted by Chris Calender on Tue 17 Jan 2012 22:23 UTC
Tags:

(edit) mysql, bzr, bazaar, mysql windows, -DBUILD_CONFIG=mysql_release, bison, build mysql, build mysql on windows, compile mysql, m4.exe, mysql.sln, mysql_release

Not counting obtaining the source code, and once you have the prerequisites satisfied, [Windows] users can build from source code in 5 easy steps.

Prerequisites – Install & ensure they are in the $PATH:

CMake Download

C++ compiler Free Download

Bison Download (ensure m4.exe is also included, which it should be)

Optional (but most likely you’ll want):

Perl Strawberry Perl is a great option.

Bazaar source tree

Tip: Install these in locations where spaces are not in the path. Specifically, watch for the Bison/m4 as there is a known bug with regards to that.

..

Now that that’s out of the way, we can begin. You just need to decide if you want to build from

+3

-0

posted by Monty Program Group Blog on Mon 07 Nov 2011 09:00 UTC
Tags:

(edit) Firefox, Uncategorized, Development, Launchpad, tricks, bzr

If you work with bazaar, you have seen its URIs. You can find the complete list is in the bzr help urlspec. Although I commonly use only a subset of that, like bzr+ssh://bazaar.launchpad.net/~maria-captains/maria/5.2-serg/ and http://bazaar.launchpad.net/%2Bbranch/mysql-server/5.5/.

In addition I often use Launchpad aliases, such as lp:~maria-captains/maria/5.3-serg/, lp:maria/5.3, and lp:869001.

And finally, there are common abbreviations that we have used in MySQL, and others that we use in MariaDB, for example bug#12345 and wl#90.

What’s annoying, I need to remember that wl#90 corresponds to http://askmonty.org/worklog/?tid=90

+2

-0

posted by Stewart Smith on Sat 21 May 2011 08:35 UTC
Tags:

(edit) Percona, bzr, Xtrabackup

I have just upgraded the xtrabackup bazaar code repositories to the 2a format. This means that bzr 1.16 is required to access the source code repositories now.

If you get an error like the one below when working with a local branch, you’ll need to run “bzr upgrade” in it (see below for example). For branches on launchpad, you can use the web UI and hit the “upgrade branch” button.

stewart@willster:~/src/percona-xtrabackup$ bzr pull
Using saved parent location: bzr+ssh://bazaar.launchpad.net/%2Bbranch/percona-xtrabackup/
Doing on-the-fly conversion from RemoteRepositoryFormat(_network_name='Bazaar repository format 2a (needs bzr 1.16 or later)\n') to RepositoryFormatKnitPack1().
This may take some time. Upgrade the repositories to the same format for better performance.
bzr: ERROR:

[Read more...]

Persistent index statistics for InnoDB

+5

-0

posted by Stewart Smith on Mon 13 Dec 2010 04:37 UTC
Tags:

(edit) mysql, index, drizzle, Statistics, bzr, innobase

In browsing the BZR tree for lp:mysql-server, I noticed some rather exciting code had been merged into the Innobase code.

You may be aware that InnoDB will do some index dives when opening a table to get some statistics about the indexes that can help the optimiser make good query plans.

The problem being that this is many disk seeks. It means that on server restart, you have to spend a whole bunch of time seeking around the disk reading index pages.

Not any more.

There is now code merged in to store the calculated statistics in a table inside InnoDB so that these index dives don’t have to happen on startup.

Originally, this looked like it was going to make it into InnoDB+. The

[Read more...]

InnoDB Revision History

+1

-0

posted by InnoDB Team on Sun 19 Sep 2010 19:28 UTC
Tags:

(edit) Uncategorized, revision, bzr, history, svn, bk, vcs

This is a brief overview of the history of InnoDB with respect to the Version Control Systems (VCS) that were used for developing. It could be useful to people who want to trace back in time to find the origins of bugs or features.

Early days
InnoDB was born in the mid 1990s when Heikki Tuuri started developing this masterpiece. Heikki was a lone developer at that time and he did not use any VCS. There is no InnoDB revision history before 2001.

2001 – 2005
Then in 2001 InnoDB was imported into MySQL’s BitKeeper repository and development continued, recording the history there.

2005 – 2010
Later on in Oct 2005 when Oracle acquired Innobase, InnoDB developers had to move away from MySQL’s BitKeeper repository and Subversion was chosen for InnoDB development. The latest sources

+1

-0

posted by Lenz Grimmer on Mon 07 Dec 2009 14:39 UTC
Tags:

(edit) mysql, Linux, Web, subversion, travel, OSS, community, conference, event, sun, Presentation, Development, Programming, pictures, collaborating, slides, bzr, git, mercurial, social, codebits, concert

Last week, my colleagues Giuseppe, Kai and myself attended the SAPO Codebits event in Lisbon, Portugal. Codebits is an annual, invite-only hacking event, which went on for three days. The venue they chose this year was the "Cordoaria", a former rope factory located in the Belém district, close to the 25 de Abril Bridge (which is an impressive sight!). I have been told that the Cordoaria is the longest building in Portugal and I have no doubts about that! The building is so long that the crew used bicycles to get from one end to the other. I've taken a number of

[Read more...]

Bazaar importmbox plugin

+1

-0

posted by Stewart Smith on Mon 16 Nov 2009 02:57 UTC
Tags:

(edit) mysql, drizzle, plugin, bzr, importmbox, mbox, quilt

Releasing and announcing software is win! I’ve had this bumming around for a bit, and for me (and I think others hacking on MySQL) it’s been rather useful. Simple plugin that takes each email in an mbox, applies the patch and commits it with the correct author to a bzr repo. Very useful if you use quilt and bzr together (“quilt mail –mbox” and then “bzr importmbox”).

I finally published it up at:

http://launchpad.net/bzr-importmbox

enjoy.

Aspects and benefits of distributed version control systems (DVCS)

+2

-0

posted by Lenz Grimmer on Thu 05 Nov 2009 21:49 UTC
Tags:

(edit) mysql, code, Linux, subversion, OSS, community, Development, Programming, scm, mylvmbackup, drupal, collaborating, contributing, bzr, git, mercurial, social, codebits

This blog post is a by-product of my preparation work for an upcoming talk titled "Why you should be using a distributed version control system (DVCS) for your project" at SAPO Codebits in Lisbon (December 3-5, 2009). Publishing these thoughts prior to the conference serves two purposes: getting some peer review on my findings and acting as a teaser for the actual talk. So please let me know — did I cover the relevant aspects or did I miss anything? What's your take on DVCS vs. the centralized approach? Why do you prefer one over the other? I'm looking forward to your comments!

Even though there are several distributed alternatives available for some years now (with

+0

-0

posted by Lenz Grimmer on Mon 26 Oct 2009 12:47 UTC
Tags:

(edit) mysql, Linux, travel, OSS, community, conference, event, Presentation, meeting, planetmysql, opensqlcamp, collaborating, bzr, git, mercurial, social, codebits

This time of the year is usually a very busy one, as there are plenty of events and conferences to attend. Just take a look at our calendar of OSS events on the MySQL Forge to see what I mean! Here's a quick summary of the ones that I will attend and speak at until the end of this year:

On November 14-15, I'll attend the openSQL Camp in Portland (OR), USA. I missed the first one that took place in Charlottesville (VA) in 2008, but had a lot of fun organizing the European Edition earlier this year. The upcoming one will be more like an

[Read more...]

IntelliJ IDEA Open Sourced

+0

-0

posted by Lenz Grimmer on Fri 16 Oct 2009 14:24 UTC
Tags:

(edit) mysql, PHP, Java, Databases, Linux, OSS, eclipse, Development, Programming, Python, netbeans, OpenSolaris, bzr, intellij

With IntelliJ now being available under an Open Source license, developers have another option to choose from when it comes to Java-based IDEs/Frameworks (Eclipse and NetBeans being the other two prominent ones). Choice is always good, and being an Open Source enthusiast, I of course welcome JetBrain's move!

However, as I'm not really a heavy GUI-based IDE user myself, I can't really comment on which one is the best. These kind of discussions tend to turn into a Holy War anyway... In the end it's likely that each of them gets the job done and you have to come to your own conclusions, based on your personal preference and requirements.

I personally would be interested in

+2

-0

posted by Henrik Ingo on Fri 16 Oct 2009 10:48 UTC
Tags:

(edit) mysql, Open Source, Linux, community, bzr, mariadb, MontyProgram

When I was younger and had lots of free time, I used to do video editing as a hobby. At that time I developed a rule that is true for many projects in general (it was also true for writing a book some years later). The rule is: When you think you are 90% done, you are only 50% done. With video-editing, this meant that when the video was more or less ready, you are still 50% away from the final goal of actually having a master copy on tape. The latter 50% would be spent on checking ending credits, watching through the video a couple of times, and in those time, rendering even simplest of effects. Using a Windows PC for video editing was in those times a shaky effort in itself, so even when mastering you had to sit there and watch through the whole tape to make sure there were no glitches.

Producing a MariaDB release has been a similar

[Read more...]

Modular vs Integrated

+0

-0

posted by Open Query on Tue 02 Jun 2009 23:37 UTC
Tags:

(edit) mysql, Tools, Uncategorized, subversion, Launchpad, workflow, open query, bzr, bazaar, git, mercurial, Clayton Christensen, svn, hg, distributed version control, integrated, modular, the innovator's solution, toolchain

There’s actually no single “correct” answer! It all depends on

where in a stack the component lives;

the state of the market for that component region;

sometimes even geographic location of the user comes into play.

Yes, for OSS projects modularity is handy in terms of handling contributions, but modularity may not be the best way to deal with a problem in a certain market state and situation!

Research has shown (see, for example, “The Innovator’s Solution” by Clayton Christensen) that the “integrated” region over time actually shifts to a subcomponent of an original integrated component that has since gone modular. An interesting example of this for MySQL its pluggable storage engine interface since version 5.1. MySQL is more modular now, but individual storage engines are tightly integrated for performance

+0

-0

posted by Henrik Ingo on Tue 02 Jun 2009 05:27 UTC
Tags:

(edit) mysql, Technical, bzr

My collagues Anders and even Ivan sometimes blog about the grandeur of being a Sales Engineer. And I agree, it is a great job, probably the best I ever had, so far. But let me share a secret: It's not as technical as you'd think. Sure, they call me a "pre-sales consultant" alright, but I would be ashamed of comparing my own work with those of the real consultants. I sometimes jokingly say that the most amazing technical things in my job are airplanes (they fly in the air!) and how to make a nice slideshow. (OpenOffice Impress sucks btw, and I always envy my OS X + Keynote using friends on this one

+0

-0

posted by Lenz Grimmer on Thu 28 May 2009 13:39 UTC
Tags:

(edit) mysql, PHP, Databases, Blog, travel, Backup, OSS, community, conference, event, Presentation, gallery, pictures, cluster, drizzle, slides, bzr, Multimedia

I just realized that I haven't blogged for more than a month! Shame on me. But I will blame it on being away on conferences and vacation for quite some time And if you are following me on twitter, you may have noticed what I was going on in my life and that I did't get hit by a bus...

So what was going on since I returned back home from the MySQL Conference? First off, I uploaded und sorted my pictures from the conference and the Drizzle developer day on Flickr. I also uploaded the slides (PDF) from Colin and myself speaking about

[Read more...]

Drizzle Developer Day in Santa Clara

+2

-0

posted by Lenz Grimmer on Fri 24 Apr 2009 22:40 UTC
Tags:

(edit) mysql, Databases, Linux, OSS, community, conference, event, sun, suse, rpm, pictures, packaging, drizzle, collaborating, contributing, bzr

Today I attended the Drizzle Developer Day which took place in the auditorium of the Sun Campus in Santa Clara.

Many of the the Drizzle core hackers as well as several other people interested in the development attended this event, hacking away and discussing various issues. Jeremy Zawodny gave a presentation about Craigslist's needs for Drizzle, Jay Pipes gave an overview over Google's protocol buffers library. I took a number of pictures, which you can find in my Flickr

+0

-0

posted by Lenz Grimmer on Wed 25 Mar 2009 11:18 UTC
Tags:

(edit) mysql, travel, Backup, OSS, community, conference, Presentation, bzr

My travel schedule is getting quite crowded for the next months - I just received confirmation that I will be speaking at the phpDay in Verona, Italy on May 15-16th. I'll be talking about bzr - The Bazaar source revision control system as well as MySQL Backup and Security - Best practices in the developer track of the conference. I've never been to Verona, but it seems like it's a beautiful city. I look forward to being there!

Drizzle Commit Statistics

+0

-0

posted by Stewart Smith on Wed 25 Feb 2009 14:48 UTC
Tags:

(edit) General, drizzle, Statistics, bzr, Add new tag

Per day:

Per Month:

Or more interestingly… What day are commits being made? Are we working over the weekend?

Do we work all night?

+0

-0

posted by Lenz Grimmer on Fri 09 Jan 2009 00:41 UTC
Tags:

(edit) mysql, PHP, OSS, community, conference, event, Presentation, planetmysql, vacation, collaborating, OpenSolaris, FOSDEM, bzr

A (slightly belated) Happy New Year to you! I just returned from my Christmas vacation two days ago, which I spent mostly at home and with my parents-in-law in St. Radegund, Austria. Now I am busy catching up with what has piled up during my absence (I managed to resist the temptation to check my work email during the time off).

Some MySQL-related news that came up in the past weeks and are worth sharing:

My talk about MySQL HA solutions has been accepted in the main FOSDEM conference track
The FOSDEM organizers also accepted my lightning talk proposal about Bazaar - it will take place on Saturday, 14h20 (tentative)

+0

-0

posted by Lenz Grimmer on Thu 08 Jan 2009 23:41 UTC
Tags:

(edit) mysql, PHP, OSS, community, conference, event, Presentation, planetmysql, vacation, collaborating, OpenSolaris, FOSDEM, bzr

A (slightly belated) Happy New Year to you! I just returned from my Christmas vacation two days ago, which I spent mostly at home and with my parents-in-law in St. Radegund, Austria. Now I am busy catching up with what has piled up during my absence (I managed to resist the temptation to check my work email during the time off).

Some MySQL-related news that came up in the past weeks and are worth sharing:

My talk about MySQL HA solutions has been accepted in the main FOSDEM conference track
The FOSDEM organizers also accepted my lightning talk proposal about Bazaar - it will take place on Saturday, 14h20 (tentative)

+0

-0

posted by Lenz Grimmer on Mon 01 Dec 2008 21:19 UTC
Tags:

(edit) mysql, Databases, Linux, OSS, community, conference, event, Presentation, cluster, collaborating, OpenSolaris, FOSDEM, bzr

FOSDEM 2009, one of the biggest European Open Source conferences, will take place on February 7-8 in Brussels, Belgium. Today I received a confirmation from the organizers: MySQL will have a developer room on Sunday, the 8th! This is very cool.

My idea was to organize some kind of MySQL mini-conference, with a focus on developers and DBAs. I am going to send out a more formal CfP soon, but if you have any ideas or suggestions for a talks/sessions already, please get in touch with me!

In addition to the devroom, I have also been invited to give a talk about MySQL High Availability solutions in the conference main track. In this talk I plan

+0

-0

posted by Lenz Grimmer on Mon 01 Dec 2008 21:19 UTC
Tags:

(edit) mysql, Databases, Linux, OSS, community, conference, event, Presentation, cluster, collaborating, OpenSolaris, FOSDEM, bzr

FOSDEM 2009, one of the biggest European Open Source conferences, will take place on February 7-8 in Brussels, Belgium. Today I received a confirmation from the organizers: MySQL will have a developer room on Sunday, the 8th! This is very cool.

My idea was to organize some kind of MySQL mini-conference, with a focus on developers and DBAs. I am going to send out a more formal CfP soon, but if you have any ideas or suggestions for a talks/sessions already, please get in touch with me!

In addition to the devroom, I have also been invited to give a talk about MySQL High Availability solutions in the conference main track. In this talk I plan

+0

-0

posted by Lenz Grimmer on Thu 11 Sep 2008 17:21 UTC
Tags:

(edit) mysql, Java, Hardware, Linux, subversion, OSS, community, sun, Development, scm, solaris, collaborating, OpenSolaris, hosting, bzr, mercurial

While Colin beat me in blogging about Project Kenai, I think I can still provide some additional background information about this new project hosting service from Sun.

If you are a maintainer of an Open Source project, you currently have plenty of choice when it comes to getting your project hosted for free. One criterion could be your software configuration management system (SCM) of choice.

Some of the hosting services that I am currently aware of and the choice of SCM they offer include:

+0

-0

posted by Lenz Grimmer on Mon 01 Sep 2008 15:15 UTC
Tags:

(edit) mysql, Linux, OSS, community, conference, event, sun, Presentation, FrOSCon, gallery, pictures, solaris, drupal, slides, bzr

I'm back home from DrupalCon 2008 now - it has been a great event! I met a lot of nice people from the Drupal Community and learned a lot about this CMS. I've been very busy in uploading the remaining pictures from the event to my gallery - so here's for your viewing pleasure:

+0

-0

posted by Lenz Grimmer on Fri 01 Aug 2008 19:10 UTC
Tags:

(edit) mysql, Linux, subversion, OSS, community, Development, forge, distribution, mylvmbackup, packaging, collaborating, contributing, bzr

In a recent article, Matt Asay was musing about the aspects of hosting an Open Source project by yourself vs. using a public project hosting service like SourceForge, GitHub or Launchpad. He concluded that it's important for commercial/sponsored open source projects in particular to do the hosting by themselves, so they can maintain full control and can gain more insight, which hopefully will turn into more revenue at some point.

However, Matt seems to reduce "hosting" to "providing downloads" only:

Control and visibility. Given the importance of customer conversions, it becomes hugely valuable information to know that it takes,

+0

-0

posted by Lenz Grimmer on Wed 25 Jun 2008 19:53 UTC
Tags:

(edit) mysql, Linux, subversion, perl, OSS, community, Development, Site News, lvm, mylvmbackup, collaborating, contributing, bzr

JFYI: today I migrated the mylvmbackup source tree from my local Subversion repository on http://www.lenzg.org/ to a Bazaar repository on Launchpad.net.

This will hopefully make it easier for contributors to work on the code and share their modifications with others, removing me as the bottleneck for applying and testing patches for new releases. I chose Bazaar primarily because I wanted to get some more hands-on practice with it, now that the MySQL Server source trees have been transferred to it as well (see Kaj's announcement for

+0

-0

posted by Lenz Grimmer on Mon 23 Jun 2008 08:49 UTC
Tags:

(edit) mysql, PHP, Linux, OSS, community, conference, sun, Presentation, suse, FrOSCon, distribution, solaris, bzr, thinkpad

While we're on the topic of Bazaar - this week I got informed by the organizers of the FrOSCon 2008 conference that they accepted two of my talk proposals: one session will be an introduction to this source code management system (what a coincidence), the other one will be an introduction to OpenSolaris for Linux users, explaining some of the underlying technologies and how they differ from what a seasoned Linux user may be accustomed to.

And no, I have not given up on using Linux - quite the contrary! I have been very impressed by the latest OpenSUSE 11.0 release and already run it for since quite some time on several of my work systems. In fact, I already

[Read more...]

The MySQL source code has moved!

+0

-0

posted by Lenz Grimmer on Thu 19 Jun 2008 21:17 UTC
Tags:

(edit) mysql, Linux, subversion, OSS, community, Development, collaborating, contributing, opengis, bzr

Even though we had been preparing the migration to Bazaar for a while now, today's announcement kind of caught me by surprise. But I am very happy about this move!

While BitKeeper is an excellent tool and served us well the past eight (!) years, I was quite annoyed when BitMover decided to remove the fully functional free BitKeeper client, which effectively put our development back into a Cathedral: even though our source trees remained accessible via bkbits.net, the crippled bk client was only capable of cloning

[Read more...]

Search

Profile

Top Voted (Last Week)

Top Voted (Last Month)

Top 20 Most Active Authors

Top 10 Most Active Team Blogs

Oracle MySQL Blogs

MySQL Links

Other Links

Planetarium