Recently, a benchmark comparing MariaDB and MySQL performance of ORDER BY over text columns didn’t really compare the same things. It was like comparing apples and oranges. The results are interesting of course, but I would like to point that…
If like me you are using MySQL Shell on many different systems and new installations, there are some commands I often use to benefit from my environment. What I really want to enable is the history of course, a nicer…
Yesterday my friend and ex-colleague Sveta published a blog post on how to migrate ownership of stored routines, views and triggers in MySQL. I usually agree a lot with her and even if I agree with what she wrote, there…
Recently I blogged about how to easily deploy a LAMP application to MDS. Using the Terraform module (OCI Resource Manager’s Stack) you also have the possibility to choose the PHP version to install: But as you should already know, not…
For performance, having a warm InnoDB Buffer Pool is very important. What does that mean ? A warm buffer pool means that the most used pages (working set) required by the production workload are already loaded in memory (in the…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.