I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the…

The post MySQL Memory Usage Limits on 32 bit Linux first appeared on Change Is Inevitable.

I keep running in to issues with how folks use config.h, so I thought I'd clear up any confusion folks have. For those who haven't been following along at home, the autotools (i.e. autoconf and autoheader in this case) generate a file called config.h which contains a bunch of defines to help control the build based on what things exist or don't exist on your system. There are two main rules for this file that lots of folks get wrong:

1. config.h should ALWAYS be the first thing included by EVERY non-header C/C++ file in your project.
2. config.h should NEVER NEVER NEVER NEVER NEVER NEVER be installed.

Why?

For the first point, you must ensure that config.h is included first, because it sets behaviors. It must be included before any system headers because it may contain things that control the behavior of the system headers. It must be included before …

If you were wondering why you couldn’t login to your previously working Kontrollbase install in the several hours it was because of the News & Announcements section receiving improperly formatted data from the master news RSS feed, thus breaking the ExtJS DataGrid row data which resulted in an unterminated string literal error. The issue has [...]

I was contacted by Doug Henschen on Monday for an article he was writing for Intelligent Enterprise on Oracle’s just announced promises to the European Commission regarding MySQL.  It turns out Doug was polling all the major open source data warehousing and business intelligence vendors to get our perspectives on the promises, and it appears as if we all had roughly the same response:  “cautious optimism” as Doug put it.

Having invented the industry’s first SQL Chip that improves the performance and scalability of reporting and analytics for MySQL by 10x – 1000x, we have been keenly interested and aware of Oracle’s announced intent to acquire Sun, and along with it MySQL.  While we have architected our product to work with other database management systems …

One of the things that I am really happy about in MariaDB is that we have our releases available as apt (and yum for Centos) repositories. This is largely thanks to being able to build this on the OurDelta package build infrastructure (which again builds on things like the Debian packaging scripts for MySQL).

Something like the Debian apt-get package system (which is also used by Ubuntu) is one of the major innovations in the Free Software world in my opinion. Debian has spent many years refining this system to where it is today. Want to run the mysql client, but it isn't installed? Just try to run it on your local Ubuntu host:

    $ mysql
    The program 'mysql' can be found in the following packages:
     * mysql-client-5.0
     * mysql-client-5.1
    Try: sudo apt-get install <selected package>
    -bash: mysql: command not found

Installing …

I was contacted by Doug Henschen on Monday for an article he was writing for Intelligent Enterprise on Oracle’s just announced promises to the European Commission regarding MySQL.  It turns out Doug was polling all the major open source data warehousing and business intelligence vendors to get our perspectives on the promises, and it appears as if we all had roughly the same response:  “cautious optimism” as Doug put it.

Having invented the industry’s first SQL Chip that improves the performance and scalability of reporting and analytics for MySQL by 10x – 1000x, we have been keenly interested and aware of Oracle’s announced intent to acquire Sun, and along with it MySQL.  While we have architected our product to work with other database management systems …

I wanted to set up several servers on my machine using the Ubuntu distribution and control them using mysqld_multi: the typical way to manage several servers on your machine. However, I also wanted to use MySQL 5.1 and not 5.0, which is the default on Jaunty (Ubuntu 9.04).

About a month ago, I upgraded to Karmic Koala and one of the reasons were that MySQL 5.1 is used by default. Even though I could install the latest revision all the time, I usually want to use the real distributions for my private projects for a number of reasons.

I actually tried to upgrade to MySQL 5.1 on Ubuntu 9.04, but I discovered that all kinds of applications had dependencies on MySQL 5.0, so I avoided to upgrade at that time.

Anyway, the procedure for installing multiple servers on the same machine is this:

1. Shut down the running server.

   This is, strictly speaking, …

We're hiring. We are looking for the following qualifications:

1. Expert knowledge of MySQL. Not just "certified" -- years of production experience with it. You need to know server internals, for example. You need to be able to do anything from optimizing difficult queries to moving high-volume services between data centers without interruption.
2. Expert knowledge of InnoDB. You should understand its inner workings well enough to answer questions about its internals from memory, such as "how does the insert buffer work?" or "how does MVCC work on secondary indexes?" You should also know why it has trouble on some workloads and how to solve that.
3. Expert knowledge of Linux systems administration. You need to know how to solve issues with filesystems, hardware, and networking. You need to be able to use tools such as gdb, strace, tcpdump, etc to solve weird problems.
4. Expert with Apache, memcached, and other …

In one week, on December 24th, it will be exactly one year since I was first contacted by Packt Publishing. After reading several posts from this blog they asked me if I’d be interested in writing a MySQL administration cookbook with hands-on recipes for those among us who have to make sure the MySQL servers are kept running and in good shape.

Funny thing, I almost deleted their email, because initially I thought GMail’s spam filter had not caught some sort of bulk or phishing email, because I had never heard of Packt Publishing before and at first only saw an unfamiliar sounding sender’s name. As I was one of very few people in the office on that day I decided to read it anyways. Turned out to be not so spammy after all…

What followed were several weeks of sending mails back and forth, convincing a colleague to co-author and together set up a chapter outline. Finally, around February we started writing actual contents. …

A new round of GPL-based BusyBox suits has been filed, targeting big names in electronics and IT. We’ve long covered these series of GPL-based suits and settlements, but this latest round comes at an interesting time for open source software and its licensing.

First, we have the backdrop of the Oracle-Sun-MySQL acquisition, with opponents arguing to the world and the European Commission, which is reviewing the proposed merger before approving it, in part that the GPL is, ironically, granting too much power to its user, in this case Oracle. I’ve been quoted in the press and honestly agree with …