denvercardonations
Active member
- Joined
- Mar 1, 2016
- Messages
- 66
- Points
- 0
My website has been up for 2 months, and I was getting error 508's, SQL errors, PHP timeout errors, etc. After weeks of my webhost blaming Joomla they sent me this:
Hello John,
We do understand your desire to have a website working flawlessly.
That is what we, as the hosting company, are trying to achieve as well.
We are sorry if our previous reply left you under impression that we accusing the CMS you are using of the issues you are currently experiencing.
That was not our intention - what we wanted to do is just describe and explain the logs Oksana has provided in most detailed way to give you full image of how the end-product (i.e. the index page of your site) is being generated.
However, it is true that the size of the database your site's using is far to big.
Let me explain myself further here: MySQL databases, as you may know, are just some amount of text data structured in a relational way, so that it can be easily accessed.
470 Mb of text is just about enough to get half of Library of Congress's books saved under your account (that is rough comparison just to give the idea of text stored under your account now).
We are very sorry that you have been advised to upgrade the hosting account without prior addressing of the root cause of the issue - that is our fault and it is true.
Simply upgrading the account would not get the issue sorted out. Mostly because how MySQL works.
The truth also is that even some of the most powerful dedicated servers will not guarantee the stability of the site in this situation.
What needs to be done is examining the database for duplicate entries - that may explain the time of query execution - for instance in query like this one:
| 827617 | stephbmn_nctest | localhost | stephbmn_step13 | Query | 5001 | Copying to tmp table | SELECT
'5001' is the time in seconds server waited for the query to complete. That is somewhere around 2 hours, whereas standard query on a database with the size of 100-200 Mb is 0.04 - 0.5 seconds
We are only trying to help you to resolve the issue completely.
---------
Regards,
Eugene N.
Level 2 Hosting Customer Support
I have articles, meeting lists, is it really too big? How can this be, I just use the basic CMS functions....
Hello John,
We do understand your desire to have a website working flawlessly.
That is what we, as the hosting company, are trying to achieve as well.
We are sorry if our previous reply left you under impression that we accusing the CMS you are using of the issues you are currently experiencing.
That was not our intention - what we wanted to do is just describe and explain the logs Oksana has provided in most detailed way to give you full image of how the end-product (i.e. the index page of your site) is being generated.
However, it is true that the size of the database your site's using is far to big.
Let me explain myself further here: MySQL databases, as you may know, are just some amount of text data structured in a relational way, so that it can be easily accessed.
470 Mb of text is just about enough to get half of Library of Congress's books saved under your account (that is rough comparison just to give the idea of text stored under your account now).
We are very sorry that you have been advised to upgrade the hosting account without prior addressing of the root cause of the issue - that is our fault and it is true.
Simply upgrading the account would not get the issue sorted out. Mostly because how MySQL works.
The truth also is that even some of the most powerful dedicated servers will not guarantee the stability of the site in this situation.
What needs to be done is examining the database for duplicate entries - that may explain the time of query execution - for instance in query like this one:
| 827617 | stephbmn_nctest | localhost | stephbmn_step13 | Query | 5001 | Copying to tmp table | SELECT
'5001' is the time in seconds server waited for the query to complete. That is somewhere around 2 hours, whereas standard query on a database with the size of 100-200 Mb is 0.04 - 0.5 seconds
We are only trying to help you to resolve the issue completely.
---------
Regards,
Eugene N.
Level 2 Hosting Customer Support
I have articles, meeting lists, is it really too big? How can this be, I just use the basic CMS functions....
