Search results for:Search results

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 …

Drupal is one of the most popular Content Management Systems CMS and is used increasingly in high visibility sites such as www whitehouse gov This has brought a lot of attention on how to get the most performance out of …

Many developers use master slave replication to solve a number of different problems including problems with performance supporting the backup of different databases and as a part of a larger solution to alleviate system failures Traditionally master slave replication is …

Every once in a while questions like the one in MySQL Bug 60843 or Bug 19567 come up What collation should i use if i want case insensitive behavior but also want all accented letter to be treated as distinct …