Every now and again, when installing or upgrading MySQL on Windows, mysqld will not start, and it’s not due to any changes in the config file, using some old config option, permissions, something changed/removed, or anything else. It just simply fails, when you know it should work.

If you’re lucky, you’ll at least see the “Can’t create IP socket: No such file or directory” error in the error log.

However, the above error is generated when you invoke mysqld from the command line, and not via the service.

So if you’re not seeing any error on the console, or in the error log, when starting mysql via the service, then try it from the command line, so you can perhaps get more information in the error log.

The “Can’t create IP socket: No such file or directory” error is not very specific, nor is it helpful in determining the problem (especially since this in on Windows).

However, I’ve …

Some people seem unclear about whether there will be a 2011 MySQL conference from O’Reilly. There most definitely will be, and the CfP is open. We are looking for speakers. I’m on the speaker selection committee again this year for the Nth time, and my advice from past years still stands. This year we’re also looking for a greater diversity of database products, including other relational databases, NoSQL databases, and ancillary technologies.

Related posts:

1. Postgres folks, consider the 2011 MySQL …

Today is a big day for us working on the Drizzle project.  Our first official Beta! We have come a long way since the original MySQL 6.0 fork and we couldn’t have done it without the many community contributors involved, so many thanks to everyone who has helped us to get here (you know who you are).

One feature I have been working on recently is a MySQL migration tool.  This is basically a large modification to drizzledump which can do two extra things:

Firstly, it will automatically detect whether it is connecting to a MySQL or Drizzle server.  When connecting to a MySQL server it will automatically convert the table structures and data to create a Drizzle compatible dump file.

On top of this there are new options so that drizzledump can connect straight to a Drizzle server at the same time as a MySQL server and pipe the data …

This is a real question asked by Ivan Zoratti in his blog post. Another frequently heard question is : Should I still use MySQL now that my business is turning into a very serious business or should I switch to Oracle 11G.

To illustrate this question let me talked about MySQL users I met last [...]

I'll try to pass on some basic knowledge about those confusing stack traces we sometimes see in the mysql error logs.  What can you tell from them, what are they useful for, and how to validate them?
Debugging Crashes
We tried to improve postmortem debugging of crashes + stack traces in the error log:o) old versions of mysqld only printed numerical numbers instead of function names (if you're lucky!)o) some platforms/architectures printed no stack trace what-so-ever!o) …

I'm happy to announce that today we've released the first beta of Drizzle7! It's been an exciting ride so far and I'm expecting it to be only more exciting moving forward, now that I can actually say things like "yes! please try it!"

Some quick thoughts:

• We're speaking MySQL Protocol over 3306 by default - all of your MySQL connectors should work fine.
• drizzledump can read from MySQL and write to Drizzle.
• Replication has changed.
• Authentication has changed.
• Options processing has changed.
• There are tons of plugins.

We're actually going to care about breaking things moving forward. 

So... yes! please try it! I'm excited to find out what new things people are going to try to do with it. …

Yes, I said InnoDB+ with a plus sign at the end (also see the first comment here).

Please note that this blog post is only based on public information. It has absolutely nothing in it that I only could have learned from back when I worked at Sun or MySQL AB. Everything has links or pointers to where you can find the information out on the Internet and all thoughts are based on stringing these things together.

There was a lot of talk around the acquisition of Sun Microsystems by Oracle about MySQL (MySQL AB was bought by Sun). Some of the talk centred around Oracle and their ability to make a closed source version of MySQL with added bits that wouldn’t …

As an update to my prior post, I’ve added a form to the workbench plugin.  Now, the user can select a slow query log file and generate statistics from it.  The plugin provides information to answer the following questions:

Figure 1. Sample plugin form

• What type of queries run most often?
• What type of queries are the slowest?
• Which queries access the most rows?
• Which queries send the most data?

The plugin scans the slow query log, aggregates similar queries, and provides summary statistics for each group.  It’s very similar to the mysqldumpslow perl utility, which is included in the mysql bin folder. …

There is much excitement this week (understandably) about the formation of the Document Foundation and the LibreOffice fork of Openoffice.org.

Alan Bell sees correlation with the previous fork of Joomla from Mambo and has illustrated the potential impact that forking a project can have with a Google Trends chart, where Mambo is the blue line, and Joomla is the red line:

A similar chart for Debian (blue) and Ubuntu (red) is also instructive:

Or what about Nagios (blue) and Icinga (red):

Hmm. Maybe not the best example. …

Here is the comparison between mysql and postgresql for selects (only). I had used the same table that i had created earlier http://jayant7k.blogspot.com/2010/09/database-speed-tests-mysql-and.html while comparing insertion speed. I have created approximately 1,000,000 records in the table and ran selects on them. I also modified the configuration of both mysql and postgresql to enable faster