(Rik Prohaska) MySQL recently added support for JSON data in an experimental labs version based on MySQL 5.7.7. It would be cool to store JSON data in TokuDB tables.
Tag: Open Source
Getting EXPLAIN information from already running queries in MySQL 5.7
(Miguel Angel Nieto) When a new version of MySQL is about to be released we read a lot of blog posts about the performance and scalability improvements. That’s good but sometimes we miss some small features that can help us a lot in our day-to-day tasks.
Getting EXPLAIN information from already running queries in MySQL 5.7
(Miguel Angel Nieto) When a new version of MySQL is about to be released we read a lot of blog posts about the performance and scalability improvements. That’s good but sometimes we miss some small features that can help us a lot in our day-to-day tasks.
Exploring MySQL 5.7’s Geo-Spatial Functions
(Rob Gravelle) For those of you interested in Geolocation applications who read my MySQL: Calculating Distance Based on Latitude and Longitude tutorial, I have some good news: the latest development releases include some new Geo-Spatial functions.
Exploring MySQL 5.7’s Geo-Spatial Functions
(Rob Gravelle) For those of you interested in Geolocation applications who read my MySQL: Calculating Distance Based on Latitude and Longitude tutorial, I have some good news: the latest development releases include some new Geo-Spatial functions.
Removal and Deprecation in MySQL 5.7
(Erlend Dahl) With the shipment of the first release candidate (RC) of MySQL 5.7, the next major version of the server is rapidly shaping up.
Removal and Deprecation in MySQL 5.7
(Erlend Dahl) With the shipment of the first release candidate (RC) of MySQL 5.7, the next major version of the server is rapidly shaping up.
Hooray for Data Structures… Where Are They?
(Cole Kelley) The Key-Value Pair is my favorite programming tool. Most SQL type databases lack this feature in it simplest form. Some would argue, “Well that’s because databases don’t need dah-blah-dee-blah-blah…”
Hooray for Data Structures… Where Are They?
(Cole Kelley) The Key-Value Pair is my favorite programming tool. Most SQL type databases lack this feature in it simplest form. Some would argue, “Well that’s because databases don’t need dah-blah-dee-blah-blah…”
Speed up GROUP BY queries with subselects in MySQL
(David Ducos) We usually try to avoid subselects because sometimes they force the use of a temporary table and limits the use of indexes. But, when is good to use a subselect?