The big change from MySQL 5.7 to 8.0 when it comes to spatial data, is the support for multiple spatial reference systems and geographic computations. This means that the SRIDs of geometries actually have meaning and affect computations. In 5.7 and earlier, however, the SRIDs are ignored, and all computations are Cartesian.…
There are many changes to spatial functions in MySQL 8.0:
- Old aliases for functions have been removed (after being deprecated in 5.7)
- Functions that don’t support geographic computations raise errors if called with geographic data in their arguments
- Many functions support geographic computations
The first two are failing cases.…
MySQL has had spatial indexes for many years, but they have all been Cartesian (X and Y coordinates) indexes. MySQL 8.0 adds support for geographic (latitude-longitude) indexes. In an earlier blog post, I described how the feature works. In this post, we’ll go into the details of how to upgrade from 5.7 to 8.0 if you have spatial indexes.…
MySQL 8.0 will be GA soon (just my assumption:
Oracle doesn't tell me anything about its release plans) and it's
time to think about having a look at it.
If this is your first try of MySQL 8, get prepared for several
impacting differences from previous versions.
In this article I won't tell you what you can do with MySQL 8: there is plenty of material about this, including in this very blog. I will instead concentrate on differences from previous versions that users need to know if they want to avoid surprises.
Data Directory
Let's start with an observation of the data directory.
After a standard installation, without any additional options, I
see the following:
Files that I expected to see
auto.cnf
ib_buffer_pool
ib_logfile0
ib_logfile1
ibdata1
ibtmp1
(dir) mysql
(dir) …
[Read more]
Percona announces the release of Percona Monitoring and Management 1.5.1. This release contains fixes for bugs found after Percona Monitoring and Management 1.5.0 was released.
Bug fixes
- PMM-1771: When upgrading PMM to 1.5.0 using Docker commands, PMM System Summary, PMM Add Instance, PMM Query Analytics dashboards were not available.
- PMM-1761: The PMM Query Analytics dashboard did not display the list of hosts correctly.
- …
Percona announces the release of Percona Monitoring and Management 1.5.0 on November 28, 2017.
This release focuses on the following features:
- Enhanced support for MySQL on Amazon RDS and Amazon Aurora – Dedicated Amazon Aurora dashboard offers maximum visibility into key database characteristics, eliminating the need for additional monitoring nodes. We renamed Amazon RDS OS Metrics to Amazon RDS / Aurora MySQL Metrics
- Simpler configuration – Percona Monitoring and Management now offers easier configuration of key Amazon RDS and Amazon Aurora settings via a web interface
- One-click data collection – One button retrieves vital information on server performance …
Percona announces the release of Percona Monitoring and Management 1.4.1 on Thursday, November 2nd, 2017. This release contains fixes to bugs found after Percona Monitoring and Management 1.4.0 was released. It also introduces two important improvements. We replaced the btrfs file system with XFS in AMI and OVF images, and the Prometheus dashboard has been enhanced to offer more information.
For install and upgrade instructions, see Deploying Percona Monitoring and Management.
Improvements
-
PMM-1567: The …
Percona announces the release of Percona Monitoring and Management 1.4.0.
This release introduces the support of external Prometheus
exporters so that you can create dashboards in the Metrics
monitor even for the monitoring services other than those
provided with PMM client packages. To attach an existing external
Prometheus exporter, run pmm-admin
add external:metrics NAME_OF_EXPORTER URL:PORT
.
The list of attached monitoring services is now available not
only in the tabular format but also as a JSON file to enable
automatic verification of your configuration. To view the list of
monitoring services in the JSON format run pmm-admin list
--json
.
In this release, Prometheus and Grafana have been upgraded. Prometheus …
[Read more]Percona announces the release of Percona Monitoring and Management 1.3.2. This release only contains bug fixes related to usability.
For install and upgrade instructions, see Deploying Percona Monitoring and Management.
Bug fixes
-
PMM-1529: When the user selected “Today”, “This
week”, “This month” or “This year” range in Metrics Monitor and
clicked the Query Analytics button, the QAN page
opened reporting no data for the selected range even if the
data were available.
- PMM-1528: In some cases, the …
Percona announces the release of Percona Monitoring and Management 1.3.1. This release only contains bug fixes related to usability.
For install and upgrade instructions, see Deploying Percona Monitoring and Management.
Bug fixes
- PMM-1271: In QAN, when the user selected a database host with no queries, the query monitor could still show metrics.
- PMM-1512: When clicking …