Five things every DBA must know
1> The Slow Query Log – Learn how to activate the Slow Query Log on MySQL. The Slow Query Log is responsible for keeping track of long running queries with the time it took to run them. 503 more words
After graduating, a significant number of my Master’s students think about pursuing a doctoral degree. First off, they definitely should not think about pursuing a doctoral degree if they really didn’t enjoy their Master’s degree – that’s a given. 474 more words
Quick one today:
How to get a list of objects (or indexes) that are compressed or have COMPRESSION enabled?
I frequently use the below script to get a complete list. 187 more words
Shortcut keys help you increase the efficiency and speed of your work.
DB Optimizer is a database optimization tool that maximizes database and application performance, reliability, and availability by profiling, tuning, and load testing SQL code. 185 more words