Group,
Recently in the last couple of months I have had several problems with the database. I keep getting Database busy error messages.
Now I do run a 100% database driven website, that goes for the main landracing.com website, to the message board and the photo gallery. Every aspect of the website is database driven.
I have been watching to see what is giving the errors, and that has resulted in part of the functionality of the website disabled. I first tried updating all the software on the website, then tweaking the settings of each program. This is not an easy solution. You have to make an adjustment and try it for awhile to see if the problem still exists.
MY hosting company has not been to helpfull in the situation. I thought the main problem was the online photo gallery, so i reduced the functionality of the program to minimal features. Still exists. Then I killed the whole gallery and obviously to the problem is still there. Now I am getting errors more then ever. So I took the message board posts and weather off the main site. ANd the problem is still there. I think there is more to the problem then I think.
First the site has grown and I have outgrown the server that I am on, and its not a software problem, and I pay dearly for the service.
The website is a resource heavy website, from a sever standpoint. When loads get high it starts killing processes until that load gets below a certain threshold.
I have been transferring on average this past year 50 gig of bandwith per month, and in August, Sept and October it was as high as 70 gigs. And averaging just about 5 million hits a month.
The honest answer is I have outgrown the server that I am on. I am on a server that is a single processor so loads on the server get there fast. I have found a new server that is based on four processors and a high ram system that I may try to use. I will transfer the whole website there and test it out. The real test will be when the current users get there.
The main single most important, is a seamless move. Moving servers in past experience is usually a real pain in the ass. But thanks to better technology today it may not be that bad.
I will test a server move and see how it goes. When a real transfer happens, I will have to kill, or put in maint mode, the main site, the forums and gallery. This is so I dont loose any information or new posts in forums.
So trust me when I say, I know of the problems, been trying to resolve the problems and hopefully have a solution in the near future.
Stay with me, things will get better.
Jon