The Percona version of MySQL has been such a good replacement for the generic MySQL version that many of the features and options that existed in Percona have been merged into the generic MySQL. Innodb_fast_checksum was an option added to … Continue reading →

I've written two separate posts about the MySQL 5.6 temporal column format change, but I haven't yet addressed the problem with the way this upgrade was implemented. Essentially, the problem is that the implicit format upgrade causes a write-blocking full table rebuild the first time you run ALTER TABLE after upgrading, even if the ALTER TABLE command is an online DDL operation that normally doesn't block writes.

This behavior is well intentioned, but harmful. The intent is for the server to tack on a seemingly innocuous column format upgrade to my existing ALTER TABLE command, but when it changes my DDL from non-blocking …

In the MySQL team, we have been working really hard on refactoring the optimizer and improving the cost model. The hacks of storage engines lying to the optimizer are being rolled back, and your chances of getting an optimal query plan should now be much higher than in prior releases of MySQL.

The optimizer team has also allowed cost constants to be configurable on both a server and a storage engine basis, and we are confident that the default InnoDB engine will always work “as good as MyISAM” (which has a natural advantage, in that the optimizer was originally largely built around it.)

Today, I want to issue a challenge:

Find an example where the …

We are pretty much raving fans of CircleCI and we are not ashamed to say it. Here’s why.

What Does CircleCI Do For Us?

It would be reasonable to describe CircleCI like this:

• continuous integration and testing
• compiles our code for us
• automated QA

But that misses the point, because what they really do is they help us delight our customers. And they don’t just provide tools or ingredients or recipes for this. They provide a solution. I know it’s a buzzword and I have avoided saying “solution” since back in the day when I was a .NET developer using Visual Studio. But it is the only word that describes what CircleCI does for us.

We have a hard challenge/problem: in order to provide the absolute best service for our customers, we must be able to ship improvements in minutes with confidence. …

Using MySQL Enterprise Monitor with the MySQL Enterprise Firewall

Using MySQL Enterprise Monitor 3.0.22, the following newly added variables for the MySQL Enterprise Firewall are added : Ref :  http://dev.mysql.com/doc/relnotes/mysql-monitor/3.0/en/news-3-0-22.html

• System Variables:
  
  • mysql_firewall_max_query_size
  • mysql_firewall_mode
  • mysql_firewall_trace
• Status Variables:
  
  • Firewall_access_denied
  • Firewall_access_granted
  • Firewall_cached_entries

For information about MySQL Enterprise Firewall, you can refer to the information on Web  …

State Snapshot Transfer (SST) is a way for Galera to transfer a full data copy from an existing node (donor) to a new node (joiner). If you come from a MySQL replication background, it is similar to taking a backup of a master and restoring on a slave. In Galera Cluster, the process is automated and is triggered depending on the joiner state.

SST can be painful in some occasions, as it can block the donor node (with SST methods like mysqldump or rsync) and burden it when backing up the data and feeding it to the joiner. For a dataset of a few hundred gigabytes or more, the syncing process can take hours to complete - even if you have a fast network. It might be advisable to avoid e.g. when running in WAN environments with slower connects and limited bandwidth, or if you just want a very fast way of introducing a new node in your cluster.

…

Architecture of WEBM system.

Reference:

http://www.vmcd.org/2014/10/webm_v2-has-been-released/
http://www.vmcd.org/2014/09/webm-mysql-database-performance-web-monitor/

View this PDF:

http://www.vmcd.org/docs/How%20to%20configure%20WEBM.pdf

Dear all - we are growing, and we want you to hop on our train! We recently released product integrations with PagerDuty, VictorOps, Slack, and Hipchat so you can notify your team of all the (important) things. Last month, we announced Heroku support, and our partner program has just launched.

In the words of Baron Schwartz, “Monitoring does not exist in a vacuum, and building strong relationships with other products and companies at a technical and business level is a priority for us. We always planned for this, but we didn’t plan for the demand,” he added. “The response from customers, the opensource community, and other companies has surprised us, and we’re investing even more resources than we’d planned.”

Read the full …

The world’s scientific communities are abuzz today thanks to NASA’s New Horizons probe and its mission to Pluto, which achieved the closest approach of its flyby this morning and started collecting a wealth of new information on our solar system’s tiniest and most distant planet/not-planet. What did NASA share with us earthlings first? A picture, of course. The most glamorous profile ever recorded of Pluto, the King of the Kuiper Belt, graced the front pages of our newspapers and greeted readers with what will surely become an iconic shot. NASA knows that for the layman, nothing is quite as exciting as a spectacular photo of a celestial body, taken at a higher-resolution than ever before. With all that empty space out there a lot of people just want to know, What can we see?

But let’s not forget: New Horizon’s $700,000,000 price tag …

MySQL information_schema comes with useful information about the database instance, status, … etc. which is needed for daily DBA work.
There are some simple queries on the information_schema that I use on my daily basis in which I’m writing this post for my reference and maybe a good reference for someone else too …

Finding tables without Primary or Unique Keys:

PKs are so important, especially, for InnoDB tables as MySQL uses PKs as a clustered index and having no PKs might lead to severe performance problems.

Also having no PKs is one of the main causes of slave lagging problems mainly when using RBR (Row-Based Replication), e.g. if a delete statement on the master will delete 1 million rows on a table without PK, a full table scan will take place. This “might” not be a problem on the master but on the slave 1 million full table scan will take place – because changes to the individual rows are being …