Tag: MySQL

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

This Log Buffer Edition searches through various blogs of Oracle, SQL Server and MySQL and picks a few contemporary ones.

Read More >

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

This edition of Log Buffer covers Oracle, Microsoft SQL Server, and MySQL.

Read More >

MySQL may return results in non-deterministic order with ‘order by’

Whenever we want a query’s results sorted, you may think of using the clause “order by.” You are correct: most of the time, MySQL will return the results in expected order with “order by.” Be careful, though. Sometimes MySQL may return…

Read More >

Customizing pt-stalk to Capture the Diagnostics Data You Really Need

Valeriy Kravchuk’s great recent post on using oprofile to profile MySQL mentioned how pt-stalk, the script from Percona Toolkit to capture diagnostics data based on a detected condition, currently does not support the new operf comand, and relies instead on the deprecated and soon…

Read More >

Duplicate Indexes in MySQL

Valerie Parham-Thompson explains why duplicate (redundant) indexes are sometimes helpful.

Read More >

MySQL on AWS: RDS vs EC2

If you are thinking in moving your MySQL databases to AWS, this analysis by Gabriel Ciciliani may help you determine if RDS is the appropriate solution for your data.

Read More >

New MySQL File System Vulnerabilities

Get insight into the recent MySQL file system vulnerabilities.

Read More >

Using ProxySQL to validate MySQL Updates

Derek Downey provides a quick look at ProxySQL.

Read More >

Enabling InnoDB Compression

Learn how to recover some disk space by enabling InnoDB compression.

Read More >

Using gh-ost for online schema changes

The pt-online-schema-change tool has been a workhorse for years, allowing MySQL DBAs to alter tables with minimal impact to application workload, and before MySQL had native online alter capabilities. Although consistently grateful for the tool’s existence, I never liked the…

Read More >
Page 2 of 6712345...10...Last Page »