Blog: Dev MySQL Blog


209 blogs updated: 4 min. ago
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...
10
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
LOAD DATA INFILE into a BIT field
BIT values cannot be loaded using binary notation (for example, b'011010'). $ cat test.txt b'101010' 0b111000 ----- CREATE TABLE loadTest (b...
6
22-03-2017 18:58:47 Dev MySQL Blog MySQL
Quiz: Drop non-global users
Somebody asked on Freenode. I don't know why they wanted it. How would you drop all MySQL users who do not have "GRANT ALL ON *.* ... WITH G...
6
16-03-2017 17:00:04 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.