(Ronald Bradford) I was surprised to find on one of my websites the message “Connect failed: Your password has expired. To log in you must change it using a client that supports expired passwords.
Tag: Open Source
MongoDB Administration Checklist for MySQL DBAs
(Alexander Rubin) In this blog, I discuss a MongoDB administration checklist designed to help MySQL DBAs.
MySQL spatial functionality – points of interest around me
(Shinguz) This week I was preparing the exercises for our MySQL/MariaDB for Beginners training. One of the exercises of the training is about MySQL spatial (GIS) features. I always tell customers: “With these features you can answer questions like: Give me all points of interest around me!”
How fall in love with Failing assertion: !m_fatal?
(Shahriyar Rzayev) The story about real love.
Galera Error Failed to Report Last Committed (Interrupted System Call)
(Manjot Singh) In this blog, we’ll discuss the ramifications of the Galera Error Failed to Report Last Committed (Interrupted System Call).
Generated MySQL Columns and Changing Values
(Dave Stokes) I was speaking at PHP[Tek] this week on the JSON Data Type and using generated columns. JSON columns can not be indexed but data from a JSON column can be extracted via a generated column and that column can be indexed. All was going well until someone asked me about modifying data in
Why you should take care of MySQL data types
(Shinguz) A customer reported last month that MySQL does a full table scan (FTS) if a query was filtered by a INT value on a VARCHAR column. First I told him that this is not true any more because MySQL has fixed this behaviour long time ago.
Looking inside the MySQL 5.7 document store
(Alexander Rubin) In this blog, we’ll look at the MySQL 5.7 document store feature, and how it is implemented.
The differences between IDEMPOTENT and AUTO-REPAIR mode
(Simon Mudd) I posted recently Lossless RBR for MySQL 8.0 about a concern I have about moving to minimal RBR in MySQL 8.0. This seems to be the direction that Oracle is considering, but I am not sure it is a good idea as a default setting.
pt-online-schema-change (if misused) can’t save the day
(Przemys³aw Malkowski) In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it.
