Magento Logo

How To Clean Up Your Magento Store’s Database Logs For Faster and Better Performance

There are two different options to clean up your logs: Clean your…

There are two different options to clean up your logs:

  1. Clean your logs via Magento Admin Panel “Log Cleaning”
  2. Clean up your database tables directly via phpmyadmin or SSH MySQL.

The following tables are used & managed by Magento’s log cleaning functions:
log_customer
log_visitor
log_visitor_info
log_url
log_url_info
log_quote
report_viewed_product_index
report_compared_product_index
report_event
catalog_compare_item

Cleaning Logs via Magento Admin Panel

TRON: LEGACY

TRON: Legacy Quote

Dialogue Kevin Flynn: The grid. A digital frontier. I tried to picture…

TRON: LEGACY
TRON: LEGACY

Dialogue

Kevin Flynn: The grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? Motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I’d never see. And then one day…
Sam Flynn: You got in.
Kevin Flynn: That’s right, man. I got in. And the world was more beautiful than I ever dreamed, but also more dangerous than I ever imagined. Now, I met a brave warrior-
Sam Flynn: Tron!
Kevin Flynn: [hums Tron theme] Tron!
Sam Flynn: Who fights for the Users.
Kevin Flynn: He sure does. Oh man, he showed me things that no one had ever imagined: disc battles fought in spectacular arenas and cycles that raced on ribbons of light. Radical. And together-
Sam Flynn: You built the grid.
Kevin Flynn: We built a new grid for programs and users. Now, I couldn’t be in there all the time, so I created a program in my own image that could think, like you and me. And I called him CLU.
Sam Flynn: Codified Likeness Utility.
Kevin Flynn: That’s right. And CLU, Tron, and I, we built the system where all information was free and open. Beautiful. And then, one day, something happened. Something extraordinary. A miracle.
Sam Flynn: What was it?
Kevin Flynn: That’ll have to wait til next time. I gotta get to work.
Sam Flynn: I want to come with you, Dad.
Kevin Flynn: Yeah, well, someday you will. I promise.
Sam Flynn: To the Grid?
Kevin FLynn: Goodnight, Sam. What do you say tomorrow we go to the arcade, and you can have a crack at the old man’s high score? First game’s on me. [flips Sam a quarter]
Sam Flynn: Can we play doubles? On the same team?
How to Set Up vsftpd on Ubuntu 12.04

How to Set Up vsftpd on Ubuntu 12.04

About vsftpd The first two letters of vsftpd stand for “very secure”…

How to Set Up vsftpd on Ubuntu 12.04
How to Set Up vsftpd on Ubuntu 12.04

About vsftpd

The first two letters of vsftpd stand for “very secure” and the program was built to have strongest protection against possible FTP vulnerabilities.

Step One – Install vsftpd

You can quickly install vsftpd on your server in the command line:

sudo apt-get install vsftpd
Once the file finishes downloading, the VSFTP will be on your server. Generally speaking, it is already configured with a reasonable amount of security. However, it does provide access on your Server to anonymous users.

Step Two – Configure vsftpd

Once vsftpd is installed, you can adjust the configuration.

Open up the configuration file:

sudo nano /etc/vsftpd.conf
The biggest change you need to make is to switch the Anonymous_enable from YES to NO:

anonymous_enable=NO

How to Create a SSL Certificate on Apache for Ubuntu 12.04

How to Create a SSL Certificate on Apache for Ubuntu 12.04

About SSL Certificates A SSL certificate is a way to encrypt a…

How to Create a SSL Certificate on Apache for Ubuntu 12.04
How to Create a SSL Certificate on Apache for Ubuntu 12.04

About SSL Certificates

A SSL certificate is a way to encrypt a site’s information and create a more secure connection. Additionally, the certificate can show the server’s identification information to site visitors. Certificate Authorities can issue SSL certificates that verify the server’s details while a self-signed certificate has no 3rd party corroboration.

What the Red Means

The lines that the user needs to enter or customize will be in red in this tutorial!

The rest should mostly be copy-and-pastable.

Set Up

The steps in this tutorial require the user to have root privileges on the server.

Additionally, you need to have apache already installed and running on your server.
If this is not the case, you can download it with this command:

sudo apt-get install apache2

Powerful Chemistry is a…

Powerful Chemistry is a…

Powerful Chemistry is a biological electricity that gives a couple a rush…

Powerful Chemistry is a biological electricity that gives a couple a rush of passion when they are together. Sometimes that chemistry is so powerful between two people, that it can be mutually felt when they are just in each other’s presence and are not even touching.