MYSQL Connections

[Dooty]

how can i get more mysql connections. It says too many connections after a while.

[Edge100x]

You can set this in the my.cnf / my.conf file, but you should really fix your application that is leaking them, instead.

[Dooty]

i fixed that by simply just removing the online/offline check. After like 12 hours, my game server will say too many connections.

[Dooty]

where excatly are those 2 files located at

[Dooty]

anyone?

[Dooty]

You can set this in the my.cnf / my.conf file, but you should really fix your application that is leaking them, instead.

Where is my.cnf / my.conf file located? I can't seem to find it in my Windows server

[.=QUACK=.Major.Pain]

I think they are in your mysql folders somewhere.

[Dooty]

i found it in my.ini
putting max_connection = 10000 is correct right?

[.=QUACK=.Major.Pain]

That will allow more connections if increased, but would also increase the load.

[Dooty]

whats the maxmium connection? cause i wanna put at max. more connections would mean i need more ram eventually correct?

[Edge100x]

You really need to fix your plugin/application instead of just changing this. Bumping up the limit will just delay the problem a bit, and you'll still run into it, if you're leaking connections.