Tag: index

How to Install and Configure ClickHouse on Ubuntu 20.04

Posted on January 15, 2021 by Margaret Fitzgerald | Updated: August 24, 2023

Category: Tutorials | Tags: Alter, Analytics, Big Data, ClickHouse, ClickHouse-Client, ClickHouse-Server, Columns, Create, Data Management, Data Structure, Database, Database Structure, DBMS, drop, Firewall, index, indexing, Insert, MariaDB, MergeTree, MySQL, OLAP, optimization, Performance, PHPMyAdmin, Ports, Queries, Query, RDMS, Select, Show Databases, SQL, Structure, Table, Ubuntu, Ubuntu 20.04

Reading Time: 13 minutes

What is ClickHouse?

ClickHouse is an open-source column-oriented DBMS (or database management system) primarily used for OLAP (or the Online Analytical Processing of queries). It is capable of blazing fast generation of real-time analytical data and reporting utilizing SQL queries. It is fault tolerant, scalable, highly reliable and contains a feature rich tool set.

Continue reading →

MySQL Performance: How To Leverage MySQL Database Indexing

Posted on October 23, 2020 by Justin Palmer | Updated: March 5, 2021

Category: Series | Tags: Create, Data Management, Database, how to, index, indexing, MariaDB, MySQL, optimization, Performance, Queries, Query, Show Databases

Reading Time: 6 minutes

Throughout this tutorial, we will cover some of the fundamentals of indexing. As part of the MySQL series, we will introduce capabilities of MySQL indexing and the role it plays in optimizing database performance. Liquid Web recommends consulting with a DBA before making any changes to your production level application.

Continue reading →