Do you store date or time values in MySQL? Would you like to know how to avoid many possible types of pain, most of which you cannot even begin to imagine until you experience them in really fun ways? Then this blog post is for you. Here is a complete set of rules for how you can avoid aforementioned pain: All date and time columns shall be INT UNSIGNED NOT NULL, and shall store a Unix timestamp in UTC.

This April I am speaking at Percona Live: MySQL Conference and Expo 2014. I have always enjoyed this conference in the past, and am looking forward to participating as a speaker for the first time.

I am presenting two talks:

• Assembling the perfect MySQL toolbox
• Is performance_schema worth the overhead?

My first talk is for anyone who wants to make their life easier using MySQL tools. This would be a good companion talk to Daniel Nichter's …

The SQL Editor in MySQL Workbench 6.1 adds a new interface for query results.  This addition offers 4 new views to your query results, 2 for the result data itself and 2 for meta-information about the query that was executed.

Query Result Set Grid

The traditional result set grid. Run a SELECT query on a table with a primary key and you can edit the data. You must click the Edit button to enter edit mode.

Note: Until Workbench 6.1.1, the check was being done automatically for every SELECT query, but since that requires extra queries to MySQL, the check is now done on demand.

Result Set Form Editor

The new form editor for result sets comes in handy when you want to closely inspect the fields of each record (specially if it has multi-line text). You …

In a previous thread pool post, I mentioned that in Percona Server we used an open source implementation of MariaDB’s thread pool, and enhanced/improved it further. Below I would like to describe some of these improvements for transactional workloads.

When we were evaluating MariaDB’s thread pool implementation, we observed that it improves scalability for AUTOCOMMIT statements. However, it does not scale well with multi-statement transactions. The UPDATE_NO_KEY test which was run as an AUTOCOMMIT statement and inside a transaction gave the following results:

After analysis, we identified the major cause of that inefficiency: …

We proudly announce the new release of three standalone tools for MySQL and MariaDB servers. We believe that new features and improvements will help you simplify performing complicated every-day tasks in database management.

We proudly announce the new release of three standalone tools for MySQL and MariaDB servers. We believe that new features and improvements will help you simplify performing complicated every-day tasks in database management.

I currently have on a MySQL 5.6 database using innodb_file_per_table the following individual tablespace file.

schema/FTS_00000000000001bb_BEING_DELETED.ibd

The schema is all InnoDB tables, and there ARE NO Full Text Indexes. I cannot comment on if a developer has tried to create one previously.
I am none the wiser in explaining the ongoing use of these files, or if it can be/should be deleted.

On closer inspection there are infact a number of FTS files.

$ ls -al FTS*
-rw-r----- 1 mysql mysql 98304 Jan 29 16:21 FTS_00000000000001bb_BEING_DELETED_CACHE.ibd
-rw-r----- 1 mysql mysql 98304 Jan 29 16:20 FTS_00000000000001bb_BEING_DELETED.ibd
-rw-r----- 1 mysql mysql 98304 Jan 29 16:26 FTS_00000000000001bb_CONFIG.ibd
-rw-r----- 1 mysql mysql 98304 Jan 29 16:21 FTS_00000000000001bb_DELETED_CACHE.ibd
-rw-r----- 1 mysql mysql 98304 Jan 29 16:00 FTS_00000000000001bb_DELETED.ibd
-rw-r----- 1 mysql mysql 98304 Jan 29 16:20 …

New version of JSON UDF functions 0.2.2 have been just released. It is last maintenance release of 0.2 series. However it contains two new features:

JSON_VALID now accepts array as a root element of the JSON document (Bug#70567/17583282)

JSON functions can now be installed and uninstalled using a script (Bug#71263/18022788 Easy installation sql script).

This feature is Community contribution. Thank you, Daniel van Eeden!

This release also contains following bug fixes:

71050/17882710 json_extract returning same column twice if key names are not fully distinct. (Fixed for JSON_EXTRACT, JSON_CONTAINS_KEY, JSON_APPEND, JSON_REMOVE, JSON_REPLACE, JSON_SET) …

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.35. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 5.5? page in the MariaDB Knowledge Base for general information about the MariaDB 5.5 series.

Download MariaDB 5.5.35

Release Notes Changelog …

Red Hat recently released a beta of what will become the next version of their Enterprise Linux. As many people have noticed, Red Hat opted for a forked version of MySQL 5.5 (which GA’d 3 years ago). MySQL has come a long way in those three years, and MySQL 5.6 was released just under a […]