I need a programmer, willing to pay...

Portal Home > Knowledgebase > Articles Database > I need a programmer, willing to pay...

Posted by cybra, 02-16-2011, 08:16 PM
Hello. I have been having a serious problem with one of my sites. It has caused me to move to a new server, thinking it was my host fault. But after I had my sites migrated to a new server I found out that it is definitely my script that's the problem. I am using a vshare script and have stripped the site down all the way to the default template but it's still loading slow. Earlier today I upgraded to 4GB ram with secureservers.com All my sites are loading fine accept this one <> (soft core adult) which is where the dns is set up and all my other sites are pointed to. I am so exhausted and frustrated from trying to figure this out that I am willing to pay someone to have a look at it and see if you can figure out the issue. I already paid one programmer from the vshare forums but he can't seem to find what the problem is. SO I will need to see that it is fixed first before I pay. But I will pay to have my site working again. Please have a look anyone that has some experience. Last edited by sirius; 02-16-2011 at 08:55 PM.
Posted by wheimeng, 02-16-2011, 08:37 PM
How much traffic is it pushing? Maybe it has more traffic now? Or are the new/old server spec identical?
Posted by cybra, 02-16-2011, 08:47 PM
It is getting around the same traffic, not much 2-3K sometime 4 a day. I was getting 15k to 20+k pageviews on the old server. Now it's like 7k. The old host was a VPS with 364mb ram and this is a Dedicated server with 4GB ram.
Posted by cybra, 02-16-2011, 08:50 PM
I put the regular template back as I don't think that was the problem with the ads.
Posted by RubyRingTech, 02-16-2011, 08:55 PM
If its a dedicated server tweak up the network stack. http://setupalinuxserver.com/better-network-performance Also what does your /etc/my.cnf look like, as this seems to be a mysql backed site. Thanks, Anthony
Posted by cybra, 02-16-2011, 09:01 PM
I was concerned about the /etc/my.cnf file as well, and the programmer I had advised me not to mess with it because the current settings are fine for my site. Although I can't tell anything by looking at it. [mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment this line: # symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
Posted by RubyRingTech, 02-16-2011, 09:12 PM
Your running a default my.cnf, there is no tweaking at all there. There are may different ways to tweak the my.cnf, there is no best one, this one however is what I use and works very well for me. In my opinion only, I would do the following. mv /etc/my.cnf /etc/my.bak nano /etc/my.cnf save and restart mysql. Also run that network tweaking, you will see an instant difference in your downloads. Again, this is all my opinion and works very well from my years of doing this, however as always mileage my vary use at your own risk, blah, blah, blah. Thanks, Anthony
Posted by cybra, 02-16-2011, 09:14 PM
So if I run this command it will increase my performance a little? Does it depend on the server? mv /etc/sysctl.conf sysctl.bak cd /etc wget http://www.setupalinuxserver.com/files/sysctl.conf.txt mv sysctl.conf.txt sysctl.conf /sbin/sysctl -p /sbin/sysctl -w net.ipv4.route.flush=1
Posted by cybra, 02-16-2011, 09:17 PM
Ok this was similar to the settings on my VPS. I was thinking it just looked different on plesk or something. Let me give this try and see what happens. Thanks.
Posted by RubyRingTech, 02-16-2011, 09:20 PM
The network will work on pretty much all linux, ubuntu based OS's Are you running Plesk control panel currently??
Posted by cybra, 02-16-2011, 09:29 PM
Yes I am running plesk. I am having to wait until my host reply with ssh admin login, then I can edit the etc/my.cnf file.
Posted by RubyRingTech, 02-16-2011, 10:02 PM
If your using Plesk, then DONT use that my.cnf example it will break our plesk. Plesk is a royal pain the the butt to do anything with the my.cnf
Posted by cybra, 02-16-2011, 10:07 PM
Do you mean just those certain settings, or cannot edit the file at all?
Posted by RubyRingTech, 02-16-2011, 10:12 PM
Those setting, you can edit it, but plesk itself is very picky. These are some great plesk tweaked my.cnf files. http://servermonkeys.com/projects/el...igs/my.cnf-4.0 http://servermonkeys.com/projects/el...igs/my.cnf-5.0 http://servermonkeys.com/projects/el...igs/my.cnf-4.1 http://servermonkeys.com/projects/el...igs/my.cnf-5.1 Also your site is huge all in all, the main page is 1604.5 KB with alot of errors in it. Check out http://tools.pingdom.com/?url=http:/...pe=0&save=true for some of the large files and missing files. Thanks, Anthony
Posted by cybra, 02-16-2011, 10:20 PM
Ok I will definitely check out the errors. Thanks for that. Also the etc/mn.cnf files, but the only problem I might have is I need the wait_timeout=20 to be around wait_timeout=1800. Will this break plesk? Settings from my old VPS skip-locking character-sets-dir=/usr/share/mysql/charsets/ query_cache_limit=1M query_cache_size=16M query_cache_type=1 max_user_connections=100 max_connections=250 interactive_timeout=120 wait_timeout=1800 connect_timeout=3000 thread_cache_size=96 key_buffer=16M join_buffer=2M max_allowed_packet=16M table_cache=1024 record_buffer=2M sort_buffer_size=1024K read_buffer_size=1024K
Posted by RubyRingTech, 02-16-2011, 10:28 PM
The wait_timeout, no it will not break plesk. Just make sure you backup the current my.cnf. What breaks is the actual plesk panel itself, not your website if not done right. Well the site can break to, but plesk is super picky.
Posted by cybra, 02-16-2011, 11:03 PM
Ok, but what is the default root username for ssh. Is it root or admin? I can't edit the file unless logged in as root. My host usually responds fast but they have left me hanging on this one.
Posted by RubyRingTech, 02-16-2011, 11:07 PM
You will need to run those commands as root. Thanks, Anthony
Posted by cybra, 02-17-2011, 12:18 AM
I managed to get in and edit the /et/my.cnf file and it deems to be loading much better. I noticed back on my VPS server when I changed the connect_timeout=20 to connect_timeout=3000 it made it run even better. Will this interfere with the plesk panel ? "3000"
Posted by RubyRingTech, 02-17-2011, 12:25 AM
Shouldn't. Try it at worst case you have to set it back. However no it shouldn't give the plesk panel any problems.
Posted by cybra, 02-17-2011, 12:52 AM
Ok, thanks for all your help! It's running a lot better.
Posted by RubyRingTech, 02-17-2011, 12:59 AM
No problems, glad I could help out. Anthony
Posted by coderiser, 02-17-2011, 12:07 PM
you can also try http://blog.mysqltuner.com/ for help adjusting your my.conf file

Add to Favourites Print this Article