mysql slow queries
Wednesday, January 12th, 2011wget 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
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
1- go inside the directory for example
cd /home/alzweac
alzweac#du -sh
2.4Gb
Thank you.
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
Then you restart mysql and the changes should be picked up.
You can double check by issuing the following command in mysql client. It will show you the variable and its value
NOW THATS A QUICK AND EASY PERFORMANCE TUNE!!
Thank you.
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.
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.
The steps in the URL below
http://www.mybanglaspace.com/public/blog/view/id_2142/title_ClamAV-in-Centos-Linux/
Thank you.
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.
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
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
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.