Tag: MySQL

Ansible Dependencies for Docker Containers

I recently had the opportunity to test out Ansible’s ability to interact with docker containers. Some might ask why we would want Ansible to connect to running containers. Afterall, we can build the containers to our liking using ansible-container, or…

Read More >

Exposing Innodb Internals via System Variables: Part 5, Consistency / Statistics handling

In part 5 of this series, Peter Sylvester, Lead Database Consultant at Pythian, looks at variables that relate to enforcing data consistency, and how index statistics are handled and stored.

Read More >

Exposing Innodb Internals via System Variables: Part 4, Concurrency

In part 4 of this series, Peter Sylvester, Lead Database Consultant at Pythian, looks at the mechanics that impact CPU resourcing and how InnoDB handles concurrent threads.

Read More >

Exposing Innodb Internals via System Variables: Part 3, I/O (Table data)

In part 3 of this series, Peter Sylvester, Lead Database Consultant at Pythian, continues looking at I/O, specifically the mechanics on how data gets written to table files.

Read More >

Exposing Innodb Internals via System Variables: Part 2, I/O (structure and logs)

In part 2 of this series, Peter Sylvester, Lead Database Consultant at Pythian, takes a closer look at I/O structure and log related variables.

Read More >

Exposing Innodb Internals via System Variables: Part 1, Memory

Introduction A couple of months ago I decided to give myself a refresher on the mechanics of InnoDB. Having a high level understanding of what’s going on under the hood can help provide the context needed in order to resolve…

Read More >

vm.swappiness and OOM in RHEL6

The behavior of vm.swappiness was always a bit confusing for novice linux users, as setting vm.swappiness to 0 would not completely disable swapping in the system during a memory crunch. vm.swappiness would only affect the agressiveness of swapping. Following upstream…

Read More >

How to Verify If a Slave Running in MySQL 5.7

Derek Downey, OSDB Practice Advocate at Pythian, explains how to verify that a Slave is running in MySQL 5.7.

Read More >

Creating An External Slave For A Live AWS Aurora Instance

Kevin Markwardt, MySQL Database Consultant at Pythian, explains how to set up an external slave for a live Amazon AWS Aurora instance.

Read More >

Log Buffer #482: A Carnival of the Vanities for DBAs

Fahd Mirza, Oracle Database Administrator at Pythian, highlights top blogs posts in the worlds of Oracle, SQL Server and MySQL.

Read More >
Page 1 of 6512345...10...Last Page »