Pythian Blog: Technical Track

Log buffer #555: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle and MySQL. Cloud Cloud Directory is a neglected serverless data store that deserves much more attention. Many of our large enterprise customers have this worry hanging over their heads … what are they going to do about that mainframe when they migrate? Miners Extract More Value from the Cloud When They Transform Their Cultures 7 steps to keep your Windows Servers Patched with AWS Systems Manager No application is an island—each one has dependencies and exists alongside other services, sharing resources and data. Oracle An example gitignore file for Nodejs projects to ensure that local environment variables, build-related output and modules are not committed to the git repository. Jonathan Lewis writes about Column Group Catalog. Franck Pachot blogs about Oracle write-consistency bug and multi-thread de-queuing. Mohammed Azar discusses the issues which may arise when we try to rebuild the forms or reports. MySQL Change management is hard. In everyday production, there are numerous factors working against embracing change. Limited preparation time and a whole new show = a whole new crew, innumerable planning variables and the challenge of driving an operational plan based on creative instincts. Kathy Forte shows you how to connect to the same Docker instance using the MySQL Shell which is a tool to use Document Store and to create InnoDB Clusters. Percona XtraDB Cluster 5.7.23-31.31 Is now available. A query plan uses a loose index scan if “Using index for group-by” appears in the “Extra” column of the EXPLAIN output. In some plans though, “Using index for group-by (scanning)” appears. What does “(scanning)” mean and how is it different from the regular loose index scan? Chien Tran on debugging a slow WordPress site.

No Comments Yet

Let us know what you think

Subscribe by email