ALL POSTS

Part 1: How to Effectively Use a Performance Schema

Performance Schema (PS) has been the subject of many, many recent discussions, presentations, and articles.  After its release in MySQL 5.7, PS has become the main actor for people who want to take the further steps in MySQL monitoring. At the same time, it has become clear that Oracle intends to make PS powerful with…

Are you Ready for the Leap Second?

LeapSecond

If you’re not aware of what the leap second is look into it. The fact is, this year the last minute of June 30th will be one second longer and “June 30, 2015 23:59:60″ will be a valid and correct time. There are a few issues that could be caused by the leap second, so I’ve…

MySQL Query Profiling with Performance Schema

One of my favorite tools for query optimization is profiling. But recently I noticed this warning: After looking through certain documentation , I should indeed start using the Performance Schema to get this information. Okay, so let’s give that a try. I confirmed that I started MySQL 5.6.23 with the default of Performance Schema = ON:…

Making Existing SQLPLUS Scripts 12c and Container DB (PDB) Compatible

Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding the DBA_ views that most DBA sqlplus scripts are based upon. However, existing DBA sqlplus scripts can easily be modified using just a few simple sqlplus techniques to be compatible with 11g, as well as all types of 12c…

fsfreeze in Linux

The fsfreeze command, is used to suspend and resume access to a file system. This allows consistent snapshots to be taken of the filesystem. fsfreeze supports Ext3/4, ReiserFS, JFS and XFS. A filesystem can be frozen using following command: # /sbin/fsfreeze -f /data Now if you are writing to this filesystem, the process/command will be…

Ingest a Single Table from Microsoft SQL Server Data into Hadoop

Introduction This blog describes the best-practice approach in regards to the data ingestion from SQL Server into Hadoop. The case scenario is described as under: Single table ingestion (no joins) No partitioning Complete data ingestion (trash old and replace new) Data stored in Parquet format Pre-requisites This example has been tested using the following versions: Hadoop…

Page 2 of 28212345...10...Last Page »