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 30 of 44 Next 14 Older Entries

Displaying posts with tag: source (reset)

How to execute mysql query from a file in your mysql client terminal?
+0 Vote Up -0Vote Down
Being a terminal fan myself, I usually find myself running queries in the mysql client instead of a UI interface as it is much faster. You get to see the results instantaneously.

One thing which is pretty tedious is editing a big query again after once running it as the whole multi-line formatted query now appears on a single line, thus reducing its readability.

But no problems, you can edit your query from a file and run the file from your mysql client terminal as many times as you want with as many edits.

To do so, follow the below steps:

1. Open your terminal and cd into the folder you want to store our sample mysql file. Then save your query in a sample file called my_query.sql

$ cd /path/to/folder
$ vim my_query.sql

Save a sample query like:

SELECT *














  [Read more...]
PHP 5.3.4 and MySQL 5.5.8 GA (libmysql)
+0 Vote Up -0Vote Down

As you are probably aware, PHP 5.3.4 does not compile with MySQL 5.5 GA (http://www.mysql.com/why-mysql/white-papers/mysql-wp-whatsnew-mysql-55.php). The details can be seen in MySQL bug queue. Basically, the problem boils down to incorrect installation of MySQL headers. MySQL 5.5 build system does not install the headers under the include-prefix/mysql directly but instead installs under the include-prefix directory itself. So, when the PHP build system looks for the MySQL (http://mysql.com/) headers, it cannot find <mysql/psi/mysql_thread.h> and so forth.

What is the fix?

The MySQL dev team

  [Read more...]
Downloading, compiling, and installing MySQL Server from source code
+0 Vote Up -0Vote Down

If you are running any GNU/Linux server operating system like RHEL 5 or CentOS 5, you may probably install MySQL server that comes with the operating system packages either during the initial setup or later using yum(8). The advantage being addition/removal of packages either using the GUI package manager or rpm(8), yum(8). Fair enough. But unfortunately the MySQL package (mysql-server) that comes bundled with RHEL 5.5 or CentOS 5.5 is fairly old (5.0.77). What if you want to install the latest stable version of MySQL yet have the advantage of removing/re-installing the software using rpm(8)?

In this blog post, I will guide you with compiling MySQL from source code yet installing the software through rpm(8) so that we tune and

  [Read more...]
Downloading, compiling, and installing MySQL Server from source code
+0 Vote Up -0Vote Down

This content has been updated and moved to a new place.


If you are running any GNU/Linux server operating system like RHEL 5 or CentOS 5, you may probably install MySQL server that comes with the operating system packages either during the initial setup or later using yum(8). The advantage being addition/removal of packages either using the GUI package manager or rpm(8), yum(8). Fair enough. But unfortunately the MySQL package (mysql-server) that comes bundled with RHEL 5.5 or CentOS 5.5 is fairly old (5.0.77). What if you want to install the latest stable version of MySQL yet have the advantage of removing/re-installing the software using rpm(8)?


In this blog post, I will guide you with compiling MySQL from source code yet installing the software through rpm(8) so that we tune and



  [Read more...]
Open source or Open Core or Commercial... Does it matter??
+3 Vote Up -2Vote Down
This is my 2 cents in the Open Source vs. Open Code vs. Commercial debate. And it's a long one...

Maybe some of you reading this are offended already, but bear with me, I'll get there. The way I see the Open Source model, having worked with OSS at MySQL for 6+ years now, is that this is a great way of developing software. Not brilliant, but great, but I'll get there also.

Users of OSS, in my mind, are OSS users for one or more of three reasons:
  • It's Open - The users using OSS for this reason believes that being open is in and of itself a great thing, enough so to use OSS even when non-OSS is less expensive and/or better.
  • Cost - OSS is typically less expensive than non-OSS, and this is the reason these users get here. There are then 2 subgroups here, one that represents users that just aren't funded at all, many websites





  [Read more...]
GRAPH Engine Linux binaries in MySQL 5.0.86-d10 available now
+0 Vote Up -0Vote Down

At this point we have a 32-bit and a 64-bit Linux binary tarball, should work on most Ubuntu and CentOS and the like (I tested a few). Possibly OSX coming. Not sure on Windows right now.

For further details and download links, see yesterday’s release post.

GRAPH Engine source in MySQL 5.0.86-d10 available now
+1 Vote Up -0Vote Down

It’s time to play! A special thanks particularly to Antony Curtis for the excellent smart and actually very speedy coding, and for just being a great guy to work with. If you would like to utilise his ace MySQL knowledge and coding skills, do talk to me!

Right now, we have a source tarball available for you, patching OQGRAPH on top of a MySQL 5.0.86-d9-Sail (OurDelta) source. As you know MySQL 5.0 does not have engine plugins so patching is the only way we can put it in. This OQGRAPH codebase is licensed under GPLv2+.

Even though we’ve successfully built it on several platforms and architectures, since this is the first public release we’d like you to try it first, as we’re sure that there might be problems on some platforms. When we catch and fix those, we can do proper

  [Read more...]
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? :)
The pursuit of openness
Employee +4 Vote Up -2Vote Down

