Search results for:Search results

The biggest concern with a slave is to ensure your data is consistent with the master End of story 3 of the biggest things I see when dealing with out of sync slaves Many users do not use the read …

I was recently debugging a stored procedure and could not easily identify the underlying reason for why it was failing It had a standard exit handler catch all for SQLEXCEPTION which was DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN SELECT END …

In a previous post I discussed debugging stored procedures with RESIGNAL which is of great value when troubleshooting errors raised by your stored procedures functions triggers and events as of MySQL MariaDB 5 5 However as of MySQL 5 6 …

If InnoDB or XtraDB in MySQL or MariaDB are interrupted while performing an ALTER TABLE they ll leave a temporary table sitting in your data directory This thing will be taking up space which is no good If you re …

In my previous blog post I described some of the key new replication features in MariaDB 10 that let this powerful open source database shine in web scale and analytical applications Now I d like to continue my tour of …

I m writing this blog as 2013 draws to an end Like many people do at this time of year I want to take a moment to reflect on the year gone by and to plan for the year ahead …

We could consider Big Data as the new hype of the moment Many believe that it brings eternal success and increased revenues to their companies It may be true that by analyzing Big Data many enterprise corporations will find new …

Sometimes MySQL just doesn t choose the most efficient way to execute a query GROUP BY is a good example A customer recently wanted to add a unique key over some columns of a large 50GB table and they first …