Posts Tagged Under: MySQL

MySQL

MyISAM vs InnoDB

MyISAM versus InnoDB

Transactions, referential integrity, concurrency, and Storage limits are the main difference between MyISAM & InnoDB.

Read More

linux

Install and Configure Cacti Network Graphing Tool

Install and Configure Cacti on Linux

Cacti is a network graphing tool similar to MRTG. How do I install and configure common options to collect SNMP data and various other data (such as system load, network link status, hard disk space, logged in users etc) into an RRD?

Read More

MySQL

Splitting large MySQL dump files

One of the depressed things with operating with MySQL is of importing giant sql dump files.
Either you get a “max execution time exceeded” error from PHP or a”Max_allowed_packet_size” from MySQL.

The goal is separate the large “INSERT” statements into smaller size files.
Every statement has to be in single

Read More

lamp-logos

How To Install LAMP (Linux, Apache, MySQL, PHP)

About LAMP

LAMP stack is a group of open source software used to get web servers up and running. The acronym stands for Linux, Apache, MySQL, and PHP. Since the server is already running Fedora, the linux part is taken care of. Here is how to install the rest.

Setup

Before you

Read More