Duplicate indexes in MySQL
Why do we sometimes want to keep duplicate indexes? I’ve done dutiful DBA work in the past to...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management (101)
Using the MariaDB CONNECT engine to merge heterogeneous data sources
I was reminded recently of a project I did during a DevDays week at WebAssign in 2014. The...
Extended events - fetching API CURSORS
Forum questions can sometimes cause distractions for me because they pique my interest at times,...
Investigating IO performance on Amazon EC2
I published a blog post called " Investigating IO Performance on Amazon RDS for Oracle" recently,...
MySQL on AWS: RDS vs EC2
When moving your MySQL instances to AWS, you would probably have to deal with this decision. This...
Investigating IO performance on Amazon RDS for Oracle
I've recently been involved in quite a few database migrations to Oracle RDS. One thing that I had...
How to store performance counters directly on SQL server using TypePerf Command
Introduction Every DBA should know that the baseline is one of the most important pieces to make a...
Five things to know before migrating your data warehouse to Google BigQuery
In September, Google announced enhancements to BigQuery, the Google Cloud Platform service for...
Monitor Cassandra using Zabbix
Zabbix is an open-source based enterprise level monitoring solution that aims for monitoring...
Enqueue bytes - is that a pun?
Sometimes it is necessary to put on your uber-geek hat and start using cryptic bits of code to...
