IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

MariaDB ColumnStore installation and testing – part 2

Posted on January 24, 2021, updated on December 16, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • MariaDB Community Server installation and configuration
  • MariaDB ColumnStore installation and configuration
  • References

Continue reading

MySQL Administration, Tuning Leave a comment

MariaDB ColumnStore installation and testing – part 1

Posted on December 23, 2020, updated on December 16, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • MariaDB ColumnStore container installation and configuration with Podman
  • MariaDB ColumnStore default schema configuration
  • Power BI Desktop configuration
  • Is MariaDB ColumnStore worth the effort ?
  • References

Continue reading

MySQL Administration, Tuning Leave a comment

Hiveserver2 monitoring with Jconsole and Grafana in HDP 3.x

Posted on November 22, 2020, updated on November 16, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • Hiveserver2 monitoring with Jconsole
  • Hiveserver2 monitoring with Grafana
  • References

Continue reading

Hadoop Tuning Leave a comment

Spark dynamic allocation how to configure and use it

Posted on October 22, 2020, updated on October 13, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • Spark dynamic allocation setup
  • Spark dynamic allocation testing
  • References

Continue reading

Hadoop Tuning Leave a comment

INSERT OVERWRITE does not delete old directories

Posted on September 22, 2020, updated on September 15, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • INSERT OVERWRITE test case
  • INSERT OVERWRITE does not delete old directories
  • References

Continue reading

Hadoop Bug Leave a comment

Spark lineage issue and how to handle it with Hive Warehouse Connector

Posted on August 23, 2020, updated on July 30, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • Test case and problem
  • Spark lineage solution
  • Spark lineage second problem and partial solution
  • References

Continue reading

Hadoop Spark Leave a comment
  • Page 1 of 33
  • « First
  • ‹ Previous
  • 1(current)
  • 2
  • 3
  • 4
  • 5
  • Next ›
  • Last »

Search

Certifications

Oracle Certified Master (OCM) Oracle Certified Professional (OCP) Oracle Certified Associate (OCA)

Tags Cloud

11gR2 (9) 12cR1 (6) Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (31) Automatic Data Optimization (ADO) (1) Automatic Diagnostic Repository (ADR) (1) Automatic Memory Management (AMM) (2) Automatic Segment Space Management (ASSM) (1) Automatic Shared Memory Management (ASMM) (4) Automatic Storage Management (ASM) (2) Automatic Workload Repository (AWR) (3) Backup (6) Benchmark (7) Bug (1) Cloud Control (2) cluster (1) Compression (3) Connection Manager (1) Database Links (1) Database Resource Manager (DBRM) (3) Database Vault (2) Data Guard (7) Data Recovery Advisor (2) Data Redaction (1) Development (1) Directory Naming (3) Docker (4) Fast Recovery Area (FRA) (1) Fine-Grained Access Control (FGAC) (1) Flashback (1) GATHER_STATS_JOB (1) GoldenGate (3) Grid Control (4) Grub (1) Health Monitor (1) Heat Map (1) High Availability (22) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (1) Multi-Master Replication Manager (MMM) (1) Non-Uniform Memory Access (NUMA) (3) OpenStack (2) OpenView Performance Agent (OVPA) (1) Oracle Configuration Manager (OCM) (1) Oracle Label Security (OLS) (1) oradebug (1) Patch (2) PL/SQL (1) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (4) Real Application Testing (RAT) (1) Recovery (2) Redo Log (2) RMAN (5) Security (17) Segment Advisor (2) Single Client Access Name (SCAN) (1) Spark (1) SQL (26) SQL*Net (3) SQL*Plus (1) SQL Access Advisor (SAA) (2) SQL Monitoring (1) SQL Performance Analyzer (SPA) (1) SQL Plan Management (SPM) (1) SQL Profile (1) SQL Trace (1) SQL Tuning Advisor (STA) (5) SQL Tuning Set (STS) (1) Streams (3) System Global Area (SGA) (1) Tivoli Data Protection for Oracle (TDPO) (2) Tivoli Storage Manager (TSM) (1) Transparent Application Failover (TAF) (1) Transparent Data Encryption (TDE) (1) Tuning (44) Virtualization (2) Virtual Memory (2) Virtual Private Database (VPD) (2) VxDMP (1) VxFS (1) VxVM (1)

Categories

  • AIX (2)
  • Couchbase (2)
  • Hadoop (20)
  • HPUX (6)
  • Linux (24)
  • mongoDB (1)
  • MySQL (32)
  • Oracle (127)
  • Python (2)
  • SQL Server (3)

Recent Comments

  • Yannick Jaquier on How to identify table fragmentation and remove it ?
  • Tony on How to identify table fragmentation and remove it ?
  • Yannick Jaquier on How to identify table fragmentation and remove it ?
  • Mike on How to identify table fragmentation and remove it ?
  • EL FEHYLY on ORA-00020: maximum number of processes (string) exceeded

Blogroll

  • Ask Tom
  • Data Virtualizer
  • Exile on Keyboard St. (French)
  • Kevin Closson’s Oracle Blog
  • MySQL Performance Blog
  • Official Pythian Blog
  • Oracle Optimizer
  • Oracle Scratchpad
  • Richard Foote’s Oracle Blog
  • Tanel Poder's blog
  • The Oracle Instructor

Visitors

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
IT World Proudly powered by WordPress