This Thursday (December 3rd, 16:00 UTC – note the different time), Bill Karwin will talk about Practical Full-Text Search in MySQL. He'll introduce and compare five different approaches of full-text search with MySQL, using built-in functionality as well as third-party tools. It's interesting to see how vastly performance can vary, depending on which tools you use for which purposes.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice …

We've got another round of free Windows-centric webinars coming up tomorrow:

Migrating from SQL Server to MySQL (North America)...covering the fundamentals of why and how to migrate, plus an apples to apples feature comparison. Register here

Windows Server 2008 Failover Clustering with MySQL (EMEA)...Mike Frank will run through step by step how to set up a development environment with minimal cost/effort that implements Windows Clustering and MySQL. Register here

Finally, check out LiveTime's presentation next week where they will demonstrate the methodology and toolset they use to perform free SQL Server to MySQL migrations for their customers. Register …

We've noticed contention in binary log syncing to disk, so I got back to micro-benchmarking edge cases.

So, on a hardware that is capable of doing around 15000 write operations a second (and that literally translates into >14000 write operations to a file), actual append performance can be quite different.

My freshly constructed benchmark did random 0-10240 byte writes, with fdatasync() after each. If it was doing these writes at full I/O capacity when it was writing to preallocated file (at 14000-14500 writes a second), whereas appends looked way worse:

Ext3: ~4500 w/s XFS: ~9000 w/s

Of course, iostat showed full I/O saturation in both cases - ext3 simply does more housekeeping work to expand files. Also - these numbers are on entirely idle system - expect quite a few variations with saturated ones.

This issue has been discussed before too: …

Here is another interesting problem:When trying to set up master to master replication from Server A to Server B, the replication user can login from A to B, but not the other way. The error thrown out by MySQL:ERROR 1130 (HY000): Host '' is not allowed to connect to this MySQL serverThings to check:1. Replication user password and host2. Ability to ping the remote server3. nslookup the remote

Dear MySQL Users,

We are proud to announce public Beta 2 of MySQL Workbench 5.2.

We want to thank all the people who tried MySQL Workbench 5.2 alphas and beta 1 and helped us out by filing bugs and providing valuable feedback.
The team has put in an all out effort to fix those reported bugs and enhance performance.

This build includes fixes for 54 bugs – 18 P1, 19 P2, 13 P3 and 2 P4 – as well as a few new features and some added fine tuning.

MySQL Workbench 5.2 Beta 2 provides:

1. Data Modeling
2. Query (upgrade from MySQL Query Browser)
3. Admin (upgrade from MySQL Administrator)

If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench

As always, you will find binaries for the various platforms on our download …

I’m sick of looking through chat logs to find an IP geo lookup database.

Now it’s here, possibly forever, or until I stop paying for hosting.

Brian Guy, a manager of MySQL's team at Sun Microsystems, says Disney falsely accused his 11-year-old son of hacking the Pirates of the Caribbean game.

This is a follow up on a previous post about Amazon’s EC2 cloud services. You may recall that I had the Kontrollbase demo server hosted there until I was hit with a >$370 bill for less than 2 weeks of service. Now, you may think you want to say “hey you should have known the [...]

OpenSQLCamp was a huge success! I took videos of most of the sessions (we only had 3 video cameras, and 4 rooms, and 2 sessions were not recorded). Unfortunately, I was busy doing administrative stuff for opensqlcamp for the opening keynote and first 15 minutes of the session organizing, and when I got to the planning board, it was already full….so I was not able to give a session.

• 
  
• Comparing Non-Relational Databases: MongoDB, Tokyo Tyrant, CouchDB by Igal Koshevoy of Pragmaticraft

The security plugin for MySQL namely Securich has been migrated to google code a while ago for availability and usability purposes. Last week I finished testing and made available version 0.2.0 which includes some important enhancements like

* Added reconciliation from mysql to securich during installation

The above feature enables the installation of securich on instances already in operation without loosing any of the current user base and associated privileges (unlike previous versions which were mostly usable on new instances without user base).

* Added mysql version check for connection kill using processlist view in information_schema available as from 5.1.7

* Added auditing of users changing password via MySQLs own `set_password`
* Added auditing of role creation and updates
* Added auditing of grants / revokes

With auditing, the dba will be able to look at when a particular permission …