I enabled the innodb_plugin-1.0.4 made the necessary changes into the my.cnf file to bring the innodb plugin into the effect . Restarted MySQL and got the log entry into the MySQL error log InnoDB: The InnoDB memory heap is disabled , on some checking I got in this page (http://www.innodb.com/doc/innodb_plugin-1.0-doc-single/innodb-plugin.html#innodb-performance-use_sys_malloc) that I need to set [...]

I got this error while I was trying to setup a MySQLServer as Copy of another server I did not check the memory available in the system and I got the error “InnoDB: Fatal error: cannot allocate the memory for the buffer pool” I realized that the memory of the system is less then the [...]

Introduction In this article, I’ll show you how to get ReiserFS running under a typical Linux distribution. I’ll also share lots of technical information on a variety of topics, such as performance considerations and more. Since I’ll be covering installation first, I recommend that you read this article in its entirety before following the installation [...]

We sometime need to access the data (tables ) which lies on another remote MySQL DB Server , MySQL provides an engine type federated which does exactly what we want . The FEDERATED storage engine enables data to be accessed from a remote MySQL database on a local server without using replication or cluster technology. [...]

# htaccess to stop files listing on folder and stop executing any file inside folder like config.ini file etc which are not need to display in the browser IndexIgnore */* (It will stop files listing for specific folder) # deny access to all files of folder Order allow,deny Deny from all Satisfy All Forbidding a [...]

How to find per-process I/O statistics on Linux: Need to monitor Linux server performance? Try these built-in command and a few add-on tools. Most Linux distributions are equipped with tons of monitoring. These tools provide metrics which can be used to get information about system activities. You can use these tools to find the possible [...]

Most of time as an MySQL admin we need to keep track of the DML statements  per table , If we are not using any specific tool for doing this We can use the shell script for doing this which I came across the idea is to use the binlog to get all of the [...]

MySQL Replication is widely and we need to have strong replication monitoring for these things 1) To monitor if the replication is working. 2) To check the latency between the master and slave . 3) TO check the consistency between the master and slave , as sometime due to manual or master server crash , [...]

For those who are still using RHEL 4.x and in need of deploying PHP 5.3 & MySQL 5.1 , you can get the required rpm packages from http://rpms.famillecollet.com/enterprise/4/ You can add the repo and update php and MySQL packages via yum, or download and install manually. I think the bare minimum will require these packages [...]

Space problem with /var and /usr , The server is running mysql . My Plan is to move my /usr and /var to “root” (/). To do that I have to make sure that all security settings and symlink are preserved. Prepare the new partitions In my case, this is simply my “/” partitions, so [...]

MySql replication scenario Solves a.)One of the biggest advantages to have master-slave set up in MySQL is to be able to use master for all of the inserts and send some, if not all, select queries to slave. This will most probably speed up your application without having to diving into optimizing all the queries [...]

Summary If you are reaching the limits of your server running Apache serving a lot of dynamic content, you can either spend thousands on new equipment or reduce bloat to increase your server capacity by anywhere from 2 to 10 times. This article concentrates on important and poorly-documented ways of increasing capacity without additional hardware. [...]

Yum prerequistes are: python-elementtree is needed by yum-2.4.2-0.4.el4.rf.noarch python-sqlite is needed by yum-2.4.2-0.4.el4.rf.noarch urlgrabber is needed by yum-2.4.2-0.4.el4.rf.noarch and the prereques for Uvh python-sqlite is: libsqlite-2.8.15-1.i386.rpm These rpm are to be installed in the following order # rpm -Uvh libsqlite-2.8.15-1.i386.rpm # rpm -Uvh python-elementtree-1.2.6-7.el4.rf.i386.rpm #rpm -Uvh python-sqlite-0.5.0-1.2.el4.rf.i386.rpm # rpm -Uvh python-urlgrabber-2.9.7-1.2.el4.rf.noarch.rpm # rpm -Uvh yum-2.4.2-0.4.el4.rf.noarch.rpm [...]

One of the tools most Linux/Unix admins are used to is called “top”. “top” by itself is a very powerful tool. Installation Perl modules in cpan install Term::ReadKey install File::Tail install Time::HiRes Create a executable script #touch /usr/bin/httptop #chmod a+x /usr/bin/httptop Copy & paste the following contents in the script #!/usr/bin/perl -w use Time::HiRes qw( [...]

The primero recommendation for speeding up a website is almost always to add cache and more cache. And after that add a little more cache just in case. Memcached is almost always given as the recommended cache to use. What is Memcached? Memcached is a general-purpose distributed memory caching system that was originally developed by [...]