When I joined MySQL in 2006, after several profitable years as a consultant, I had a dream. I wanted to improve the product that had contributed to my professional success.

The first thing that I learned when I started the uphill task is that it was far more difficult than expected. MySQL called itself open source, but the development practices were for all practical purposes closed source. At the same time, I found that MySQL, below the surface, is an organization with complex and well oiled engineering practices.

Indeed, opening up the cathedral, as Lenz put it, was a hard nut to crack. We had a closed source revision control system, and our developers loved it so much, that any proposal to change it was met with strong opposition. We discussed technical matters behind the firewall. Our code review process, although technically demanding and very thorough, was kept

  [Read more...]
The pursuit of openness
Employee +0 Vote Up -0Vote Down

When I joined MySQL in 2006, after several profitable years as a consultant, I had a dream. I wanted to improve the product that had contributed to my professional success.

The first thing that I learned when I started the uphill task is that it was far more difficult than expected. MySQL called itself open source, but the development practices were for all practical purposes closed source. At the same time, I found that MySQL, below the surface, is an organization with complex and well oiled engineering practices.

Indeed, opening up the cathedral, as Lenz put it, was a hard nut to crack. We had a closed source revision control system, and our developers loved it so much, that any proposal to change it was met with strong opposition. We discussed technical matters behind the firewall. Our code review process, although technically demanding and very thorough, was

  [Read more...]
The pursuit of openness
Employee +0 Vote Up -0Vote Down

When I joined MySQL in 2006, after several profitable years as a consultant, I had a dream. I wanted to improve the product that had contributed to my professional success.

The first thing that I learned when I started the uphill task is that it was far more difficult than expected. MySQL called itself open source, but the development practices were for all practical purposes closed source. At the same time, I found that MySQL, below the surface, is an organization with complex and well oiled engineering practices.

Indeed, opening up the cathedral, as Lenz put it, was a hard nut to crack. We had a closed source revision control system, and our developers loved it so much, that any proposal to change it was met with strong opposition. We discussed technical matters behind the firewall. Our code review process, although technically demanding and very thorough, was

  [Read more...]
MySQL Gets Closer to GlassFish -- Mårten's Move
Employee_Team +0 Vote Up -0Vote Down

Just slightly over a year ago I posted Welcome Aboard, MySQL! from Orlando. Since then we have worked together in many things including GF Bundles, IdMgr, Telco, OSS Price/Performance, Pricing, even Legal. Possibly the biggest impact of the acquisision has been on the non-engineering side: the MySQL team

  [Read more...]
Speaking at FOSDEM
Employee +0 Vote Up -0Vote Down

I am getting ready to FOSDEM, the biggest European gathering of free and open source software enthusiasts. The event is held in Brussels, Belgium, on February 7-8, 2009.

