Pythian Blog: Technical Track

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

by Fahd Mirza on Jul 16, 2018 12:00:00 AM

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
Topics: Technical Track Log Buffer

No Comments Yet

Let us know what you think

See all

See all

Subscribe by email
Follow us
Love Your Data
Pythian Logo

© 2024 All rights reserved.