(dragkh) There are tools like pt-kill from the percona tool kit that may print/kill the long running transactions at MariaDB, MySQL or at Percona data instances, but a lot of backup scripts are just some simple bash lines.
Tag: Open Source
Optimizer hints in MySQL 5.7.7 – The missed manual
(Sveta Smirnova) In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about the hints. The only note which I found in the user manual about the hints is:
SSL/TLS in 5.6 and 5.5 – oCERT Advisory
(Todd Farmer) Today, oCERT published advisory 2015-003 describing a TLS vulnerability in MySQL and derivative products. The content isn’t exactly news – it is documented legacy behavior and the subject of an earlier blog post describing how MySQL Server 5.7 solves the problem.
Indexing 101: Optimizing MySQL queries on a single table
(Stephane Combaudon) I have recently seen several cases when performance for MySQL queries on a single table was terrible. The reason was simple: the wrong indexes were added and so the execution plan was poor. Here are guidelines to help you optimize various kinds of single-table queries.
Locking accounts in MySQL 5.7
(Todd Farmer) I’ve written previously about use cases where having accounts which cannot be used to establish client connections are useful. There are various hacks to accomplish this with legacy versions (insert invalid password hash into mysql.user table, etc.), and we introduced the mysql_no_logi
MySQL: Calculating Distance Based on Latitude and Longitude
(Rob Gravelle) With the proliferation of mobile devices being at an all-time high, there has never been more demand for “Find near me” type apps. As a result, just when you thought you were finally free of trigonometric functions like sine and cosine, you find out that they were useful after all!
Improved ALTER USER syntax support in 5.7
(Todd Farmer) Complimenting the expanded CREATE USER syntax introduced in MySQL Server 5.7.6 is more useful ALTER USER syntax. Before MySQL Server 5.7.6, ALTER USER could only be used to expire a user’s password.
MySQL Enterprise Edition Database Firewall – Control and Monitor SQL Statement Executions
(Tony Darnell) As of MySQL 5.6.24, MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall (it runs within the mysql database process) that enables database administrators to permit or deny SQL statement execution based on matching against whitelists of accepted st
Building a better CREATE USER command
(Todd Farmer) Prior to MySQL 5.7, the CREATE USER command had a number of limitations:
How to Easily Identify Tables With Temporal Types in Old Format!
(Nisha Gopalakrishnan) The MySQL 5.6.4 release introduced support for fractional values within the temporal datatypes: TIME, DATETIME, and TIMESTAMP. Hence the storage requirement and encoding differs for them in comparison to older (5.5 and earlier) temporal datatypes.