MySQL Errors - Lots!

[willyjb]

Hi - I have had vB up for about 2 weeks and I just stumbled across the mysql.err file and it is huge! It is full of errors of this sort:

001213 8:06:54 Aborted connection 60325 to db: 'vb114' user: 'admin' host: `localhost' (Unknown error)
001213 8:07:28 Aborted connection 60326 to db: 'vb114' user: 'admin' host: `localhost' (Unknown error)
001213 8:08:10 Aborted connection 60327 to db: 'vb114' user: 'admin' host: `localhost' (Unknown error)


So far it is 6,900 KB and growing. The forum seems to be working fine. Have I got a problem?

thank you

[Martin]

it looks like you might need to increase your max connections slightly, though I'm far from an expert. the connections look like they are retrying but failing, which probably means all connections are being used.

increase it in SMALL increments of 10 or so at a time. I had the same thing at first and this is what solved it.

[willyjb]

Hi Martin - I don't think that could be the problem, it is not that busy of a vB. Also about 8 out of 10 connections have a line written to the file i.e almost every connection results in a error being written to the file, rather the board is busy or not.

In the runtime information it has "max_used_connections" = 6 I'm not sure but if this is a rcord of the max used connections at one time, then I am a long way from the 100 it is set at.