Log buffer #550: a carnival of the vanities for DBAs
Tags:
Technical Track,
Log Buffer
This log buffer edition covers Cloud, Oracle, SQL Server and MySQL topics.
Cloud What does it take to write an app for the Google Home
assistant? Can we make it smarter by leveraging Google Cloud? Whether it's delivering new experiences through mobile apps, building a platform to power a partner ecosystem, or modernizing IT systems, virtually every modern business uses
APIs (application programming interfaces). When was the
last time you verified a database backup? If that question causes you to break into a cold sweat, rest assured you’re not alone. It’s incredible how much and how rapidly technology evolves. Microsoft’s server technology is no exception. We entered the 2008 release cycle with a shift from
32-bit to 64-bit computing, the early days of server virtualization and advanced analytics. Enterprises are rapidly
embracing public cloud to take advantage of the scale, agility and economic benefits. However, deploying filed-based applications to the cloud has been challenging.
Oracle One of the
difficulties of being a DBA and being required to solve performance problems is that you probably never have enough time to think about how you got to a solution and why the solution works; and if you don’t learn about the process itself, you just don’t get better at it. The
Appendix A of the Using Oracle Autonomous Data Warehouse Cloud guide describes the DBMS_CLOUD package. Unfortunately, it documents only a subset of the subroutines. And, for some of them, the description could also be enhanced. This is an interesting bug which has affected a number of our databases – perhaps because we are not patched to the latest levels in every case. The
MoS note is this one – Patch 20373598: GEN0 TIMEOUT ACTION ALWAYS TRY TO INITIALIZE OCR CONTENT p20373598_121022_Linux-x86-64 What is
best metric in performance monitoring – averages or percentiles? Statistically speaking, there are many methods to determine just how good of an overall experience your application is providing. Averages are used widely. They are easy to understand and calculate; however, they can be misleading.
Bash, while great for simple things, can be tricky to use for more advanced programming techniques that are easily exposed in things like Java, or Go. Multithreading is one such problem.
MySQL Oracle has done great technical work with MySQL. Specifically, a nice job has been done around security. There is one useful feature that exists in Oracle
MySQL and that currently does not exist in MariaDB.
Why MySQL stored procedures, functions and triggers are bad for performance In the old days, when we wanted to
strengthen our skills, the only option was to buy a good book. Nowadays, one can find a lot of resources on the Internet; however, quality is often poor. An LSM like
RocksDB has much better write and space efficiency than a B-Tree. That means with RocksDB you will use less SSD than with a B-Tree and the SSD will either last longer or you can use lower endurance SSD. AMD
EPYC Performance Testing… or don’t get on the wrong side of SystemD
