How To Optimizing MySQL server

Posted by cikul | Posted in Internet, Linux, web | Posted on 20-04-2009-05-2008

11

mysqlFor the web server that using mysql as a database engine. Sometimes the process in mysql need a large resource, especially if server has a high traffic. According to my experience, to the high traffic server, the MySQL process itself can spend more than 30% of server resources. So, I will give you tips for optimizing mysql on the server that has high traffic.

Mysql configuration located in the my.cnf file, usually this file is in the /etc directory, but can also in other folders. For more safe, you can search my.cnf file to make sure the location of the file. Read the rest of this entry »

Incoming search terms:

optimize mysql server | how to optimize mysql server | optimize mysql | your applications are not closing mysql connections properly | rails your applications are not closing mysql connections properly | cpanel MySQL hardening and optimize | mysql tuner windows server 2003 | optimazation mysql server | optimize mysql configuration 1gb of ram | optimize mysql for high traffic | 

Share and Enjoy

Repair Internal Server Error Cpanel account

Posted by cikul | Posted in Linux | Posted on 19-08-2008-05-2008

2

If you have cpanel server, and have phpsuexec or suphp installed and you get “Internal Server Error” message while accessing account on your server, you must see permission in users directory. If PHP runs with phpsuexec or suphp, all files under accounts must have correct ownership. If you see that your directory/account ownership still nobody, you must change it manually or you can use cpanel included scripts to repair permission for all accounts.

First, you must log into SSH, and then you can run this script :

root@server [/]# /scripts/chownpublichtmls

hope this helps

Incoming search terms:

internal server error cpanel | Internal Server Error in cpanel | 

Share and Enjoy