Tag: Select
How to Install and Configure ClickHouse on Ubuntu 20.04
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.
Previous Series:
MySQL via Command Line 101: Basic Database Interaction
Grant Permissions to a MySQL User on Linux via Command Line
MySQL via Command Line 101: Basic Database Interaction
Preflight Check
- These instructions are intended for granting a MySQL user permissions on Linux via the command line
- I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I'll be logged in as root.
Login to MySQL
First we'll log in to the MySQL server from the command line with the following command:
Select a MySQL Database on Linux via Command Line
Pre-Flight Check
- These instructions are intended for selecting a MySQL database on Linux via the command line.
- I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I'll be logged in as root.
First we'll login to the MySQL server from the command line with the following command:
MySQL Performance: MySQL/MariaDB Indexes
Data in a MySQL/MariaDB database is stored in tables. A simple way of thinking about indexes is to imagine an extensive spreadsheet. This type of system is not always conducive to quick searching; that’s where an index becomes essential. If there is no index, then the database engine has to start at row one and browse through all the rows looking for the corresponding values. If this is a small table, then it is no big deal, but in larger tables and applications where there can be tables with millions and even billions of rows, it becomes problematic. As you can imagine, searching through those rows one by one will be time-consuming, even on the latest hardware. The solution is to create an INDEX (or more than one) for your data.
Pre-Flight Check
- These instructions are intended for viewing the selected MySQL database via the command line.
- I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
Remove a MySQL User on Linux via Command Line
MySQL via Command Line 101: Basic Database Interaction
- These instructions are intended for removing a MySQL user on Linux via the command line
- I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I'll be logged in as root.
First we'll log in to the MySQL server from the command line with the following command:
Remove Permissions for a MySQL User on Linux via Command Line
MySQL via Command Line 101: Basic Database Interaction
- These instructions are intended for revoking a MySQL user permissions on Linux via the command line
- I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I'll be logged in as root.
First we'll log in to the MySQL server from the command line with the following command:
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.