CPanel -> Directadmin ( performance problem )

I

i-net

New member
Joined
Mar 9, 2009
Messages
4
Hello,

Description
Last week we have decided to purchase a server for a website (1 site).
Old situation was that the website was running on a CPanel server and we have installed DirectAdmin on our new server. We transferred all information from the CPanel server to DirectAdmin server (everything went well).

The problem we are currently facing is the fact that the load time of our website has risen of about 1,2 sec too 2.5/3/4 seconds.

Could anyone shine a bit of light on why the performance has dropped that much? Because I cannot believe the change has come of the difference between a Xeon or not Xeon.

Technical
CPanel Server (shared hosting):
4 GB RAM
Quad Xeon 2.4 GHZ

DirectAdmin Server (single site):
4GB RAM
Quad 2.4 GHZ
Custombuild Apache 2 / PHP 5
Installed: eAccelerator v0.9.5.3

Thanks in advance
 
Well, for sure it has nothing to do with the control panel.

I suggest you use BSD process accounting to check if it's Apache or PHP (or any other server side process) that is slowing it down, and tshark to see if it's a network problem.
Those are just small hints, sorry but I don't have time to explain it all right now :)
 
Hi Tillo,

Thanks for the fast heads-up.
Because of the time ( its 1am here) I will check your suggestions tomorrow.

Their indeed has been a network switch, but the amount of hops has only gone up by 1. So not sure if it will be a network related problem. I'am trying to debug my code to see if their are any weird things that I have left out.

1 thing that is, that if I comment out my sql queries the site loads ubber fast so then i'd look towards the database / database connection. But cause of the connection didn't change, perhaps the problem could be located in the database, but I don't have an answer 1 2 3 why their should be a problem with that atm.

Off to bed now, cu tomorrow.
 
For MySQL I suggest you read this post of mine, it will help you speed it up a lot.
Using those utilities I've achieved to calm down MySQL in a high-load server from constant 2*100% CPU x 500MB RAM to 2*5% CPU x 1GB RAM: I just had to tune the cache settings and add a couple index keys in the most used tables ;)
 
Hi Tillo,

Thanks for your message.
Today I have looked into the programs, I used the mysql optimizer and I changed some settings, I do see some change and the loading time has come down a little bit, but still not enough to be happy about.

I have also installed the "BSD process accounting". But havn't really found the source of the problem yet ( probaly cause I don't exactly know how the program works ).

Going to sleep again :(, could you perhaps give me a small hint on how to look at the process accounting, so I know what to look at?
 
Well, since you found the problem to be MySQL, process accounting won't help.
It's just a way to see when programs are launched, how much they stay up and how many resources are they using -- for example you may use it to know which, between sbin/httpd (apache) and bin/php, spend most time and resources for a request.

I suggest you look at the mysql optimizer again and try to have no warnings at all.
Then use the slow query log (with no more then 1 or 2 seconds for long_query_time) and "mysqldumpslow -t 10 -s at /path/to/log" to see which queries are taking most average time.
When you have those queries, run "EXPLAIN <query>" via phpMyAdmin in the same database and see if an index key is available; if it's not, add it in the table structure.
If you need help with this last step, just copy the results here and I'll tell you what to do.
 
Dear Tillo,

Thanks alot for the help :cool:, website now has an evarage max of 700ms again wich is perfect. I want to thank you alot for the help and your help was very welcome.

-----
Things I did;
- Run the scripts, tweaked the DB settings.
- Made INDEXED tables in the database <- helps alot!!
 
You must log in or register to reply here.
Back
Top