The MySQL DevRoom at FOSDEM is ready. The schedule has been voted. Thanks to all who have participated. Now, let's make sure that the event is successful. The schedule is juicy, and not only because I have three talks in it!
| Sunday 2012-02-05 | |||
| Event | Speaker | Room | When |
|---|---|---|---|
| All you need to know about migrations and you never dared to ask | … |
I am currently playing a lot with the new memcached interface to
MySQL. Making MySQL a "NoSQL" solution.
Why should I access the same data via SQL and noSQL
protocol? A simple noSQL protocol like memcached only
has lightweight access methods like "set" or "get". No complex
parsing, no optimizing, no execution of expressions. And this
additional overhead in SQL can be tremendous: I did a set of
SELECT statements only based on primary key. Buffer cache is 50%
of the table size. With ENGINE=InnoDB it takes 7.6 seconds to
read the data. If I switch to BLACKHOLE engine it takes 6.4
seconds! BLACKHOLE has no code in the storage engine. So queries
on BLACKHOLE engine create only load on parser and optimizer but
nothing in the storage engine. But if I run on InnoDB it adds
only 1 second or 15% runtime. Obviously the main part of
execution time is outside the storage engine. Erkan found the
same behaviour …
I’m just about to get on a plane to head to my inaugural SCALE event. It’s their tenth year running!
In a world filled with NoSQL related media, its kind of nice to see that on Friday January 20 2012, we have a MySQL room right next to the PostgreSQL room (schedule). It is awesome to see that the track will have participation from Oracle, Monty Program Ab, and SkySQL Ab.
On Saturday for the main tracks, I’ve got a talk about the growing MySQL diaspora (just got larger this year in case you haven’t paid attention to the packaged up Galera product!). This one is a constant work in progress and I’m hoping to complete research closer towards March ’12.
Monty Program and SkySQL are also sharing a booth in the …
[Read more]
In 2008 my career took a sudden unexpected turn into the world of
MySQL when I was offered a job at Sun. Since then MySQL and
it's forks have been a big part of my life. The whole
community (I mean the people, not the companies) around MySQL are
part of what really drove me.
Unfortunately to me something has changed. I am not exactly
sure what it is, but I am sure it is not just me because others
have expressed it in conversation too. I wasn't enjoying
things as much as I used to and for several reasons, some related
to this, I have been quite ill.
Recently I was approached by HP's new cloud division who wanted me to work on
OpenStack. It seemed the perfect opportunity
to start something new inside a new vibrant community. That
is not to say I have anything against my previous …
Patrick Hurley has been successfully delivering his presentation entitled “MySQL: The Least an Oracle Professional Needs to Know” at various conferences.
Oracle DBAs may appreciate his blog post “MySQL: An Introduction for Oracle DBAs”:
“You are an Oracle Database Administrator. You enjoy looking after Oracle databases and you are really good at it. In the corner of the machine room, on the edge of your peripheral vision, is a server running a database called MySQL….
…One day your manager calls you into his office, “Can you just have a quick look at that MySQL database server, the one with the website and the blog on it? You know, make sure it’s secure and stuff. Shouldn’t be too hard for an Oracle DBA like …
[Read more]Patrick Hurley has been successfully delivering his presentation entitled “MySQL: The Least an Oracle Professional Needs to Know” at various conferences.
Oracle DBAs may appreciate his blog post “MySQL: An Introduction for Oracle DBAs”:
“You are an Oracle Database Administrator. You enjoy looking after Oracle databases and you are really good at it. In the corner of the machine room, on the edge of your peripheral vision, is a server running a database called MySQL….
…One day your manager calls you into his office, “Can you just have a quick look at that MySQL database server, the one with the website and the blog on it? You know, make sure it’s secure and stuff. Shouldn’t be too hard for an Oracle DBA like …
[Read more]
I think you have heard me say it before, but in this case I think
repetion is needed: We should be much more innovative in the
database world. And no, I am not talking NoSQL here, not at all.
For all the good things with the NoSQL technologies and the
movement itself, it's not really innovative. Rather, in my mind,
NoSQL sacrifices functionality for performance, largely. The
schema-less design of most of these technologies is probably the
one aspect I would consider innovative, the rest is just RAM
based storage, sharding, key-based lookups and good, old
B-Trees.
Talking about B-Trees, isn't it time we retired them soon? There
should be better ways if indexing data. Look at something like
Mongo. With MongoDB, you really want to have your indexes
in-memory, all of them, without that, performance will be awful
(there are exceptions though, but in general this is true). Now,
a B-Tree is an index mechanism that has worked well, as the …
High Availability is one of the hottest topics for MySQL DBAs. As a matter of fact, when we (SkySQL) are called by users and customers, the top two questions for our PS team are:
Since MySQL is the most used online database, these two questions are totally appropriate. Although the two concepts walk together, they should not be confused.
We refer to scalability when we define that a system must sustain a specific workload, measured in different ways – response time, latency, transactions or operations per second to name few, or a combination of them. So, we define the level of scalability we want to achieve and we design a system that can scale to that level.
We refer to high availability when we define that a system must be available, within …
[Read more]
In our recent release of Percona Server 5.5.19 we introduced new value
for innodb_flush_neighbor_pages=cont.
This way we are trying to deal with the problem of InnoDB flushing.
Actually there is also the second fix to what we think is bug in InnoDB, where it blocks queries while it is not needed (I will refer to it as “sync fix”). In this post I however will focus on innodb_flush_neighbor_pages.
By default InnoDB flushes so named neighbor pages, which really
are not neighbors.
Say we want to flush page P. InnoDB is looking in an area of 128
pages around page P, and flushes all the pages in that area that
are dirty. To illustrate, say we have an area of memory like …
db4free.net is joining the protest against SOPA & PIPA and will stay down for 24 hours, starting January 18, 2012 at 02:00 UTC.
Learn more on what this is all about at americancensorship.org …
… and why the WEB GOES ON STRIKE …
… or watch some of the many videos related to SOPA on YouTube.