(Giuseppe Maxia) When a new version of MySQL appears, the first source of information for the brave experimenter is a page in the manual named What is new in MySQL X.X, also known as MySQL in a nutshell. For MySQL 5.7, the in-a-nutshell page lists quite a lot of changes.
Tag: Open Source
Write-heavy workload vs the MongoDB optimizer
(Mark Callaghan) We experienced wasted disk IO from the MySQL query optimizer a few years back and fixed it via FORCE INDEX hints. I think I am experiencing wasted disk IO from the MongoDB optimizer during recent tests with the insert benchmark.
Write-heavy workload vs the MongoDB optimizer
(Mark Callaghan) We experienced wasted disk IO from the MySQL query optimizer a few years back and fixed it via FORCE INDEX hints. I think I am experiencing wasted disk IO from the MongoDB optimizer during recent tests with the insert benchmark.
MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right
(Roel Van de Paar) Welcome to the 10th episode in the MySQL QA series! Today we’ll talk about reproducing and simplifying: How to get it Right.
MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right
(Roel Van de Paar) Welcome to the 10th episode in the MySQL QA series! Today we’ll talk about reproducing and simplifying: How to get it Right.
Max_used_connections per user/account
(Shinguz) How many connections can be opened concurrently against my MySQL or MariaDB database can be configured and checked with the following command:
Max_used_connections per user/account
(Shinguz) How many connections can be opened concurrently against my MySQL or MariaDB database can be configured and checked with the following command:
A Roundup of Popular MySQL Mobile Apps for Android
(Rob Gravelle) Not so long ago, I compiled a list of the most popular MySQL mobile apps for iOS. Shortly thereafter, I wrote a follow-up on Navicat’s brand new Navicat iOS app that was specifically designed for their Navicat Cloud service.
A Roundup of Popular MySQL Mobile Apps for Android
(Rob Gravelle) Not so long ago, I compiled a list of the most popular MySQL mobile apps for iOS. Shortly thereafter, I wrote a follow-up on Navicat’s brand new Navicat iOS app that was specifically designed for their Navicat Cloud service.
on ORDER BY optimization
(domas mituzas) Generally in MySQL we send queries massaged to a point where optimizer doesn’t have to think about anything. In our major user database environment 99.9% of queries don’t have alternative query plans available (either because of forced indexes or just straightforward Primary Key read