MySQL has a developers room on Sunday, with a schedule rich of well known names and juicy topics.

I will present a talk about partitions in MySQL 5.1.

Lenz will have a talk in the main conference, on MySQL high availability.

There is a wiki page on MySQL Forge where we will provide last minute information.

See you all in Brussels!

Speaking at FOSDEM
Employee +0 Vote Up -0Vote Down

I am getting ready to FOSDEM, the biggest European gathering of free and open source software enthusiasts. The event is held in Brussels, Belgium, on February 7-8, 2009.

MySQL has a developers room on Sunday, with a schedule rich of well known names and juicy topics.

I will present a talk about partitions in MySQL 5.1.

Lenz will have a talk in the main conference, on MySQL high availability.

There is a wiki page on MySQL Forge where we will provide last minute information.

See you all in Brussels!

Speaking at FOSDEM
Employee +0 Vote Up -0Vote Down

I am getting ready to FOSDEM, the biggest European gathering of free and open source software enthusiasts. The event is held in Brussels, Belgium, on February 7-8, 2009.

MySQL has a developers room on Sunday, with a schedule rich of well known names and juicy topics.

I will present a talk about partitions in MySQL 5.1.

Lenz will have a talk in the main conference, on MySQL high availability.

There is a wiki page on MySQL Forge where we will provide last minute information.

See you all in Brussels!

An interview with The Data Charmer.
Employee_Team +0 Vote Up -0Vote Down
By Giuseppe Maxia

The Data Charmer, a.k.a. The Wizard, is a free lance database consultant, with a long career in several IT fields. He is well known for his Perl and SQL expertise,although he is proficient in several other languages, such as C++, shell scripts, and Italian.

He has a split personality, one of which lives in virtual space and time, floating around UTC+1. The other (or the others, as there is a dispute about how many they are) is less documented and some people believe it to be fictional. He teaches Creative Biography at the University of Euphoria, CA (also known as Euphoric State).


G.M. Hello, D.C. Thanks for agreeing to be interviewed. I'll start with a question that most people ask. Who are you?

D.C. This is not really a question I'm willing to answer. Besides, the answer would be  [Read more...]

The Rise of The Open Source Software Stack
Employee +0 Vote Up -0Vote Down
The rise of the "Open Source Software Stack" reached another milestone today.  

Sun released a SPECjAppServer2004 performance result using top-to-bottom Open Source Software stack components:  OpenSolaris/MySQL/Glassfish.   At 1197.10 JOPS, the performance is highly respectable - not setting any land speed records, but it is in the ball park with other results using the same class of hardware.   The difference (of course) is in the price/performance.

