Week three was rather short, with 3 public holidays around here intervening…
(See this post for background information on MySQL Function of the Day)
Week Three:
Week Two:
I’m still looking for new entries. I get quite a few suggestions, but not all of them make it into quiz questions. Do send in your suggestions!
In mysql>, you already know that hitting return on this:
SELECT 1+1, 2+2;
returns this:
+-----+-----+ | 1+1 | 2+2 | +-----+-----+ | 2 | 4 | +-----+-----+
What happens if you instead hit return after the following line?
SELECT 1+1, 2+2\\g
or this one?
SELECT 1+1, 2+2\\G
Hint: Fire up an instance of mysql> and read the messages at the start of the session. (and while there, also type in the examples. They won’t do any damage).
Answer: \g works just the same as ; .
\G does the same thing, too, but the output is displayed “vertically”, i.e. with one column name/field value per line. This is …
[Read more]While visiting the CeBit Trade Show in Hannover on 2008-03-06, Kaj and myself stopped by the booth of our new employer for meetings with some of our new colleagues. During our stay, they performed a short video interview with us (in German), to get our take on the MySQL acquisition and what this means to us and our users - it is now available from the Sun@CeBit2008 pages. Enjoy!
I'm often asked what interview questions should be asked of a new DBA you are considering to hire. Mistakes in a DBA hire can cost an organization a lot of money and hurt morale. There are a lot of factors that determine how well a DBA will fit into an environment. I thought I would share some of the things I consider when I interview a new DBA. These questions can be asked to any type of
How do you return a dataset using MySQL
Proxy?
This being a common task, as many that we will see in these
pages, it is worth implementing with a function.
When you return a dataset, there are two main cases:
The first case is quite simple:
function simple_dataset (header, message)
proxy.response.type = proxy.MYSQLD_PACKET_OK
proxy.response.resultset = {
fields = {
{type = proxy.MYSQL_TYPE_STRING, name = header}
},
rows = {
{ message}
}
}
return …[Read more]
Wed 26 March at 2pm GMT/3pm CET we will present a new webinar on
MySQL for Online Applications. Details and registration are
here.
MySQL finds its sweet spot in online and web 2.0 application,
because of the scalability reliability and the ease of use of the
server. In a typical approach, users start with a simple
architecture, with one server, then they need to scale in order
to support the increasing number of users and the demand for more
computer resources.
During the presentation, we will talk about the common ways to
scale-out, how to provide high availability and about the common
components of a web 2.0 solution and its interaction with the
database.
The Q&A will be posted on this blog.
Matthew Aslett and I are in San Francisco for the next few days at the Open Source Business Conference (OSBC). We will be moderating a total of three panels this year. Matthew’s panel on the the state of the open source database market is especially interesting, given that we are days away from publishing a report on the same topic (more details on that in a day or two). For those of you reading this blog entry from OSBC, I am hoping you’ll attend the panels listed below…
Tuesday, March 25, 11:30am - 12:20pm
The Future of the Operating System
Raven Zachary, Research Director, Open Source, The 451 Group
(Moderator)
Dirk Hohndel, Chief Linux and Open Source Technologist,
Intel
James Hughes, Sun Fellow & VP, Sun Microsystems
Roger Levy, …
April 14-17th is going to be an exciting time. Why? Because the 2008 MySQL Conference and Expo is going to be held in Santa Clara, CA. Who would want to miss out on a chance to lurk around, let alone talk to, some of the smartest people in the MySQL world? Well, those who don't have at least $1000+, of course. A 3 day pass to the conference without tutorials costs a whopping $1199. A full pass would dry up your pockets $1499.
Well, "good news everyone". Thanks to Sheeri Cabral of The Pythian Group, PlanetMySQL.org, Jeremy, and, …
[Read more]
We had a workshop in Stockholm in early March to discuss what can
be done to innovate MySQL in a number of areas. Most of the work
here will not be useful code in yet a year or two and a lot
longer before it'll be used in Enterprise Ready binaries.
Obviously there is no guarantee that this early work will reach
production binaries. This work is part of an aim at advancing the
MySQL Architecture in the next few years.
One interesting topic we discussed was Pushdown of Query
Fragments to Storage Engine.
A Query Fragment is a piece of an SQL query, for example in a
3-way join any join of 2 tables in this query is a Query
Fragment, also the full query is a Query Fragment. As part of
this interface the storage engine can decide to perform its own
optimising using a new interface or it could rely on the MySQL
Server to handle this optimisation. If the Storage Engine decides
it can handle the Query Fragment and the optimiser …
The people, plain and simple.
I encourage you, if you are not part of the local MySQL community, then why not? Find a local MySQL Meetup group, attend the MySQL Conference, get online to IRC @ freenode#mysql, subscribe to some lists or read the forums. I didn’t meet these people being an observer, but part of the community.
As I wrote recently with some vacation time and the need to pick the brain of some experts I organized a quick trip to Germany to specifically visit Jan Kneschke and Paul McCullagh to improve my MySQL skills in certain areas on my own time …
[Read more]