Testing the MySQL

detoam · 05-01-2007, 09:52 PM

I have noticed that my sites have slowed down, but only the once that use the MySQL. I've tested the server status couple of times and it seems that the database goes on and off. Is there any other way I can test the MySQL for it's status?
the sites I am talking about are forum.detoam.net, gallery.detoam.net, detoamweb.info, detoam.net/blog. From time to time they load fast, but most often they take 20 to 40 seconds to load.

coderpl · 05-02-2007, 09:00 AM

Did you make the tables analize, and repair.
Did you check the double entries in tables, which ofter seems to slow down the tables reading, if not... do that now.

detoam · 05-02-2007, 11:24 AM

Thank You. I did some cleaning up. It seemed to have helped with the loading times. I've noticed that some of the tables were going over their storage quota. Also I have disabled some of the features in the forum and blog that use the database a lot. That sped things up a lot with the side affect being that no cookies get stored so I have to long on everytime.

I am just worried because I have a site going there that is very important to not screw up. It's for my main client and I have been sort of weary to build it up anymore for fear that if it starts to be slow I am going to be in deep doodoo.

coderpl · 05-02-2007, 01:02 PM

What does "deep doodoo" means? I do not really understand that phrase. Anyway under the http://www.greenvote.ca/ there seems to be starting forums place, nothing more

detoam · 05-02-2007, 01:11 PM

"deep doodoo" means that the person I am building for is a upcoming political figure. Which means that the site (the greenvote.ca is actually only one of the parts) will recieve a lot of traffic and so on. So if something screws up I am going to be held responsible. The reason that there is only just a forum there is because I have been worried for now to start any major work. This is my first very major work and I got the jitters. As well as I am at same time trying to build up the other parts of the site on other domains and am trying to co-ordinate so it all works smoothly. Plus I am redoing the graphics for that forum. Everything has to be of a green colour of course. So it's gonna take some more time.

05-01-2007, 09:52 PM	#1
detoam Junior Guru Join Date: Feb 2007 Location: Canada Posts: 663	Testing the MySQL I have noticed that my sites have slowed down, but only the once that use the MySQL. I've tested the server status couple of times and it seems that the database goes on and off. Is there any other way I can test the MySQL for it's status? the sites I am talking about are forum.detoam.net, gallery.detoam.net, detoamweb.info, detoam.net/blog. From time to time they load fast, but most often they take 20 to 40 seconds to load. __________________ Web hosting - with a choice of server location. Link trading

05-02-2007, 09:00 AM	#2
coderpl Member Join Date: Apr 2007 Posts: 219	Re: Testing the MySQL Did you make the tables analize, and repair. Did you check the double entries in tables, which ofter seems to slow down the tables reading, if not... do that now. __________________ “ Printing London \| Drukarnia “

05-02-2007, 11:24 AM	#3
detoam Junior Guru Join Date: Feb 2007 Location: Canada Posts: 663	Re: Testing the MySQL Thank You. I did some cleaning up. It seemed to have helped with the loading times. I've noticed that some of the tables were going over their storage quota. Also I have disabled some of the features in the forum and blog that use the database a lot. That sped things up a lot with the side affect being that no cookies get stored so I have to long on everytime. I am just worried because I have a site going there that is very important to not screw up. It's for my main client and I have been sort of weary to build it up anymore for fear that if it starts to be slow I am going to be in deep doodoo. __________________ Web hosting - with a choice of server location. Link trading

05-02-2007, 01:02 PM	#4
coderpl Member Join Date: Apr 2007 Posts: 219	Re: Testing the MySQL What does "deep doodoo" means? I do not really understand that phrase. Anyway under the http://www.greenvote.ca/ there seems to be starting forums place, nothing more __________________ “ Printing London \| Drukarnia “

05-02-2007, 01:11 PM	#5
detoam Junior Guru Join Date: Feb 2007 Location: Canada Posts: 663	Re: Testing the MySQL "deep doodoo" means that the person I am building for is a upcoming political figure. Which means that the site (the greenvote.ca is actually only one of the parts) will recieve a lot of traffic and so on. So if something screws up I am going to be held responsible. The reason that there is only just a forum there is because I have been worried for now to start any major work. This is my first very major work and I got the jitters. As well as I am at same time trying to build up the other parts of the site on other domains and am trying to co-ordinate so it all works smoothly. Plus I am redoing the graphics for that forum. Everything has to be of a green colour of course. So it's gonna take some more time. __________________ Web hosting - with a choice of server location. Link trading

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SSL Certificate - testing needed	nams	Web Development	1	04-28-2007 02:00 PM
XML to MYSQL	djjase	MySQL	1	04-05-2007 06:51 PM
Need you for testing	Bisje	Web Development	2	01-09-2007 06:41 PM
MySql	jumpenjuhosaphat	PHP	6	07-10-2006 10:04 PM
still testing blog design	redQueen	Website Reviews	1	01-10-2006 10:46 PM