Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

The Best of the Week (Oct. 17): SQL Zone

DZone's Guide to

The Best of the Week (Oct. 17): SQL Zone

· Java Zone
Free Resource

Learn how to troubleshoot and diagnose some of the most common performance issues in Java today. Brought to you in partnership with AppDynamics.

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (October 17 - October 24). Here they are, in order of popularity:

1. MySQL Compression: Compressed and Uncompressed Data Size

  • MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it comes to tables that employ compression.

2. Sqoop Oracle Example : Getting Started with Oracle -> HDFS Import/Extract

  • In this post, we'll get Sqoop (1.99.3) connected to an Oracle database, extracting records to HDFS.

3. Stop Claiming That You’re Using a Schemaless Database

  • One of MongoDB’s arguments when evangelising MongoDB is the fact that MongoDB is a “schemaless” database... But it doesn’t mean that there is no schema.

4. How to Avoid Hash Collisions When Using MySQL’s CRC32 Function

  • Percona Toolkit’s pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync synchronizes data efficiently between MySQL tables.

5. Understanding of Execution Plan - III - A [ The OPERATORS ]

  • In this article we are mostly focusing on the Logical and Physical Operators and trying to understand each as it is very important to understand them before understanding the Execution Plan.


Understand the needs and benefits around implementing the right monitoring solution for a growing containerized market. Brought to you in partnership with AppDynamics.

Topics:

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}