Tag: MySQL

Rejoining a Node to MySQL’s InnoDB Cluster

Derek Downey, OSDB Practice Advocate at Pythian, gives you the steps to setup and deploy a local sandbox Cluster as well as the steps to kill a node.

Read More >

Auditing MySQL Users With McAfee Plugin

Ivan Groenewold, MySQL Database Consultant at Pythian, discusses auditing MySQL users with the McAffee plugin.

Read More >

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 >
Page 2 of 6612345...10...Last Page »