Allows you to search a variety of questions and answers
These are just some general tips on what you can do/setup to optimize your server, whether it's with databases, apache or something else. These are in no particular order, so use whatever you think is necessary in your case.
1. Try installing memcached/memcache to help with dynamic content and to take the load off of your database server. http://www.danga.com/memcached/and http://www.sohailriaz.com/how-to-ins...-on-centos-5x/
Don't forget to configure /etc/sysconfig/memcached. Should look something like this:
PORT="11211"
USER="nobody" (this should be the same as your webserver user (apache, etc..))
MAXCONN="2048"
CACHESIZE="4096"
OPTIONS=""
To start memcached, use the following syntax, where 'm' is the memory it will use and -d means it will run as a daemon on port 11211 locally:
memcached -d -u root -m 2048 -l 127.0.0.1 -p 11211
You can use the following init script to stop/start memcached easier: http://www.vbseo.com/blogs/danny-bem...-memcached-44/. Just note the new memcached.conf configuration and path.
Alternatively, it may be easier to simply install it using yum:
yum -y install memcached
- just use the rpmforge repo for this and that will get it setup automatically. Use the aforementioned variables for the /etc/sysconfig/memcached file.
You can also check out the following post on how to get memcached and memcache setup and configured: http://www.sohailriaz.com/how-to-ins...-on-centos-5x/ - This is a good method
2. Try running tuning primer on Mysql and make the necessary adjustments. https://launchpad.net/mysql-tuning-primer
3. Try running mysqltuner to get more details on what can be optimized within your mysql file. http://blog.mysqltuner.com/download/
4. Try installing ELS script from servermonkeys. This will optimize/harden your server in several areas. http://www.servermonkeys.com/els.php
5. Try installing mod_top and iftop. http://www.mod-top.org/ and http://www.ex-parrot.com/pdw/iftop/
6. Install EAccelerator with PHP to cache content and deliver it faster, thus taking load off of the server. http://blog.eukhost.com/webhosting/e...-installation/and http://wiki.asmallorange.com/HOWTOInstallEA
7. Try to run 'mysqlcheck -c -A' as root to fix any corrupted tables you may have. This will only work if you are using MySQL.
8. It's also very possible that you have a large log file somewhere (2GB in size) that is causing this slowdown. To find it, run the following command for the directory you want to check (can just use / to check the whole root): find / -type f -size +1G
There are certainly a lot more things you can do, but the above ones should atleast give you a good start.
AYK Solutions has provided me with a very cost effective hosting service with great uptime and lots of features. I would not hesitate to recommend them!
You can trust your business with AYKsolutions After a horrible experience with my prior host that left me with over 14 hours of downtime, AYKSolutions came in, took care of the transfer completely and made my life easier. When they say their servers are semi-managed, it means they take care of more then most managed server hosting companies. Average ticket response time? 2-5 minutes. One time i n the middle of the night it took 30 minutes. Problems that I create are fixed immediately and they take care of their customers. Artyom is the owner, who is somehow capable of not sleeping. He's always there to take care of everything with a personal touch. 3 AM on a Saturday? Not an issue for AYKSolutions. Trust me, I'm very thorough in researching a company. When it comes to business, you can never be too careful. I trust my business with AYKSolutions
AYKSolutions is thee best hosting solution I have found in 10 years of searching. I'm very grateful of the services they provide. Such a vast variety to host whatever you desire at a great rate. The support team has always been great, always get a reply within 4 Hours of posting, usually way before 4H. I have a range of 1-10gbit machines and they've always kept up with premium standards. Networks they sell are premium, guaranteed. Thank you, AYK :)