Enable GZip Compression

Submitted by Richard on Thu, 06/01/2017 - 00:15

Before GZip Compression

1) Begin by verifying that you have the following line in your httpd.conf file:

LoadModule deflate_module modules/mod_deflate.so

2) Create a file in /etc/httpd/conf.d/ and name this file deflate.conf . Edit the following script into this file:

#Set to gzip all output
SetOutputFilter DEFLATE

MySQL Tuning

Submitted by Richard on Wed, 05/31/2017 - 15:20

The purpose of this post is to help guide users through tuning MySQLD for MySQL performance gains. 

Please keep in mind that these changes will increase the memory used by MySQL. The benefits will dramatically outweigh the cons, as these changes will greatly improve your queries and database usage. The average user will benefit most with MySQL changes similar to what this post will cover.