What is mod_deflate?

How mod_deflate works

When a visitor accesses a website, a request is made to the web server for a specific kind of data. An example might be a home page of a site. Next, the web server locates that data and delivers it to the client who is requesting that data – basically back to the web browser.

In this example, the speed at which the home page loads can depend on a variety of factors. One of them could be how long it takes to find and deliver the data for that page. This is just one example.

Some of that data – such as javascript files, css files, and php files – can actually be compressed into smaller sizes before they are delivered back to the visiting client or browser at the smaller size. The visitor can now have a more optimized browsing experience.

This is where mod_deflate comes in.

Continue reading “What is mod_deflate?”

Renaming Database Tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin. Let’s learn how to rename database tables.

  1. Click the database table you wish to rename.phpma-rename-frame3_1
  2. Then click the Operations tab.phpma-rename-frame4_1
  3. Enter a new name for the table here.phpma-rename-frame6_1
  4. Then click Go.
  5. That’s it! The information table has been renamed infotable, and is listed here.phpma-rename-frame7_1

 

Searching Through a Database with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin.  Now let’s learn how to use the Search feature.

  1. Click the database you wish to search here.phpma-search-frame03_1
  2. Then click the Search tab and enter words or values to search for in the database.
    phpma-search-frame04_1
  3. There are several options you can use to refine your search. This database only has one table (details), but if there were more, you could limit your search to specific tables here.phpma-search-frame05_1
  4. When ready, click Go to perform the search. This search found one match. Click Browse.phpma-search-frame06_1
  5. We can now make changes to the record that was found.phpma-search-frame10_1
  6. Click Go when finished.

 

Running SQL Queries on a Database with phpMyAdmin

 

  1. This tutorial assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to run SQL queries on a database.phpma-query-frame02_1
  2. Click the database table you wish to run a SQL query on.phpma-query-frame03_1
  3. Click the SQL button here.phpma-query-frame05_1
  4. Then type your SQL command. Click Go when finished.phpma-query-frame06_1
  5. In this case, we’re going to delete the address field from the details table using the command:ALTER TABLE details DROP COLUMN address;
  6. That’s it! The SQL command is executed when you click Go. Let’s go take a look.
  7. The address field is no longer in our details table.phpma-query-frame09_1
  8. You can also click the SQL button directly from the table view. Doing so presents a SQL query window that is partially filled in.phpma-query-frame10_1

 

How To Repair a MySQL Database in cPanel

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Let’s learn how to repair a database.

  1. Click the “MySQL Databases” icon.cpanel-pl-mysql-10-repair-02
  2. Under “Modify Databases”, and in the “Repair Database” drop down box, select the database you want to repair.cpanel-pl-mysql-10-repair-03
  3. Then click “Repair Database”.cpanel-pl-mysql-10-repair-04
  4. That’s it! The database has been repaired.cpanel-pl-mysql-10-repair-05

 

MySQL 5.1 vs. 5.5 vs. 5.6 Performance Comparison

General Results
  • MySQL 5.5 and 5.6 both performed significantly better than MySQL 5.1.
  • Read/Write and Read Only workloads testing requests per second show a marked improvement for both MySQL 5.5 and 5.6 over MySQL 5.1.
  • The 95th percentile response times (explained below) for both Read/Write and Read Only workloads on MySQL 5.5 and 5.6 were much lower (thus faster) than MySQL 5.1.
Requests per Second

MySQL 5.1 vs. 5.5 vs. 5.6 Performance Comparison - Requests per Second - Read and Write Operations

Continue reading “MySQL 5.1 vs. 5.5 vs. 5.6 Performance Comparison”