If you have ever felt the need of measuring how much of your resources a MySQL process is eating up, you're welcome to share my experience on the subject, reading Measuring resources for a MySQL server on Linux, which also introduces mysqlresources, a new command line tool that gets your server's statitics from the operating system and prints a nice report.

With MySQL, it's easy to get statistics from the server itself, but sometimes you need a view from the outside. mysqlresources does just that. Read on.

The MySQL UG will have a meeting in Catro Pub next Thusday (11. July) @19.00. It will be pleasure for me to meet some MySQL fans from Denmark for a beer (or more).

The address is :
Nørrebrogade 209
2200 København N

Map?

MySQL { MySQLUG{
Denmark

Partha Dutta posted pretty interesting post about iSCSI vs SCSI performance using SysBench.

This is nice to finally see some iSCSI benchmarks done with MySQL - something we were planning to do for a while but never ended up doing, mainly due to lack of hardware available for tests. It is also good to see Sysbench being used, as It is developed by our team, even more I write first version of this tool myself, for performance research (The new version was complete rewrite).

The problem I see in this test however - the benchmark is not fully described which makes it hard to judge what they really mean. Was it OLTP test or some other combination ? Was default table size used (that one is pretty small and would typically keep load CPU bound)

The …

What is Wiki

A wiki (IPA: [?wi?.ki?] or [?w?.ki?] [1]) is a type of website that allows users to add, remove, or otherwise edit and change most content very quickly and easily, sometimes without the need for registration.

This ease of interaction and operation makes a wiki an effective tool for collaborative writing. More in Wikipedia

MySQL Wiki
After the WebTech conference I discovered the MySQL wiki. It is still on development phase, becouse there is not a lot of materials in there, but is pleasure for me to contribute

I make a new Category called MySQL events worldwide. If you have information about such events, …

Greg Lehey wrote today Is MySQL getting buggier?. The underlying question of his comments is a more fundamental and passionate topic, and especially for me. That is “Software Quality”.

The quintessential question is this. “How do you determine the ’software quality’ of a product?” And then quickly followed by, “How do you benchmark this with other software products?”

The short answer to second question is simple. You can’t. The reasons why become apparent in addressing the first question. (There’s a mathematical term for this two question situation, another one of the million things to research and remember one day).

15 years ago as part of my masters research I worked on “Improving Software Quality and Software Productivity”. At the time when I started, I found that these were generally considered …

We've spent a lot of time looking at bugs in the last few months; some people claim that MySQL is getting buggier. Doubtless we have more bugs than we should; that goes for just about any serious piece of software. But how buggy is the product really? How does it stack up with other software, both open source and proprietary? Is it worse than it was, say, a year ago?

I'll leave the discussion of the relative quality of open source and proprietary software for another day; there are too many variables. But let's look at the MySQL bugs database. As I write this, there are a total of 20,879 bugs in the database. Of those, nearly 10,000 have been submitted in the past 12 months. But looking back, the first real bug report (BUG#2) wasn't submitted until 12 September 2002, not …

In this Developers Zone article we take an in-depth look at how the ALTER TABLE command is implemented in MySQL Cluster 5.0.

Alfresco had a nice review in InfoWorld recently.  Its a powerful Content Management System (CMS) suitable for document sharing in the enterprise.  If you've read this blog previously you've probably seen I've been very positive on Alfresco.  They've got a great user interface and a very well thought out architecture.  Which is not surprising as the guys at Alfresco have been doing Content Management Systems since before it was an acronym!  Check out their latest release version 1.3.  It's easy to set up and install and adheres to the latest standards.  And it's built on a fully open source stack.

• InfoWorld: Alfresco Delivers Open CMS Alternative
• …

I finally got around to reading The Cathedral and the Bazaar — I’d known about the collection of essays since it was first published in 1999, and kept meaning to read it. Heck, that link goes to the entirety of the essays, free, online. However, I never did read it, but I recently received a copy of the book, and have been reading it on my commute to work.

It’s very engaging, and still accurate, even now. Of course I think about how MySQL’s growth and business model as I’m reading it.

One of the tenets that keeps appearing is that “Brooks’ law that adding more people adds more complexity and actually slows a project down doesn’t apply to open source.” He gives a few reasons, mostly communication, but there’s one crucial point he misses.

Brooks’ law doesn’t apply to open source because there are little or no startup …

From time to time I install MySQL from the development tree, to see what's new, and in the latest one I found a pleasant surprise:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.1.12-beta

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql [localhost] {datacharmer} ((none)) > show variables like "%log";
+--------------------------------+-------+
| Variable_name                  | Value |
+--------------------------------+-------+
| back_log                       | 50    |
| general_log                    | OFF   |
| innodb_locks_unsafe_for_binlog | OFF   |
| log                            | OFF   |
| slow_query_log                 | OFF   |
| sync_binlog                    | 0     |
+--------------------------------+-------+
6 rows in set (0.00 sec)

mysql [localhost] {datacharmer} …