MySQL has had basic support for Geospatial Data since 4.1, but has lacked some of the features of the OpenGIS specifications since then. The good news is, this is rapidly changing. Our own Holyfoot has been hammering away at WorkLog #1327, to provide precise functions for our GIS support.

Even better, it’s fast. How fast? Well, the good people at Oki Labs, apart from having implemented several new GIS functions for MySQL, have done some benchmarking, and it’s looking good. If you’ll excuse the cliched comparison to Postgres, here are the response times (seconds) of MySQL GIS vs. PostGIS in Oki’s test:

Sometimes you need to run EXPLAIN on long running queries. Most time EXPLAIN takes few seconds, but sometimes it looks like it executes query itself instead of using statistic.

Like in the example following:

mysql> explain select \* from (select sleep(10) as foo) bar;
+----+-------------+------------+--------+---------------+------+---------+------+------+----------------+
| id | select_type | table      | type   | possible_keys | key  | key_len | ref  | rows | Extra          |
+----+-------------+------------+--------+---------------+------+---------+------+------+----------------+
|  1 | PRIMARY     | <derived2> | system | NULL          | NULL | NULL    | NULL |    1 …

Sometimes when you do profiling you can see number like this in timestamps. Periodically in our patches there was Query_time: 18446744073709550.000 in slow.log file (well, it was fixed recently, but still appears in other places).

I faced this problem several years ago when only 2-core AMD Opteron systems appeared and I noticed sysbench getting crazy showing query execution time 18446744073709550.000 or like this.

Obviously this is unsigned integer which was received by subtraction bigger number from smaller.
But how it can be if we use:

start_time = clock_gettime(CLOCK_THREAD_CPUTIME_ID, &tp);
...
query_execution
...
end_time = clock_gettime(CLOCK_THREAD_CPUTIME_ID, &tp);

total_time = end_time - start_time;

How we can get query executed in negative time ? It would be too good to be real :).

After some research I found the reason, and it is …

Yesterday, the ebox and warp staff went to Alagon (25km from Zaragoza) to have a very nice BBQ, or should I say WBQ?

We had delicious food, drinks, music, a swimming pool and weather couldn’t be more perfect.

And also we ended up with a new guest in our home

View …

We got an interesting question on the documentation list the other day, which basically asked if we provided a service that listed changes to specific pages in the manual.

While I like the idea of such a service, the mechanics of making such a service work are very difficult. To start with, and to re-iterate something I have to explain again and again:

the MySQL documentation is rebuilt up to 10 times *every* day

We don’t have set schedules for when we release changes. We don’t bundle changes up and then produce a new reference manual on a set day of the month, or week. If I make a change to the documentation right now, there is every chance that you would see that change in the live docs at http://dev.mysql.com/doc within 3 hours, and for the PDF format, possibly even within the hour.

Yep, it happens that quickly. And that happens every day of the year …

So far I am pretty excited about using Oracle SQL Developer with MySQL. I spent about ten minutes installing Oracle SQL Developer, the MySQL J Connector and setting up SQL Developer to connect to MySQL.I've only been using it a few minutes and so far its been great to work with. Oracle SQL Developer has matured into a nice interface so its been really fun to work with. In terms of ease of

Installing Oracle SQL Developer was way too easy!Installing Oracle SQL Developer is pretty straight forward to install. You will need to install the Oracle SQL Developer software and the MySQL J Connector (JDBC driver). It then requires about two minutes to point and click through the setup of the MySQL connection using the JDBC driver in SQL Developer. Oracle SQL Developer has the following

The tasty new logo

We’ve been busy lately here at WordPress.com — we’ve had an announcement of a new or updated feature for you every day this week. Today, you’re getting a two-fer!

Earlier this week, we announced VideoPress, the great new video feature for WordPress.com. Now VideoPress has its own home on the web at VideoPress.com. We’ve also got a great video introduction created by our company auteur Michael Pick, so be sure to head over and check it out. We’ll be continuing to add features to VideoPress, including support for WordPress.org users, so stay tuned to VideoPress for all the latest. …

Since opening up the comment reply via email feature to everyone last month we’ve been continuing to improve it. Here are some of changes that have gone in during the last few weeks:

• Better detection of email auto responders / vacation messages
• Added a reminder to the bottom of comment notification emails about the reply via email feature
• Vastly improved support for non-English character sets
• Fixed a problem that some iPhone users were seeing
• Improved email address parsing for Blackberry users
• Fixed cases where signature blocks weren’t being properly removed
• Better paragraph formatting when parsing comments

And many little tweaks to deal with the oddities of various email clients. You’d be amazed how many email …

If you’ve pulled the latest Drizzle code from lp:drizzle, you may have noticed a new plugin/gearman_udf directory in there. This is a new UDF that acts as a Gearman client. This is mostly a port of the Gearman MySQL UDF I wrote, but I did it the proper C++ way to fit in better with Drizzle. It also uses the new plugin system Monty Taylor has been working in, which makes it much easier. :)

To use it, just make sure you have the Gearman C library installed and Drizzle will pick it up and build it for you. No extra configuration required!

The following example assumes you have a Gearman job server and a reverse worker running (see examples/reverse_worker in the C library package).

 …