buy tb500

Archive for the ‘Linux’ Category

mysql slow queries

Wednesday, January 12th, 2011
wget http://hackmysql.com/scripts/mysqlsla
chmod 755 mysqlsla*
mv mysqlsla* mysqlsla
./mysqlsla -lt slow /var/log/mysql-slow.log

reference 

http://forums.cpanel.net/f189/high-load-mysql-160213.html

check directory files size in linux

Sunday, January 9th, 2011

1- go inside the directory for example

cd /home/alzweac

alzweac#du -sh

2.4Gb

Thank you.

A quick performance tune for mysql – innodb_buffer_pool_size

Sunday, January 2nd, 2011

If you are using MySQL with InnoDB tables, you should really look at the innodb_buffer_pool_size.   This tells MySQL how much memory it should use to cache data on your InnoDB tables.  This cuts down on disc IO.  It can save you alot of lookup time if you are pulling out of the cache as opposed to making another call to the database table.  As a good rule of thumb this value should be set to 10% larger than the size of your database… that is assuming you have that much memory available on your server.  By default innodb_buffer_pool_size is set to 8MB.  If you have a decent sized data set, and most of you probably do, then you are going to want to increase this.  My database is about 1GB, so I set my innodb_buffer_pool_size to 2GB, so that I can account for some growth in the future.  Just be sure not to set the value too high.  If you only have 2GB of memory on your box, then don’t set it to 2GB.  This can cause paging at the OS level and that is bad news.

So here is how you set that parameter in mysql

open up your /etc/my.cnf in your favorite editor and add the parameter in the mysqld section

[mysqld]
innodb_buffer_pool_size = 2G

Then you restart mysql and the changes should be picked up.

/etc/init.d/mysqld restart

You can double check by issuing the following command in mysql client.  It will show you the variable and its value

mysql> SHOW VARIABLES;

NOW THATS A QUICK AND EASY PERFORMANCE TUNE!!

Thank you.

The encoded file /var/cpanel/rvglobalsoft/rvsitebuilder/www/ionctestlicense.php requires a license file rvsitebuilder.lic.

Saturday, December 25th, 2010

Please contact your provider to force update using the following instruction.
1. SSH to the server as root and run this command.

rm -f /var/cpanel/rvglobalsoft/rvsitebuilder/var/INSTALL_COMPLETE.php
rm -f /var/cpanel/rvglobalsoft/rvsitebuilder/rvsitebuilderversion.txt
perl /usr/local/cpanel/whostmgr/docroot/cgi/rvsitebuilderinstaller/autoinstaller.cgi

2. Go to root WHM/RVSiteBuilder, it will automatically rebuild the database for you.

To force update both steps need to be done. It still keeps your previous data, configuration and translation (given that you do not edit files directly but edit from RVSiteBuilder Manager). If doesn’t work, please submit me the login information to the account in question or attach me the snapshot of what you did and its result.

vim: error while loading shared libraries: libperl.so

Saturday, December 18th, 2010

to find the solution, refer to below URL, we got the apove error, then we used the below solution and worked fine

http://www.blogjava.net/lyjjq/articles/79408.html

Thank you.

ClamAV in Centos Linux

Saturday, December 18th, 2010

The steps in the URL below

http://www.mybanglaspace.com/public/blog/view/id_2142/title_ClamAV-in-Centos-Linux/

Thank you.

Fatal error: Allowed memory size of 67108864 bytes exhausted

Friday, December 10th, 2010

Solution

1. Try adding this line to your wp-config.php file:
define('WP_MEMORY_LIMIT', '64M');

2. If you have access to your PHP.ini file, change the line in PHP.ini
If your line shows 32M try 64M:
memory_limit = 64M ; Maximum amount of memory a script may consume (64MB)

3. If you don't have access to PHP.ini try adding this to an .htaccess file:
php_value memory_limit 64M

4. Talk to your host.

Thank you.

RHEL Red hat enterprise Linux

Wednesday, September 29th, 2010

You can check the version using the below command

#uname -mrs   to check how many bit 64 or 32

#cat /etc/redhat-release  this to check the version

References

http://www.cyberciti.biz/tips/vmware-on-centos5-rhel5-64-bit-version.html

RVsirebuilder Cpanel issue

Tuesday, September 28th, 2010

if you got below error

The encoded file /var/cpanel/rvglobalsoft/rvsitebuilder/www/ionctestlicense.php requires a license file.
The license file /var/cpanel/rvglobalsoft/rvsitebuilder/rvsitebuilder.lic has expired. in Unknown on line 0

this is the solution

1. SSH to the server as root and run this command.

rm -f /var/cpanel/rvglobalsoft/rvsitebuilder/var/INSTALL_COMPLETE.php
rm -f /var/cpanel/rvglobalsoft/rvsitebuilder/rvsitebuilderversion.txt
perl /usr/local/cpanel/whostmgr/docroot/cgi/rvsitebuilderinstaller/autoinstaller.cgi

2. Go to root WHM/RVSiteBuilder, it will automatically rebuild the database for you.

i have tried the solution my self and it is working fine,

References

http://forums.rvskin.com/index.php?showtopic=3268

qmail in plesk

Tuesday, September 28th, 2010

this command to check the logs     vi  /usr/local/psa/var/log/maillog

refer to the below article will give you more details on how to mange the mail queue

http://logicsupport.com/blog/?p=101

Thank you.