July 29th, 2010 by Pankaj Joshi
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 [...]
Read More
July 29th, 2010 by Pankaj Joshi
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 [...]
Read More
July 20th, 2010 by Manoj Chauhan
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 [...]
Read More
July 16th, 2010 by Pankaj Joshi
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. [...]
Read More
July 13th, 2010 by Manoj Chauhan
# 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 [...]
Read More
July 13th, 2010 by Manoj Chauhan
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 [...]
Read More
July 12th, 2010 by Pankaj Joshi
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 [...]
Read More
July 8th, 2010 by Pankaj Joshi
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 , [...]
Read More
July 6th, 2010 by Pawan Kumar
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 [...]
Read More
July 6th, 2010 by Pawan Kumar
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 [...]
Read More
July 2nd, 2010 by Pawan Kumar
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 [...]
Read More
June 30th, 2010 by Manoj Chauhan
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. [...]
Read More
June 29th, 2010 by Pawan Kumar
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 [...]
Read More
June 29th, 2010 by Pawan Kumar
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( [...]
Read More
June 28th, 2010 by Manoj Chauhan
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 [...]
Read More