Operations

The guides in this section include information about best practices, monitoring, logging, troubleshooting, and maintaining a SQream DB cluster.

In this section:

• Optimization and best practices
  • Table design
    • Use date and datetime types for columns
    • Reduce varchar length to a minimum
    • Don’t flatten or denormalize data
    • Convert foreign tables to native tables
    • Use information about the column data to your advantage
      • Set NULL or NOT NULL when relevant
      • Keep VARCHAR lengths to a minimum
  • Sorting
  • Query best practices
    • Reduce data sets before joining tables
    • Use the high selectivity hint
    • Cast smaller types to avoid overflow in aggregates
    • Prefer COUNT(*) and COUNT on non-nullable columns
    • Return only required columns
    • Use saved queries to reduce recurring compilation time
    • Pre-filter to reduce JOIN complexity
  • Data loading considerations
    • Allow and use natural sorting on data
• Logging
  • Locating the log files
    • Log structure and contents
    • Log naming
  • Logging control and maintenance
    • Change log verbosity
    • Change log rotation
  • Collect logs from your cluster
    • SQL Syntax
    • Command line utility
    • Parameters
    • Example
  • Troubleshooting with logs
    • Loading logs with foreign tables
    • Count message types
    • Find fatal errors
    • Count error events within a certain timeframe
    • Tracing errors to find offending statements
• Configuration
  • Configuration files
  • Frequently set parameters
  • Recommended configuration file
  • Changing settings temporarily
• Troubleshooting
  • Troubleshooting common issues
    • Troubleshoot cluster setup and configuration
    • Troubleshoot connectivity issues
    • Troubleshoot query performance
    • Troubleshoot query behavior
    • File an issue with SQream support
  • Examining logs
  • Start a temporary SQream DB for testing
• Gathering information for SQream support
  • Getting support and reporting bugs
  • How SQream debugs issues
    • Reproduce
    • Logs
    • Fix
  • Collecting a reproducible example of a problematic statement
    • SQL Syntax
    • Parameters
    • Example
  • Collecting logs and metadata database
    • Examples
• Creating or cloning a storage cluster
  • Creating a new storage cluster
  • Tell SQream DB to use this storage cluster
    • Permanently setting the storage cluster setting
    • Start a temporary SQream DB worker with a storage cluster
      • Using a configuration file (recommended)
      • Using the command line parameters
  • Copying an existing storage cluster
• SQream Acceleration Studio
  • Setting up and starting the studio
  • Logging in
  • Statement editor
    • Familiarizing yourself with the editor
    • Navigation and user information
    • Toolbar
    • Statement area
      • Formatting your SQL
      • Saving statements
      • Loading SQL to a tab
      • Executing SQL statements
    • Results
      • Sorting results
      • Viewing execution information
      • Saving results to a file or clipboard
    • Database tree
      • System Queries
      • Filtering (searching) for objects
      • Copying object names
      • Generating SELECT statements
      • Generating an INSERT statement
      • Generating a DELETE statement
      • Generating a CREATE TABLE AS statement
      • Renaming a table
      • Adding columns to table
      • Truncate a table
      • Dropping an object
      • Generating DDL statements
      • The DDL optimizer
    • Using the DDL optimizer
    • Analyzing the results
  • Administration Dashboard
    • Familiarizing yourself with the dashboard
    • Data storage pane
      • Database storage
    • Service and workers pane
      • Services
        • Creating new service queues
        • Associating a worker with an existing service
      • Workers
        • Show host resources
        • Active queries
        • Control worker status (start, stop, restart)
• Using the statement editor (deprecated)
  • Setting up and starting the statement editor
  • Logging in
  • Familiarizing yourself with the editor
    • Toolbar
    • Statement area
      • Keyboard shortcuts
    • Results
      • Sorting results
      • Viewing execution information
      • Saving results to a file or clipboard
    • Database tree
      • Database
      • Schema
      • Table
      • Create a table
      • Catalog views
      • Predefined queries
  • Notifications
  • DDL optimizer
    • Using the DDL optimizer
    • Analyzing the results
• Hardware Guide
  • A SQream DB cluster
    • Example for a single-node cluster
    • Example for multi-node clusters
  • Considerations in cluster design
    • Balancing cost and performance
    • CPU compute
    • GPU compute and RAM
    • RAM
    • Operating system
    • Storage
  • Example cluster supporting 32 concurrent active users
• Security
  • Overview
  • Security best practices for SQream DB
    • Secure OS access
    • Change the default SUPERUSER
    • Create distinct user roles
    • Limit SUPERUSER access
    • Password strength guidelines
    • Use TLS/SSL when possible
• Setting up SQream DB
  • Before you begin
    • What does the installation process look like?
  • Start a local SQream DB cluster with Docker
    • Preparing your machine for NVIDIA Docker
      • CentOS 7 / RHEL 7 / Amazon Linux
      • Ubuntu 18.04
    • Install Docker CE and NVIDIA docker
      • CentOS 7 / RHEL 7 / Amazon Linux (x64)
      • CentOS 7 / RHEL 7 (IBM POWER)
      • Ubuntu 18.04 (x64)
    • Preparing directories and mounts for SQream DB
    • Install the SQream DB Docker container
    • Starting your first local cluster
  • Recommended post-installation configuration
    • Recommended BIOS settings
    • Use a dedicated SQream DB administration account
    • Configure the OS locale and timezone
    • Configure NTP for clock synchronization
    • Install recommended utilities
    • Tuning OS parameters for performance and stability
    • Disable SELinux
    • Secure the server with a firewall
      • Opening up ports in the firewall
      • Disabling the built in firewall