Posts by Marco Tusa
Why this article? First, I had fun digging in the code. Then, I was reading about the future improvements for MySQL 5.6 and about some currently in 5.5. Most of them are well covered by people with more expertise than me. So I read, but after a while I became curious, read the code, and performed tests. I was looking at how the new Purge thread mechanism work and its implications. Here’s what I found.
This post contains a brief list of what I have found interesting during the last two weeks. Up to now, April has been a great month for MySQL…
Here are my notes on the third session I attended today, entitled “MySQL Cluster Performance Tuning”.
Here are my notes from the first session I attended today,entitled “Using and Benchmarking Galera in Different Architectures”.
Here are my thoughts on the “Boost Your Replication Throughput with Parallel Apply, Prefetch, and Batching” presentation I attended today.
Migrating to MySQL might seem attractive from a cost perspective, but is your application really a good candidate for this? What will you need to change? What features of your current database do you rely on, and which features in MySQL might be a good replacement or substitute? What is the likely cost and effort of a typical migration project?
In this post, I provide a brief overview and my own comments on a few presentations I attended today at the 2012 MySQL Conference. Enjoy!
I am reading the announcement about the Percona MySQL event in place of the O’Reilly.
What I see and what I feel is that the whole MySQL community, including Oracle, Percona, SkySQL,MariaDB and any other company doing business with MySQL have lost a good opportunity (so far).
Let us talk how OPTIMIZE partitions doesn’t work and what to do. I have set up a simple test instance with two tables, and use my stresstool (java), to fill the tables and play with the inserting threads.
Why am I still doing a post on this? Because I still see MySQL configurations that DBAs seem to use as separate assignments without taking into account the consequences of over-allocation and what impact it has on MySQL server memory usage.