How to Install and Configure ClickHouse on Ubuntu 20.04

Reading Time: 12 minutes

What is ClickHouse?

clickhouse.logo

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.

In a regular database, data is stored in tables, columns, and rows. In a table, the related values are physically stored side by side in one row, which is critical to how it operates. This is how most string type databases work.

Continue reading “How to Install and Configure ClickHouse on Ubuntu 20.04”

MySQL Performance: How To Leverage MySQL Database Indexing

Reading Time: 4 minutes
A Mysql Indexing Logo

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 “MySQL Performance: How To Leverage MySQL Database Indexing”

How to Enable Piped Logging in Apache

Reading Time: 3 minutes

Apache by default logs data directly to log files. While this isn’t a bad thing, it is not your only option. Both Apache 1.x and Apache 2.x bring with them the option of enabling something called “Piped Logging”, though cPanel will only allow you to enable it for version 2.x.

Continue reading “How to Enable Piped Logging in Apache”

Finding Resource Usage Details in MSSQL

Reading Time: 7 minutes

When running MSSQL or Microsoft SQL Server, we need to determine whether it is optimized or will it need more resources to achieve better performance. This article reviews what behaviors to look for,  where to find them, and how to view signs of distress.

Continue reading “Finding Resource Usage Details in MSSQL”

How To Use the Image Optimizer Package for WP-CLI

Reading Time: 2 minutesThere will be many times when you will need to optimize all images in a site media library. If you are familiar with using WP-CLI, then there is a very handy package which can be installed. The package is called “image-optimize” and it will simplify the process of getting your images ready for web hosting. This package is not for “managed hosts” since the libraries needed will not be able to be installed having without root access and it can be CPU resource intensive.

Preparing to Run Commands

The package for WP-CLI is called image-optimize. To be able to use this package, you will need to login to your site’s server and update WP-CLI. You can update WP-CLI by running the following command: wp cli update Next, you will need to install a number of libraries that the package uses to optimizes jpeg, png and gif images with these commands: sudo apt-get install jpegoptim sudo apt-get install optipng sudo apt-get install pngquant sudo apt-get install gifsicle Now you can install the stable version of the image-optimize package with this command: wp package install typisttech/image-optimize-command:@stable

Optimizing Site Images

The following are examples of the commands to run after a WordPress core update: wp image-optimize mu-plugins wp image-optimize plugins wp image-optimize themes wp image-optimize wp-admin wp image-optimize wp-includes You can use this command to regenerate all thumbnails on a site. wp media regenerate --yes You may need to limit how many images that image-optimize will process in a single back. To limit the batch size,  you just need to add the –limit flag to the end of the batch command and specify the amount, as shown in these examples: wp image-optimize batch --limit=500 wp image-optimize batch --limit=1000 wp image-optimize batch --limit=2500 wp image-optimize batch --limit=5000 When using the image-optimize WP-CLI command, server CPU usage may be intensive, so run the batch commands in smaller sizes during the off hours times on your site. You can track CPU usage whilst running a batch optimize command by using htop. You can install and run htop using the following commands: sudo apt-get install htop htop To use htop to monitor server load, keep a terminal window open while the batch optimize command is running in another terminal window. In our testing, the CPU usage was not too high. 1.61GB/3.74GB Memory usage 180M - 3.86GB Swap

Restoring Optimized Images

Before images are optimized backup versions are created, which means that you can restore at any time to a backup file and replace out the optimized version. For example, Attachment 123 was optimized using this command: wp image-optimize attachment 123 To restore the attachment for 123 the command to run would be: wp image-optimize restore 123 You can use the wp media regenerate command to regenerate a specific media file. wp media regenerate 123   Being able to  optimize the images in your WordPress sites media library will reduce the amount of storage needed for your site. Optimization will also improve the speed and performance of your site for visitors, improving user experience and satisfaction.

The Best Settings for Configuring FastCGI

Reading Time: 5 minutesIn our last tutorial, we showed you how to install Apache’s mod_fcgid and provided Linux scripts to assist in transitioning from mod_php. In this next section, we’ll be discussing how to configure a baseline setting for PHP optimization. Continue reading “The Best Settings for Configuring FastCGI”

Load Balancing Techniques and Optimizations

Reading Time: 8 minutes

The hosting world’s bread & butter solution for providing high availability and redundancy is load balancing. There are many different use cases for a Load Balancer (LB). It is important to know how to effectively manage your LB configuration so that it performs optimally in your environment.  The proceeding article will review some of the common practices that, when adhered to, provide a smooth and seamless high availability website/application through the use of load balancing.

Continue reading “Load Balancing Techniques and Optimizations”

MySQL Performance: InnoDB Buffers & Directives

Reading Time: 6 minutesAs discussed earlier in our MySQL Performance series, the InnoDB storage engine is designed to be a high-performance database for very large datasets. The row-locking technique it uses allows for many read and write requests to occur on a single table concurrently. This is a vast improvement in speed over traditional Continue reading “MySQL Performance: InnoDB Buffers & Directives”

MySQL Performance: System Config & Routine Maintenance

Reading Time: 3 minutes

The majority of work needed when adjusting the MySQL server is editing the applicable directives within a MySQL configuration file. There are multiple, optional configuration files that MySQL looks for when starting up. They are read in the following order:

Continue reading “MySQL Performance: System Config & Routine Maintenance”

Apache Performance Tuning: Configuring MPM Directives

Reading Time: 3 minutes  Our previous article in this series focused on defining and fitting MPM to match your environment.  Building from our last tutorial we will be discussing specific details on how to adjust the previously mentioned Apache configuration directives on the various types of Liquid Web VPS servers as well as Core managed servers.   Continue reading “Apache Performance Tuning: Configuring MPM Directives”