Original title was 'MySQL dropped from openSUSE!!!'. I wanted to have some shocking title, but I changed it as I don't really want to scare you so much But it is partially true, there is no mysql package in openSUSE anymore. But of course we DID NOT really dropped MySQL. In fact, we now have more MySQL in openSUSE then we ever had! Do I got your attention? Read on

What and why?

What really happened is that I renamed original MySQL package. Now it is called mysql-community-server. If you take a look at SUN/Oracle web, they call it like this for a long time, so it makes a little sense... As a result, there is no real package called mysql in openSUSE anymore. But mysql-community-server provides mysql so even if you try to install mysql, it will work. This change also have one funny consequence. Do you remember package mysql-client? Now it's called …

Original title was ‘MySQL dropped from openSUSE!!!‘. I wanted to have some shocking title, but I changed it as I don’t really want to scare you so much But it is partially true, there is no mysql package in openSUSE anymore. But of course we DID NOT really dropped MySQL. In fact, we now have more MySQL in openSUSE then we ever had! Do I got your attention? Read on

What and why?

What really happened is that I renamed original MySQL package. Now it is called mysql-community-server. If you take a look at SUN/Oracle web, they call it like this for a long time, so it makes a little sense… As a result, there is no real package called mysql in openSUSE anymore. But mysql-community-server provides mysql so even if you try to install mysql, it will work. This change also have one funny consequence. Do you remember package mysql-client? Now it’s …

How To Set Up WebDAV With MySQL Authentication On Apache2 (Ubuntu 9.10)

This guide explains how to set up WebDAV with MySQL authentication (using mod_auth_mysql) on Apache2 on an Ubuntu 9.10 server. WebDAV stands for Web-based Distributed Authoring and Versioning and is a set of extensions to the HTTP protocol that allow users to directly edit files on the Apache server so that they do not need to be downloaded/uploaded via FTP. Of course, WebDAV can also be used to upload and download files.

(No three-part series is complete without a part 4, right?)

Here is an analogy that describes well what group commit does. We have a bus driving back and forth transporting people from A to B (corresponding to fsync() "transporting" commits to durable storage on disk). The group commit optimisation is to have the bus pick up everyone that is waiting at A before driving to B, not drive people one by one. Makes sense, huh? :-)

It is pretty obvious that this optimisation of having more than one person in the bus can dramatically improve throughput, and it is the same for the group commit optimisation. Here is a graph from a benchmark comparing stock MariaDB 5.1 vs. MariaDB patched …

Starting from tomorrow (1st of June) I will officially become an Oracle employee. It is quite funny how many companies you can change without even applying for another job. ;-)
I've been hired by MySQL in the beginning of 2008, a few months later it has been acquired by Sun and after about a year we've been acquired again, this time by Oracle.

I personally consider this a new beginning and I join Oracle with a lot of enthusiasm. After all I'm now part of a company that has a huge set of products and technologies and it is like a playground for me.

I'm afraid I've not blogged frequently in these months, but I plan to write more and more in the future. This short post is just to wish good luck to all the Dolphins who have joined Oracle and all those who are swimming in a different ocean.
…

This blag was originally posted at http://cafuego.net/2010/05/26/fast-paging-real-world

Some time ago I attended the “Optimisation by Design” course from Open Query¹. In it, Arjen teaches how writing better queries and schemas can make your database access much faster (and more reliable). One such way of optimising things is by adding appropriate query hints or flags. These hints are magic strings that control how a server executes a query or how it returns results.

An example of such a hint is SQL_CALC_FOUND_ROWS. You use it in a select query with a LIMIT clause. It instructs the server to select a limited numbers of rows, but also to calculate the total number of rows that would have been returned without the limit clause in place. That total number of rows is stored in a session variable, which can be retrieved …

The primary responsibility of MySQL professionals is to establish and run proper backup and recovery plans. The most used method to backup a MySQL database is the mysqldump utility. This mysqldump utility creates a backup file for one or more MySQL databases that consists of DDL/DML statements needed to recreate the databases with their data. To [...]

Let's start with the plugin. The documentation has been updated to cover this new feature. And 27 new tests give me some confidence that it …

Having a reverse-proxy web cache as one of the major infrastructure elements brings many benefits for large web applications: it reduces your application servers load, reduces average response times on your site, etc. But there is one problem every developer experiences when works with such a cache – cached content invalidation.

It is a complex problem that usually consists of two smaller ones: individual cache elements invalidation (you need to keep an eye on your data changes and invalidate cached pages when related data changes) and full cache purges (sometimes your site layout or page templates change and you need to purge all the cached pages to make sure users will get new visual elements of layout changes). In this post I’d like to look at a few techniques we use at …