Server Optimization

How To Use MySQL Query Profiling — step-by-step Databases tutorial on Progressive Robot

How To Use MySQL Query Profiling

MySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When developing a mid to large size application, there tends to be hundreds of queries distributed throughout a large code base. This article will demonstrate some useful query profiling techniques using tools that are built into MySQL server.

Read more
How To Install and Secure Memcached on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Install and Secure Memcached on CentOS 7

Memory object caching systems like Memcached can optimize backend database performance by temporarily storing information in memory, retaining frequently or recently requested records. In this guide, we will cover how to protect your Memcached server by binding your installation to a local or private network interface and creating an authorized user for your Memcached instance.

Read more
How To Configure Apache Content Caching on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Configure Apache Content Caching on CentOS 7

Caching is a method of improving server performance by allowing commonly requested content to be temporarily stored in a way that allows for faster access. This speeds up processing and delivery by cutting out some resource intensive operations. By creating effective…

Read more
How To Add ngx_pagespeed to Nginx on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Add ngx_pagespeed to Nginx on CentOS 7

ngx_pagespeed, or just pagespeed, is an Nginx module designed to optimize your site automatically by reducing the size of its resources and hence the time the clients’ browsers need to load it. This article will guide you through the installation and configuration of the pagespeed module for Nginx. It’s important to know that Nginx does not support *Dynamic Loading of Modules* available in other web servers such as Apache. Since Nginx doesn’t support this feature, you need to build Nginx from so

Read more
How To Add NoSQL Queries to MySQL with memcached on Ubuntu 14.04 — step-by-step Linux tutorial on Progressive Robot

How To Add NoSQL Queries to MySQL with memcached on Ubuntu 14.04

Memcached as a standalone server works as an intermediary in front of the MySQL client access layer and manages information only in the memory without an option to store it persistently. This makes it suitable for tasks such as caching the results of duplicate MySQL queries. In this article, memcached will be installed as a MySQL plugin and tightly integrated into MySQL. It will provide a NoSQL style access layer for managing information directly in regular MySQL InnoDB tables.

Read more
CHAT