The new release of Maatkit has a useful feature in mk-index-usage to help you determine how indexes are used in more flexible ways. The default report just prints out ALTER statements for removing unused indexes, which is nice, but it's often helpful to ask more sophisticated questions about index usage. I'll use this blog's queries and indexes as an example.

The new feature lets you store the index usage into tables in a database, so you can query them with SQL. I logged all queries to the blog for a little while, and then secure-copied the query log to my laptop, which is across the continent. I used a variation on MySQL Sandbox to set up a little throw-away MySQL instance -- that took ten seconds. And then I set up an SSH tunnel from my laptop to the MySQL Performance Blog server -- another 30 seconds.

Now I'm set …

Or, how we evaluate a company’s open source-related business strategy.

Godwin’s law states: “As an online discussion grows longer, the probability of a comparison involving Nazis or Hitler approaches”.

An online discussion about open source-related business strategies is no exception. However, long before the Nazi comparison it is inevitable that someone will ask “is MySQL open core?”.

I updated our 2009 post “what is open core, and what isn’t” recently, and received some criticism of my statement that the MySQL strategy was not open core.

Since we have recently published a report including the results of our …

ncurses is a programming library providing an API, allowing the programmer to write text user interfaces in a terminal-independent manner.

MythTV is a home entertainment application, which is freely available as a open source solution for live streaming programs, and converts into a computer with the necessary supporting hardware components. This application is able to run on different operating systems such as Linux, Macintosh, FreeBSD, etc and primarily uses MySQL database as the backend to store the recordings. Having started in 2002, this application has undergone several developments and now is a competent combination of a TV and a computer. Having said that, at times you may face some issues while operating on the MythTV. Sometimes these issues may be because of corrupt database that can appear because of several reasons including virus infections, abrupt or unplanned system shutdowns, etc. You should try to fix such issues by using in-built MySQL methods failing which the use of a third-party MySQL repair software to repair MySQL database is a must.

Let us consider …

Dear MariaDB users,

MariaDB 5.2, a branch of the MySQL database which includes all major open source storage engines, myriad bug fixes and many community patches, has been released. It has all changes up to MySQL 5.1.51.

For an overview of what’s new in MariaDB 5.2.3, please see the release notes (5.2.2, 5.2.1, and 5.2.0 also).

MariaDB 5.2 includes a number of user enhancements including:

• Improved user statistics which help understand server activity better …

After my departure from Oracle, I received lots of emails and messages, people who asked me where I will land. Thanks to everybody for the kind words and the great comments. By the way, more than a landing, I am going to take off… :)
On October 29th I joined Ulf Sandberg, Kaj Arno and Mick Carney at SkySQL. I will lead the Field Services team in Europe, i. e. my team will help users and customers in designing and implementing solutions around the MySQL technology. This will be my main role but, as you may expect, in small companies (small compared to large Corporates like IBM or Oracle), you must wear many hats.
My long term goals have not changed: I want to serve the MySQL Community of users, developers and, of course, the SkySQL customers. I want to provide the best possible advise, the best services and solutions. I will be specifically focused on these aspects:
Continue to support MySQL as the de facto standard for …

You maybe already noticed, that MariaDB folks released their new stable version 5.2.3 today. And as we've got our great openSUSE Build Service, we already have this version packaged and you can install it easilly on openSUSE. I didn't had much time to test it deeply, I just tried that it runs, and that I'm able to connect to it, so it is currently in serveratabase:UNSTABLE repository, but after some testing, it will proceed futher If you want to try it, make sure to backup your data first! So on openSUSE you can use one click install to get MariaDB 5.2.3. For others, you can just use one …

You maybe already noticed, that MariaDB folks released their new stable version 5.2.3 today. And as we’ve got our great openSUSE Build Service, we already have this version packaged and you can install it easilly on openSUSE. I didn’t had much time to test it deeply, I just tried that it runs, and that I’m able to connect to it, so it is currently in server:database:UNSTABLE repository, but after some testing, it will proceed futher If you want to try it, make sure to backup your data first! So talks on openSUSE you can use one click install to get MariaDB 5.2.3. For others, you …

Now it's two and a half year since the last refactoring of HeidiSQL's dialog for editing user accounts. The current dialog was ok from a usability point of view, but it did not allow users to assign routine privileges on newer servers. And it edited and created users by updating the tables in the mysql db directly, which is error prone, complex and not recommended by MySQL.

The new dialog now does all updates by GRANT, REVOKE, RENAME USER and SET PASSWORD, as recommended by MySQL. The GUI has also evolved:
- you can clone users now
- the entered password must be repeated
- privilege names are painted in different colors for read, write and admin relevance
But see yourself:



To get it, just go to Help > Check for updates and install the latest build.