Featured blog posts
Log buffer #549: a carnival of the vanities for DBAs
![]()
Log buffer #549: a carnival of the vanities for DBAs
Jul 9, 2018 12:00:00 AM
2
min read
Log buffer #548: a carnival of the vanities for DBAs
![]()
Log buffer #548: a carnival of the vanities for DBAs
Jul 5, 2018 12:00:00 AM
2
min read
MySQL streaming Xtrabackup to slave recovery
![]()
MySQL streaming Xtrabackup to slave recovery
Jun 6, 2018 12:00:00 AM
8
min read
Authenticating Vault against LDAP for accessing MySQL through ProxySQL
![]()
Authenticating Vault against LDAP for accessing MySQL through ProxySQL
May 1, 2018 12:00:00 AM
11
min read
MySQL high availability with HAProxy, Consul and Orchestrator
![]()
MySQL high availability with HAProxy, Consul and Orchestrator
Apr 23, 2018 12:00:00 AM
5
min read
MySQL log rotation
![]()
MySQL log rotation
Mar 22, 2018 12:00:00 AM
3
min read
MySQL 5.7 Multi-threads replication operation tips
![]()
MySQL 5.7 Multi-threads replication operation tips
Feb 16, 2018 12:00:00 AM
2
min read
How to immediately kill ALL processes for a Unix user
![]()
How to immediately kill ALL processes for a Unix user
Jan 24, 2018 12:00:00 AM
5
min read
Backup and data streaming with xbstream, tar, socat, and netcat
![]()
Backup and data streaming with xbstream, tar, socat, and netcat
Jan 15, 2018 12:00:00 AM
5
min read
Exporting custom metrics to influxdb
![]()
Exporting custom metrics to influxdb
Jan 5, 2018 12:00:00 AM
1
min read
MySQL crashes on DDL statement: a lesson on purge threads
![]()
MySQL crashes on DDL statement: a lesson on purge threads
Dec 5, 2017 12:00:00 AM
3
min read
Understanding MySQL Isolation levels: repeatable-read
![]()
Understanding MySQL Isolation levels: repeatable-read
May 5, 2017 12:00:00 AM
6
min read
Change of database passwords through OEM
![]()
Change of database passwords through OEM
May 4, 2017 12:00:00 AM
3
min read
Backup Oracle databases to AWS S3
![]()
Backup Oracle databases to AWS S3
Feb 21, 2017 12:00:00 AM
5
min read
MySQL on AWS: RDS vs EC2
![]()
MySQL on AWS: RDS vs EC2
Dec 21, 2016 12:00:00 AM
3
min read
Add space to tablespace - corrective action in OEM 13c
![]()
Add space to tablespace - corrective action in OEM 13c
Oct 18, 2016 12:00:00 AM
1
min read
Auditing MySQL Users With McAfee Plugin
![]()
Auditing MySQL Users With McAfee Plugin
Sep 20, 2016 12:00:00 AM
4
min read
Exposing Innodb Internals via system variables: part 4, concurrency
![]()
Exposing Innodb Internals via system variables: part 4, concurrency
Sep 2, 2016 12:00:00 AM
7
min read
Custom MySQL statistics with collectd
![]()
Custom MySQL statistics with collectd
Aug 29, 2016 12:00:00 AM
2
min read
Exposing Innodb internals via system variables: part 3, I/O (table data)
![]()
Exposing Innodb internals via system variables: part 3, I/O (table data)
Aug 25, 2016 12:00:00 AM
17
min read
Exposing Innodb internals via system variables: Part 2, I/O (structure and logs)
![]()
Exposing Innodb internals via system variables: Part 2, I/O (structure and logs)
Aug 23, 2016 12:00:00 AM
14
min read
Exposing Innodb Internals via System Variables: Part 1, MemoryExposing Innodb Internals via System Variables: Part 1, Memory
![]()
Exposing Innodb Internals via System Variables: Part 1, MemoryExposing Innodb Internals via System Variables: Part 1, Memory
Aug 18, 2016 12:00:00 AM
9
min read
DECIMAL columns and a non-expected replication error
![]()
DECIMAL columns and a non-expected replication error
Jul 7, 2016 12:00:00 AM
4
min read
Encrypting sensitive data in puppet using hiera-eyaml
![]()
Encrypting sensitive data in puppet using hiera-eyaml
May 27, 2016 12:00:00 AM
3
min read
MySQL InnoDB’s full text search overview
![]()
MySQL InnoDB’s full text search overview
May 6, 2016 12:00:00 AM
6
min read
InnoDB flushing and Linux I/O
![]()
InnoDB flushing and Linux I/O
May 5, 2016 12:00:00 AM
2
min read
How to deal with MetaData Lock
![]()
How to deal with MetaData Lock
May 5, 2016 12:00:00 AM
5
min read
MySQL Query best practices
MySQL Query best practices
Apr 25, 2016 12:00:00 AM
5
min read
Internals of querying the concurrent requests' queue - revisited for R12.2
Internals of querying the concurrent requests' queue - revisited for R12.2
Apr 19, 2016 12:00:00 AM
7
min read
More fun with oracle timestamp math
![]()
More fun with oracle timestamp math
Apr 4, 2016 12:00:00 AM
16
min read
.svg){kind=small}
.svg){kind=small}
