This is one of many perl script tools from Percona that makes life easier administrating, monitoring and testing mysql, this one solves the need to alter a table (adding a key, column, partitioning, etc…) on a production system that can’t be taken down. Many of the current Percona tools came from maatkit, developed by Baron [...]

MySQL database management tool ScaleBase virtualizes MySQL database, spreading database load into smaller bite-size chunks As an open source company, Mozilla developers make a lot of different versions of software code each day, and part of Sheeri Cabral’s job to keep track of them all: which ones work, which don’t, how many times they’ve been downloaded, and which have a [...] Read More

I will be presenting at the North East PHP Conference August 11th and 12th and then the Boston MySQL Users Group on Monday the 13th, both at the NERD Center.

Here is my reply to a recruitment agent that asked me if I know any other MySQL DBAs in the London area (I am currently not available):

Hello Mr.Agent, 

You are the 9th person to ask me that question in the last 2 weeks. Apparently, we are quite rare and any MySQL DBA sightings should be reported to the media.  

Best Regards 

Jonathan

I suspect there is a grain of truth in my joke...

While the underlying index should be opaque to the user of a DBMS with spatial features, the API used to define spatial types and operate on them is of course more visible. The relevant standard in this space is often referred to as "OpenGIS", however the Open Geospatial Consortium in fact defines a long list of standards. The standard relevant to SQL databases is known more precisely as "OpenGIS Implementation Specification for Geographic information - Simple feature access - Part 2: SQL option" aka "Simple feature access".

It is not meaningful to recite the standard at length in my blog, my focus is instead on actual implementations that I will blog about later. The following points are however worth noting:

read more

Yesterday we announced the availability of MySQL Connector/Python v1.0.5 beta. Today I’ve made it available on PyPI so it can be easily installed. Note that I did remove the old development release and when you upgrade or try v1.0.5, you should check the ChangeLog.

shell> pip install mysql-connector-python

For those wondering why the name includes ‘python’: it’s just to align it with other MySQL connectors and to keep the name consistent with other distribution types.

We welcome and appreciate feedback and comments for this first beta release through the forum and the …

MySQL 5.6.6 was released yesterday – the list of changes is impressive.

One of the new things added within 5.6.6 was the ALTER USER … PASSWORD EXPIRE statement, which allows an administrator to expire the passwords for a user, so that they must update their password on next login.

Unfortunately, this was released within 5.6.6 with a serious problem – already noted by Kolbe Kegel – as it updated the password column to an empty string, as well as setting the password_expired flag. This obviously has serious implications, that really …

MySQL 5.6.6 is out (I already posted one comment about it).

Overall I find the achivement with this release quite impressive. 5.6 is the beginning of a new way of *thinking the server*, I think. What we have is:

1) Lots of new features – in particular I note

* Security enhancements (but maybe not everything here is as it should be – read Kolbe Kegel’s comment)
* Memcached plugin for InnoDB
* Multithreaded replication on slaves
* …

This tutorial will demonstrate the MySQL tool explain which is a great tool offered by mysql to analzye queries for further improvement. To run the explain tool you just have to type the command EXPLAIN right before your select query and let MySQL execute it. MySQL will not execute the select query but will analyze it [...]

Hi Aaron, really nice article. we just discussed this replication and prodaction perfomance. Made a Russian translation of your article in my blog ( http://sorok7.blogspot.com/2012/08/mysql_7.html ) Thanks for article!