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.
Dedicated Semi-Managed Server Review I've been using AYKSolutions for about 2 years now and their support and servers have been great. They assisted me with the transition of all my websites and databases from my old server onto their system with no problem. If I ever need them for support or a change they respond fast and always keep me up to date with the status of my support ticket. I highly recommend using this company especially if you're looking for someone to assist with server management. Best of all their cost is great!
Hi Guys and Gals, I'll just say you all are top notch and go above and behind with support. I've tested many other companies none compare to the expertise you all. Previously I would just get a ticked bumped up to a higher level of tier support etc. with AYK everyone is knowledgeable and prompt. Thank you for offering a premium hosting solution. Warm Regards, Johnny
Outstanding Customer Service Everytime I have emailed AYKsolutions I have gotten an outstanding response time from the technical support team. Not only that, they are very friendly and very easy to work with. When I initially setup my account I had a small problem and had to delete everything and start over. This was not a problem for AYK and they were able to get me up and running in no time at all