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

Posted in: Log Buffer, Technical Track

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

email

Author

Interested in working with Fahd? Schedule a tech call.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *