Introduction to MySQL INNODB engine table
InnoDB is a general-purpose storage engine that balances high reliability
and high performance. In MySQL 5.6, InnoDB is the default MySQL storage
engine. Unless you have configured a different default storage engine,
issuing a CREATE TABLE statement without an ENGINE= clause creates an
InnoDB table. InnoDB includes all the features that were part of the InnoDB Plugin for
MySQL 5.1, plus new features specific to MySQL 5.5 and higher. Note: The mysql and INFORMATION_SCHEMA databases that implement some of the
MySQL internals still use MyISAM. In...
Introduction to Joomla
Support for Joomla Version 2.5 ended at version 2.5.28 on December 31,
2014. It is vitally important for you to upgrade your older Joomla! 2.5
site to the current version of Joomla! (Version 3.4.8) to ensure that your
site stays secure and its add-ons remain compatible. Joomla! 3.x is a
totally re-written script that streamlined the core code so it would run
more efficiently, provide fewer opportunities for hackers and web bots to
attack sites and greatly enhance native Joomla! features such as
permissions and groups, mobile device support (called responsive...
In this Tutorial you will learn how to Install LIFERAY CentOS. Liferay CentOS is a lightweight yet powerful open-source platform for
developing web portals. It is a popular choice by users across a range of
industries because of its flexibility and ease of use. Liferay CentOS
Portal includes a portal, web content management system, document
management system and social collaboration services. Install LIFERAY CentOS PART 1 Step-1 $ yum install java-1.6.0-openjdk-devel –y Then, set up JAVA_HOME environment variable. Step -2 ...
Install Graphite. Graphite is highly scalable real-time graphing system. It
is seen as a replacement for more traditional graphing systems such as
cacti and munin. Install Graphite Requirements
Graphite requires: python2.4 or greater
pycairo (with PNG backend support)
python-ldap (optional - needed for ldap-based webapp authentication)
python-memcached (optional - needed for webapp caching, big performance
python-sqlite2 (optional - a django-supported database module is
bitmap and bitmap-fonts required on some systems, notably Red Hat To install graphite, first you will need to enable the EPEL repository
first. Once enabled pull in the required RPMS. # yum install graphite-web graphite-web-selinux mysql mysql-server...
Introduction to PDO
Now that we can open and close a connection to the database with PDO, we
can make use of it for what databases are made for, storing and retrieving
information. The simplest form of query is the PDO query method. As the
name suggests, this is used to perform database queries. Before we begin to
query a database, lets create a small database with a table for animals.
This will be a MySQL database for use throughout much of this tutorial.
Remember, because PDO provides a common set...
Install testlink Introduction
In this Tutorial you will learn how to install Testlink 1.9.3 on CentOS
6.2: Using yum to install required packages yum install mysql-server php php-mysql php-gd php-ldap Modify /etc/php.ini to optimize php configuration for TestLink session.gc_maxlifetime = 2400
max_execution_time = 120 Set up web server and mysql services chkconfig httpd on
chkconfig mysqld on
Install Drupal 7
In this tutorial you will learn how to Install Drupal 7 ( CMS ) on Ubuntu
Linux using Apache web server and MySQL database. This installation guide
assumes that Apache web server and MySQL database are already installed on
your Linux system. These instructions can be also used on a Debian server or any other Debian
based Linux systems. All commands below are run as root. If you are a sudo user, prefix all
commands below with sudo. Prerequisites Installation
# apt-get install php5-mysql apache2 \
mysql-server php5-gd libapache2-mod-php5 Download And Decompress...
This short tutorial will show you how to show all database tables running
INNODB engine on a mysql server. Login into MySQL mysql> use mysql;
mysql> SELECT table_schema, table_name, engine FROM
INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';
| table_schema | table_name | engine |
| pdns | domains | InnoDB |
| pdns | records ...
If you try to build PHP 5.x.x on a 64bit CentOS install you may get this
error: checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock
checking for mysql_close in -lmysqlclient... no
checking for mysql_error in -lmysqlclient... no
configure: error: mysql configure failed. Please check config.log for more
information. Looking further into the config.log you will also see: configure:60376: checking for mysql_error in -lmysqlclient
configure:60395: gcc -o conftest -I/usr/include -g -O2
-Wl,-rpath,/usr/lib/mysql -L/usr/lib/mysql -L/usr/lib
-Wl,-rpath,/usr/kerberos/lib64 -L/usr/kerberos/lib64 -Wl,-rpath,/usr -L/usr
conftest.c -lmysqlclient -lz -lpng -lz -lcurl...