Blog: Dev MySQL Blog


210 blogs updated: 70 min. ago
MySQL NDB Cluster Backups
Today - 31 March - is world backup day, so I thought I would write a little about backups in MySQL NDB Cluster. Just because NDB Cluster off...
7
31-03-2018 08:49:42 Dev MySQL Blog MySQL
What is MySQL NDB Cluster?
I have had the opportunity to write a blog for Apress with a brief introduction to MySQL NDB Cluster. The blog gives a brief overview of the...
4
14-02-2018 08:41:27 Dev MySQL Blog MySQL
Overview of the MySQL Server Architecture
Sometimes it can be useful to take a step back and look at the world from a bit larger distance than usual. So in this blog, I will take a l...
26
27-11-2017 09:47:48 Dev MySQL Blog MySQL
New Book: Pro MySQL NDB Cluster
It is with great pleasure, I can announce that a new book dedicated to MySQL NDB Cluster has just been released. The book Pro MySQL NDB Clus...
30
11-11-2017 01:22:20 Dev MySQL Blog MySQL
GTID_INTERSECT
There's a GTID_SUBTRACT function, and the manual shows how to write your own cheap GTID_UNION, but not a GTID_INTERSECT. Fortunately it's ea...
6
04-11-2017 22:50:32 Dev MySQL Blog MySQL
ERROR 3037 (22023): Invalid GIS data provided to function st_geometryfromtext.
1. Watch the parentheses. It's: ST_GeomFromText('POLYGON( (outerRing), (innerRing), (innerRing), ...)') The inner rings are optional. If you...
12
18-07-2017 21:10:56 Dev MySQL Blog MySQL
On slave_parallel_workers and the logical clock
How can you tell if a given workload on the master could be replicated with many parallel workers on the slave? The slave_parallel_type=LOGI...
12
11-07-2017 18:34:29 Dev MySQL Blog MySQL
InnoDB Locks Analysis: Why is Blocking Query NULL and How To Find More Information About the Blocking Transaction?
This post was originally published on the MySQL Support Team Blog at on 14 April 2017. Consider the scenario that you execute a query. You e...
9
30-05-2017 12:05:27 Dev MySQL Blog MySQL
Working Around MySQL Cluster Push Down Limitations Using Subqueries
This post was originally published on the MySQL Support Team Blog at on 5 August 2016. I worked on an issue recently where a query was too s...
27
30-05-2017 05:31:31 Dev MySQL Blog MySQL
InnoDB Locks Analysis: Why is Blocking Query NULL and How To Find More Information About the Blocking Transaction?
Consider the scenario that you execute a query. You expect it to be fast - typically subsecond - but now it take not return until after 50 s...
15
15-04-2017 06:49:02 Dev MySQL Blog MySQL


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.