Hi,
I have found a few other posts regarding this subject, but thought I'd outline the problems I'm having and see if you have any suggestions. Unfortunately my site is being hosted remotely, so I have not control over the settings -- all I can do is offer suggestions.
The problem is that sporadically when working in MySQL (either through the site or through MySQLFront), it generates an error: 'lost connection to mysql'. Simply repeating the query will fix it, however most of the visitors to my site wouldn't realise that and just leave the site, so this is not acceptable.
Following are possibilites I've already considered:
1.CODE - NOT possible, because it happens randomly and also happens when accessing MySQL directly.
2.MAX_ALLOWED_PACKET setting: this is already set very high on the server and my queries are very small, so highly unlikely.
3.WAIT_TIMEOUT: because the settings on the remote host are set to 10, rather than the 28800 which is on my machine I thought this may be causing it. The hosting company has raised that to 180, however the error still occurs.
I have seen a post suggesting that it may be a hardware related issue causing this type of error. Does anyone have any other ideas what the most likely reason for this error is?
Thanks in advance for any help.
I have found a few other posts regarding this subject, but thought I'd outline the problems I'm having and see if you have any suggestions. Unfortunately my site is being hosted remotely, so I have not control over the settings -- all I can do is offer suggestions.
The problem is that sporadically when working in MySQL (either through the site or through MySQLFront), it generates an error: 'lost connection to mysql'. Simply repeating the query will fix it, however most of the visitors to my site wouldn't realise that and just leave the site, so this is not acceptable.
Following are possibilites I've already considered:
1.CODE - NOT possible, because it happens randomly and also happens when accessing MySQL directly.
2.MAX_ALLOWED_PACKET setting: this is already set very high on the server and my queries are very small, so highly unlikely.
3.WAIT_TIMEOUT: because the settings on the remote host are set to 10, rather than the 28800 which is on my machine I thought this may be causing it. The hosting company has raised that to 180, however the error still occurs.
I have seen a post suggesting that it may be a hardware related issue causing this type of error. Does anyone have any other ideas what the most likely reason for this error is?
Thanks in advance for any help.