The other contenders were two [


  [Read more...]
Barack Obama and MySQL
Employee +0 Vote Up -0Vote Down

It is widely acknowledged that Barack Obama put together the best minds and team together to run his campaign. One of the proof points is that his website www.barackobama.com was driven by MySQL! 

From Jonathan's blog:
http://blogs.sun.com/jonathan/

" On behalf of Sun Microsystems, I would like to offer my sincerest congratulations to President elect Barack Obama. What an extraordinary accomplishment.

I would also like to extend my congratulations to his web team for having chosen MySQL as the platform behind their election web site, BarackObama.com. "


Barack Obama and MySQL
Employee +0 Vote Up -0Vote Down

It is widely acknowledged that Barack Obama put together the best minds and team together to run his campaign. One of the proof points is that his website www.barackobama.com was driven by MySQL! 

From Jonathan's blog:
http://blogs.sun.com/jonathan/

" On behalf of Sun Microsystems, I would like to offer my sincerest congratulations to President elect Barack Obama. What an extraordinary accomplishment.

I would also like to extend my congratulations to his web team for having chosen MySQL as the platform behind their election web site, BarackObama.com. "


Barack Obama and MySQL
Employee +0 Vote Up -0Vote Down

It is widely acknowledged that Barack Obama put together the best minds and team together to run his campaign. One of the proof points is that his website www.barackobama.com was driven by MySQL! 

From Jonathan's blog:
http://blogs.sun.com/jonathan/

" On behalf of Sun Microsystems, I would like to offer my sincerest congratulations to President elect Barack Obama. What an extraordinary accomplishment.

I would also like to extend my congratulations to his web team for having chosen MySQL as the platform behind their election web site, BarackObama.com. "


Change Has Come to America
Employee +0 Vote Up -0Vote Down

On behalf of Sun Microsystems, I would like to offer my sincerest congratulations to President elect Barack Obama. What an extraordinary accomplishment.

I would also like to extend my congratulations to his web team for having chosen MySQL as the platform behind their election web site, BarackObama.com.

Lest many of you get your hopes up, we cannot guarantee the White House to all MySQL users.

250 Sun/MySQL engineers at Software Freedom Day in Riga
Employee +0 Vote Up -0Vote Down

The Software Freedom Day 2008 is approaching. The event will take place wherever you want. If you are interested, just register a team, gather a few friends, and start organizing that in your street, at a local pub, in your university, or wherever you see fit.

MySQL people are very conscious about open source, and we decided to participate to the event somehow. For starters, Sun is a sponsor, and that is a good sign that we care. But we need also to make our presence known. So the initial plan was that every Sun community would encourage its members to create a local Software Freedom Day team and

  [Read more...]
Suse 11: So far, so good
Employee +0 Vote Up -0Vote Down

After 4 good releases, Ubuntu let me down with 8.04. Maybe it was the timing - I upgraded my laptop as part of restoring it from a hard drive crash a few weeks ago - but isn't a brand new disk a good time to change your OS version? 


 On the upside, Hardy was the first OS I've installed where I opted to keep the default wallpaper (the bird is purty). And I'm pretty sure suspend (nVidia driver and all) was working better than previously, which is always good news. 


But I no longer had use of the VGA port for cloned or extended desktop, and I was unable to find a solution. That's a dealbreaker for anyone who needs to do frequent presentations (or, for that matter, uses their laptop as a primary workstation and has a > 15" monitor).


Worse, vpnc was, at best, squirrelly. I do quite a lot over VPN, and we still have two of them (Sun




  [Read more...]
Suse 11: So far, so good
Employee +0 Vote Up -0Vote Down

After 4 good releases, Ubuntu let me down with 8.04. Maybe it was the timing - I upgraded my laptop as part of restoring it from a hard drive crash a few weeks ago - but isn't a brand new disk a good time to change your OS version? 


 On the upside, Hardy was the first OS I've installed where I opted to keep the default wallpaper (the bird is purty). And I'm pretty sure suspend (nVidia driver and all) was working better than previously, which is always good news. 


But I no longer had use of the VGA port for cloned or extended desktop, and I was unable to find a solution. That's a dealbreaker for anyone who needs to do frequent presentations (or, for that matter, uses their laptop as a primary workstation and has a > 15" monitor).


Worse, vpnc was, at best, squirrelly. I do quite a lot over VPN, and we still have two of them (Sun




  [Read more...]
Suse 11: So far, so good
Employee +0 Vote Up -0Vote Down

After 4 good releases, Ubuntu let me down with 8.04. Maybe it was the timing - I upgraded my laptop as part of restoring it from a hard drive crash a few weeks ago - but isn't a brand new disk a good time to change your OS version? 


 On the upside, Hardy was the first OS I've installed where I opted to keep the default wallpaper (the bird is purty). And I'm pretty sure suspend (nVidia driver and all) was working better than previously, which is always good news. 


But I no longer had use of the VGA port for cloned or extended desktop, and I was unable to find a solution. That's a dealbreaker for anyone who needs to do frequent presentations (or, for that matter, uses their laptop as a primary workstation and has a > 15" monitor).


Worse, vpnc was, at best, squirrelly. I do quite a lot over VPN, and we still have two of them




  [Read more...]
Open Source Day, Rome - June 10, 2008
+0 Vote Up -0Vote Down

With a few days of delay, I want to share my impressions about Red Hat's Open Source Day presented in Rome on June 10, 2008.

The Event

Event was organized really well, Red Hat took responsibility of everything and all went smoothly toward the end. There were more than 200 attendees and the hall was crowded of Open Source enthusiasts, customers and others waiting for interesting speeches and a juicy agenda. General impression was very good, a lot of attention from both community attendees and customers willing to deeper their Open Source knowledge and listening to shining or emerging stars in the field.

A rich agenda gave everyone a bunch of new ideas to think about.

MySQL/Sun

Luca Gargaglione catalyzed attendees attention by explaining How and Why MySQL



  [Read more...]
Open Source Day, Rome - June 10, 2008
+0 Vote Up -0Vote Down

With a few days of delay, I want to share my impressions about Red Hat's Open Source Day presented in Rome on June 10, 2008.

The Event

Event was organized really well, Red Hat took responsibility of everything and all went smoothly toward the end. There were more than 200 attendees and the hall was crowded of Open Source enthusiasts, customers and others waiting for interesting speeches and a juicy agenda. General impression was very good, a lot of attention from both community attendees and customers willing to deeper their Open Source knowledge and listening to shining or emerging stars in the field.

A rich agenda gave everyone a bunch of new ideas to think about.

MySQL/Sun

Luca Gargaglione catalyzed attendees attention by explaining How and Why



  [Read more...]
Open Source Day, Rome - June 10, 2008
+0 Vote Up -0Vote Down

With a few days of delay, I want to share my impressions about Red Hat's Open Source Day presented in Rome on June 10, 2008.

The Event

Event was organized really well, Red Hat took responsibility of everything and all went smoothly toward the end. There were more than 200 attendees and the hall was crowded of Open Source enthusiasts, customers and others waiting for interesting speeches and a juicy agenda. General impression was very good, a lot of attention from both community attendees and customers willing to deeper their Open Source knowledge and listening to shining or emerging stars in the field.

A rich agenda gave everyone a bunch of new ideas to think about.

MySQL/Sun

Luca Gargaglione catalyzed attendees attention by explaining How and Why



  [Read more...]
Introducing MySQL's telco endeavours
Employee_Team +0 Vote Up -0Vote Down

We (in the Telecom team at MySQL) have been debating whether we should call this blog 'MySQL in Telco' or 'MySQL in Communications'. Naming discussions tend to take long time, and this one was no exception.

From a US perspective, it appears that Telecom is an outdated term. Wireless carriers and cable television companies do not consider themselves as Telecom companies. Maybe for this reason, large US-headquartered vendors including Sun, HP, IBM and Oracle all have a 'Communications & Media' practice.

From a European perspective, Telecom is used for equipment vendors and service providers. Companies like Logica, Cap Gemini, Atos Origin and TietoEnator refer to the vertical as 'Telecom & Media'.

Of the global SI's in India, Wipro and TCS refer to Telecom while Infosys talk about Communications.

As a working title we at one time

  [Read more...]
Introducing MySQL's telco endeavours
Employee_Team +0 Vote Up -0Vote Down

We (in the Telecom team at MySQL) have been debating whether we should call this blog 'MySQL in Telco' or 'MySQL in Communications'. Naming discussions tend to take long time, and this one was no exception.

From a US perspective, it appears that Telecom is an outdated term. Wireless carriers and cable television companies do not consider themselves as Telecom companies. Maybe for this reason, large US-headquartered vendors including Sun, HP, IBM and Oracle all have a 'Communications & Media' practice.

From a European perspective, Telecom is used for equipment vendors and service providers. Companies like Logica, Cap Gemini, Atos Origin and TietoEnator refer to the vertical as 'Telecom & Media'.

Of the global SI's in India, Wipro and TCS refer to Telecom while Infosys talk about Communications.

As a working title we at one

  [Read more...]
Showing entries 1 to 30 of 44 Next 14 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.