MySQL

Benchmark Your System CPU, File IO, MySQL

Benchmark suite which allows you to quickly get an impression about system performance which is important if you plan to run a database under intensive load.

not issue any guarantee that this will work for you

1 Installing sysbench

Debian/Ubuntu, sysbench can be installed

apt-get install sysbench

a look

man sysbench

2 CPU Benchmark

benchmark your CPU performance

sysbench –test=cpu –cpu-max-prime=20000 run

root@server1:~# sysbench –test=cpu –cpu-max-prime=20000 run
sysbench 0.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 1

Doing CPU performance benchmark

Threads started!
Done.

Continue reading “Benchmark Your System CPU, File IO, MySQL” »

Be the first to comment - What do you think?  Posted by Aniruddh - August 8, 2012 at 6:22 pm

Categories: Linux, MySQL   Tags:

How To Set Up WebDAV With MySQL Authentication On Apache2 (Ubuntu 9.10)

1 Preliminary Note

I’m using an Ubuntu 9.10 server with the hostname server1.example.com and the IP address 192.168.0.100 here.

2 Installing Apache2, WebDAV, MySQL, mod_auth_mysql

To install Apache2, WebDAV, MySQL, and mod_auth_mysql, we run

aptitude install apache2 mysql-server mysql-client libapache2-mod-auth-mysql

don’t have to specify a MySQL root password manually later on:
New password for the MySQL “root” user: < -- yourrootsqlpassword
Repeat password for the MySQL "root" user: <-- yourrootsqlpassword

Afterwards, enable the WebDAV and mod_auth_mysql modules

a2enmod dav_fs
a2enmod dav
a2enmod auth_mysql

Restart Apache

/etc/init.d/apache2 restart

3 Creating A Virtual Host

I will now create a default Apache vhost in the directory /var/www/web1/web. For this purpose, I will modify the default Apache vhost configuration in /etc/apache2/sites-available/default. To enable WebDAV, you must adjust this tutorial to your situation.

First, we create the directory /var/www/web1/web and make the Apache user (www-data) the owner of that directory

mkdir -p /var/www/web1/web
chown www-data /var/www/web1/web

back up the default Apache vhost configuration (/etc/apache2/sites-available/default) and create our own one

mv /etc/apache2/sites-available/default /etc/apache2/sites-available/default_orig
vi /etc/apache2/sites-available/default

reload Apache

/etc/init.d/apache2 reload

4 Configure The Virtual Host For WebDAV

Continue reading “How To Set Up WebDAV With MySQL Authentication On Apache2 (Ubuntu 9.10)” »

Be the first to comment - What do you think?  Posted by Aniruddh - December 20, 2011 at 4:33 pm

Categories: Apache, MySQL   Tags:

Installation Of Liferay Portal 6.0.5 Community Edition With Java And MySQL On Ubuntu 10.04 Server

Liferay Portal is an enterprise web platform for building business solutions that deliver immediate results and long-term value. Get the benefits of packaged applications and an enterprise application framework in a single solution.

1. Install Java JDK

a) First we will create a directory for java

mkdir /usr/java

b) Now we must download the JDK.

For this tutorial I will be using the 64bit version, if you are using the 32bit version of Ubuntu you will need to download the i586 version.
Go to http://www.oracle.com/technetwork/java/javase/downloads/jdk6-jsp-136632.html and download ‘jdk-6u21-linux-x64.bin’ to the java directory you created in step 1

c) Now we will make the bin file executable and run it

cd /usr/java
chmod +x jdk-6u21-linux-x64.bin
./jdk-6u21-linux-x64.bin

d) We must insert the following lines inside /etc/profile for both JDK6 and Liferay Portal

Open /etc/profile

nano /etc/profile

e) Ensure that JAVA_HOME and LIFERAY_HOME environment are correctly set. To do this, open a new terminal and type the following commands

echo $JAVA_HOME
echo $LIFERAY_HOME

2. Create the database

mysql -u root –p

Create a database

CREATE DATABASE lportal DEFAULT CHARACTER SET utf8;
quit;

3. Create a directory for Liferay

mkdir /usr/liferay

Continue reading “Installation Of Liferay Portal 6.0.5 Community Edition With Java And MySQL On Ubuntu 10.04 Server” »

Be the first to comment - What do you think?  Posted by Aniruddh - December 8, 2011 at 6:21 pm

Categories: java, MySQL, Ubuntu   Tags:

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 10.10 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 10.10 server with PHP5 support (mod_php) and MySQL support.

1 Preliminary Note

the hostname server1.example.com with the IP address 192.168.0.100. These settings might differ for you, so you have to replace them where appropriate.

I’m running all the steps in this tutorial with root privileges, so make sure you’re logged in as root

sudo su

2 Installing MySQL 5

install MySQL 5

aptitude install mysql-server mysql-client

You will be asked to provide a password for the MySQL root user – this password is valid for the user root@localhost as well as root@server1.example.com, so we don’t have to specify a MySQL root password manually later on

Continue reading “Installing Apache2 With PHP5 And MySQL Support On Ubuntu 10.10 (LAMP)” »

Be the first to comment - What do you think?  Posted by Aniruddh - December 5, 2011 at 8:49 am

Categories: Apache, MySQL, PHP, Ubuntu, Web Server   Tags:

Installing MySQL Administrator Tool To Connect To Remote Databases

step-by-step instructions on how to install MySQL Admin tool on an Ubuntu 11.04 system and how to connect to a remote host with it. This should also work on most Debian based operating systems.

Installing MySQL Administrator
the name of the tool using command line

apt-cache search mysql | grep admin

that the package we are looking for is called

mysql-admin – GUI tool for intuitive MySQL administration

install it with command

sudo apt-get install mysql-admin

Using MySQL Administrator

Continue reading “Installing MySQL Administrator Tool To Connect To Remote Databases” »

Be the first to comment - What do you think?  Posted by Aniruddh - November 13, 2011 at 2:04 am

Categories: Installation, MySQL   Tags: