mysql

What to do with optimizer hints after an upgrade? At a recent optimizer webinar, I talked about MySQL introducing a new style for hints, and that MySQL 5.7 also added support for more hints, see Sergey Glukhov’s blog. A question I got at the end of the webinar was what to do with the hints in the application code after an upgrade?… Source: What to do with optimizer hints after an upgrade?

Making GET_LOCK behavior more predictable cross version with query rewrite MySQL has supported the GET_LOCK() function for a large part of its history. As the manual notes, GET_LOCK() can be used to implement application locks or to simulate record locks. Changes in MySQL 5.7 In MySQL 5.7 we improved GET_LOCK() to be based on our internal meta-data locking system (MDL).… Source: Making GET_LOCK behavior more predictable cross version with query rewrite

Performance Schema is a mechanism to collect and report run time statistics for running MySQL server. These statistics are stored-in and fetched-from internal memory buffers. In MySQL 5.6 GA, memory for these buffers is allocated during MySQL server startup with either user specified configuration values or with default values that autosize.… Source: mysqlserverteam.com

MySQL Server has an extensive collection of SQL modes which control a range of behavior ranging from compatibility modes for other RDBMS dialects (ANSI_QUOTES, PIPES_AS_CONCAT) to security (NO_AUTO_CREATE_USER) to explicit storage engine selection (NO_ENGINE_SUBSTITUTION) to restricting lossy implicit data conversions (STRICT_TRANS_TABLES, etc.). … Source: mysqlserverteam.com

MySQL Community Server 5.5 (5.5.48 GA, published on Friday, 05 Feb 2016) Source: mysql-releases