Recently I came across another configuration option I’d not heard of before. I profess to not know them all, however I do know when I find something unusual. If you are a beginner DBA, learn what is normal and expected, and identify what is out of the normal, investigate, research and question if necessary.

I gave away a MySQL Administrator’s Book based on seeing a configuration with safe-show-database, an option I’d not seen before, and then requesting people giving basic configuration options in that situation.

The latest is max_tmp_tables. So, what does the manual say for this option. I quote:

The maximum number of temporary tables a client can keep open at the same …

I figured that it was time to check out how to install, configure, run and use MySQL Cluster on Windows. To keep things simple, this first Cluster will all run on a single host but includes these nodes:

• 1 Management node (ndb_mgmd)
• 2 Data nodes (ndbd)
• 3 MySQL Server (API) nodes (mysqld)

Downloading and installing

Browse to the Windows section of the MySQL Cluster 7.0 download page and download the installer (32 or 64 bit).

MySQL Cluster Windows Installer

Run the .msi file and choose the “Custom” option. Don’t worry about the fact that it’s branded as “MySQL Server 7.0″ and that you’ll go on to see adverts for MySQL Enterprise – that’s just an artefact …

Hello everyone,

I began MySQL Magazine in the early summer of 2007. It was began, not as a lark, but without any idea that it would ever become so popular. It was just a way I thought I could contribute to the MySQL community. Over time it has grown very well with recent issues being downloaded around 10,000 times directly from the website. I have no way of counting other downloads although I know issues are posted in multiple other locations.

I have been debating for about six months on changing things up a bit. As I said in my last post, change for the sake of change is almost never good. This isn’t change just for change’s sake.   I am convinced that enlarging the old MySQL Magazine to include any open source db will be beneficial to everyone. More content and an exchange of …

It is a known fact that ext3 is not the most efficient file system out there and for example file removals can be painfully slow and cause a lot of random I/O. However, as it turns out, it can sometimes have a much more severe impact on the MySQL performance that it would seem. When or why?

When you run DROP TABLE there are several things that need to happen – write lock on a table so it cannot be used by any other thread, the data file(s) removal by the storage engine and of course in the end MySQL has to destroy the definition file (.frm). That's not all that happens, there is one other thing:

PLAIN TEXT CODE:

1. VOID(pthread_mutex_lock(&LOCK_open));
2. error= mysql_rm_table_part2(thd, tables, if_exists, drop_temporary, 0, 0);
3. pthread_mutex_unlock(&LOCK_open);
…

Business intelligence has been talked about for quite a while. Even today, while companies are looking to make budget cuts, some experts are saying that BI can be used to beat the recession.

When I hear about BI systems, the first thing that comes to my mind is a huge and expensive system that has very powerful servers, that sucks data from many sources and runs some intensive and even more expensive reporting suite. Since I had been involved in projects to set those systems up, I know that it can probably take around a year to complete.

So everyone is in fact thinking about saving money yet still being …

After a few years off, I've been doing some writing for Linux Magazine (which is on-line only) again recently. First off, my just published feature article is Drizzle: Rethinking the MySQL Database Kernel. As you might have guessed, it looks at Drizzle and some of the reasoning behind forking and re-working MySQL.

I'm also writing a weekly column that we've been calling "Bottom of the Stack" (RSS) which started a few weeks ago. Recent articles are:

• Sphinx: Search Outside the Box
• …

Open source and SMBs. New funding for Lucid Imagination. And more.

Follow 451 CAOS Links live @caostheory

On open source and SMBs
Savio Rodrigues contrasted Dell’s plans to target SMBs with bundles of hardware and open source with research from Forrester that indicated that SMBs are still wary of open source, while Matt Asay noted that there are significant opportunities for open source vendors if they can work out how to crack the SMB market and suggested that the way to make software easier for SMBs and to monetize it might actually be cloud-based computing.

OStatic noted that the issue may well be one of lack of awareness and that Dell’s initiative, as well as the …

The July meeting of the Boston MySQL User Group will feature Eric Day, a prominent Drizzle developer, talking about Drizzle and Gearman:

In this talk we will discuss two growing technologies: Drizzle and Gearman.

We will explain what the Drizzle project is, what we aim to accomplish, and an overview of where we are at. We will also be introducing the fundamentals of how to leverage Gearman, an open-source, distributed job queuing system. Gearman’s generic design allows it to be used as a building block for almost any use - from speeding up your website to building your own Map/Reduce cluster. We will tie Drizzle and Gearman together and demonstrate how they work in a custom Search Engine application.

————————

Here is the URL for MIT’s Map with the location of this building:
…

The first "barbecue" of the PHP BBQ tour has been held in Munich. A little more than 30 attendees came to the Hirschgarten restaurant. Unfortunately we could not have a BBQ due to bad weather. Nonetheless the event has been a success: for some it has been the first PHP community event. And, of course, you always meet and greet "countless" well known PHP hackers. Let me name only two of them: Johannes Schlueter, who helped to organize the event and Pierre Joye (and Jana and Spooky), my host. Credits also go to Johann-Peter Hartmann from Mayflower, Nils Hitze and …

The first "barbecue" of the PHP BBQ tour has been held in Munich. A little more than 30 attendees came to the Hirschgarten restaurant. Unfortunately we could not have a BBQ due to bad weather. Nonetheless the event has been a success: for some it has been the first PHP community event. And, of course, you always meet and greet "countless" well known PHP hackers. Let me name only two of them: Johannes Schlueter, who helped to organize the event and Pierre Joye (and Jana and Spooky), my host. Credits also go to Johann-Peter Hartmann from Mayflower, Nils Hitze and …