How should i handle my mysql? (phoenix)

[NoOne96]

I'm currently running everything on single server, but my database is getting bigger and bigger everyday and it's starting to get a little laggy. I think i should do something about it before it becomes a big problem. Any ideas? Second server for mysql? Using different setup? Anything is appreciated :)

[MentaL]

[tomsandz]

Are you using IIS or xampp?

[NoOne96]

Are you using IIS or xampp?

IIS, having 450-650 visitors daily..

[NoOne96]

Bump.

[Lewislol]

Change your My.ini configuration to accept more connections daily and you might want to change some other shit in it while your editing stuff, I wouldn't use Mysql if I was you change to MariaDB.

[The General]

I suggest you taking a look at the configuration file for your mysql setup. Allow it to use more memory and take more connections.

Change your My.ini configuration to accept more connections daily and you might want to change some other shit in it while your editing stuff, I wouldn't use Mysql if I was you change to MariaDB.

And then tell me why MariaDB is better to use?

The emulator is made for MySQL Server. If you really want to have a better database behind it then go with MsSQL as thats more stable.