Featured blog posts

Enabling large pages on Oracle Database 11g running on IBM AIX

Enabling large pages on Oracle Database 11g running on IBM AIX

Apr 4, 2016 12:00:00 AM 3 min read
Best practice for setting up MySQL replication filters

Best practice for setting up MySQL replication filters

Apr 1, 2016 9:48:00 AM 11 min read
Connection timeout parameters in MySQL

Connection timeout parameters in MySQL

Mar 17, 2016 12:00:00 AM 6 min read
SQL Injection with MySQL SLEEP()

SQL Injection with MySQL SLEEP()

Mar 2, 2016 12:00:00 AM 4 min read
Data encryption at rest

Data encryption at rest

Feb 18, 2016 12:00:00 AM 9 min read
High "cursor: pin S wait on X" waits?

High "cursor: pin S wait on X" waits?

Nov 17, 2015 12:00:00 AM 1 min read
Detecting source of MySQL Queries with comments

Detecting source of MySQL Queries with comments

Feb 17, 2015 12:00:00 AM 1 min read
Availability Group - Delay with Listener Connectivity After Failover

Availability Group - Delay with Listener Connectivity After Failover

Jun 11, 2014 12:00:00 AM 4 min read
Guide to Cassandra Thread Pools

Guide to Cassandra Thread Pools

May 11, 2014 12:00:00 AM 9 min read
Meaning of "Disk Reads" Values in DBA_HIST_SQLSTAT

Meaning of "Disk Reads" Values in DBA_HIST_SQLSTAT

Nov 6, 2013 12:00:00 AM 6 min read
Duplication: divide et impera

Duplication: divide et impera

Sep 19, 2013 12:00:00 AM 9 min read
Configuring OID 11.1.1.6 Connector in OIM 11.1.2

Configuring OID 11.1.1.6 Connector in OIM 11.1.2

Jul 12, 2013 12:00:00 AM 6 min read
Hard Drive: Inner or Outer?

Hard Drive: Inner or Outer?

Jun 12, 2013 12:00:00 AM 5 min read
ODA Re-imaging Could Take Anywhere Between 20 and 120 Minutes

ODA Re-imaging Could Take Anywhere Between 20 and 120 Minutes

May 21, 2013 12:00:00 AM 3 min read
Change Views DEFINER Without ALTER VIEW: How to Fix Thousands of Views

Change Views DEFINER Without ALTER VIEW: How to Fix Thousands of Views

Oct 5, 2011 12:00:00 AM 2 min read
How I Find MySQL Fragmentation

How I Find MySQL Fragmentation

Oct 25, 2010 12:00:00 AM 2 min read
Using the Sphinx Search Engine with MySQL

Using the Sphinx Search Engine with MySQL

Aug 31, 2009 12:00:00 AM 4 min read
What Exactly is Swappiness?

What Exactly is Swappiness?

Apr 13, 2009 12:00:00 AM 5 min read
How To Access MySQL from Oracle With ODBC and SQL

How To Access MySQL from Oracle With ODBC and SQL

Mar 13, 2009 12:00:00 AM 5 min read
MySQL Memory Consumption

MySQL Memory Consumption

Jan 23, 2009 12:00:00 AM 3 min read
Audit a MySQL Instance with MySQLTuner

Audit a MySQL Instance with MySQLTuner

Oct 9, 2008 12:00:00 AM 4 min read
MySQL: Replacing URL Escape Sequences

MySQL: Replacing URL Escape Sequences

Sep 26, 2008 12:00:00 AM 1 min read
Using mysqld_multi to Manage Multiple Servers

Using mysqld_multi to Manage Multiple Servers

Jul 30, 2008 12:00:00 AM 3 min read
MySQL Back to Basics: Analyze, Check, Optimize, and Repair

MySQL Back to Basics: Analyze, Check, Optimize, and Repair

Jul 25, 2008 12:00:00 AM 7 min read
What Does GA (General Availability) Mean?

What Does GA (General Availability) Mean?

Jun 19, 2008 12:00:00 AM 1 min read
Database sharding and the end of RAID?

Database sharding and the end of RAID?

Jun 7, 2007 12:00:00 AM 1 min read
MySQL Memory Usage Profile Script

MySQL Memory Usage Profile Script

Apr 18, 2007 12:00:00 AM 5 min read
MySQL: Tuning filesorts and temporary tables

MySQL: Tuning filesorts and temporary tables

Jan 11, 2007 12:00:00 AM 3 min read
MySQL Recipes: Promoting a Slave to Master or Changing Masters

MySQL Recipes: Promoting a Slave to Master or Changing Masters

Dec 8, 2006 12:00:00 AM 2 min read