Percona XtraDB Cluster 5.6.28-25.14 is now the current release, based on the …[Read more...]
After feedback from my previous post on Linkbench I repeated it
for 7 days as the previous test ran for 1 day. The results are
the same -- MyRocks sustains more QPS, is more IO
efficient and provides better compression on IO-bound Linkbench.
Ask your MySQL vendor when they will support MyRocks. The
Yes, it has been a while since my last post. Still in the midst of MySQL ecosystem, and enjoying it tremendously. I thought I would make this post as it relates to a topic that has some varied results in the online world, and I would like to kick start this blog again. We'll see how that goes... :)
MySQL has been able to harness the potential of more powerful (CPU) and larger (RAM, disk space
In the MySQL world, we’re used to playing in the MySQL Sandbox. It allows us to deploy a testing replication environment in seconds, without a great deal of effort or navigating multiple virtual machines. It is a tool that we couldn’t live without in Support.
In this post I am going to walk through the different ways we have to deploy a MongoDB replica/sharding set test in a similar way. It is important to mention that this is not intended …[Read more...]
What about an hackathon to fix several issues in Innotop during this Fosdem 2016 edition ?
As the MySQL & Friends Devroom is on Saturday, Sunday would be the perfect day to find a nice place in the bar and work on resolving the open issues in Innotop to support MariaDB 10.1, MySQL 5.7…
If you are interested just send me a tweet (@lefred) and we can arrange this meeting.
I recently worked a lot on getting my local Windows box to
I got a lot of help from the below link that took me a few steps towards the
I had to save away my bison installation, uninstall it and then also
go into a registry editor and remove the various links to the Start Menu referring to
I think SQL is a very simple language, but ofcourse I'm
But even a simple statement might have more complexity to it than you might think.
Do you know what the result is of this statement?
SELECT FALSE = FALSE = TRUE;
scroll down for the answer.
The answer is: it depends.
You might expect it to return false because the 3 items …
A modern MySQL server contains a lot of useful meta-data in information_schema and performance_schema, which can help bring visibility into what is happening inside of your database server. However, sometimes this data is quite fine grained and needs finessing in order to get to that point
Back in October I have write about possible ways of running multiple MySQL instances on the same hardware. As the months passing by, the project of splitting our database schemas into standalone instances is closing in, so I started to check the different ways. I started with docker, because we’ll use containers anyway with the applications, and […]