How should i handle my mysql? (phoenix)
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 :)
Re: How should i handle my mysql? (phoenix)
Are you using IIS or xampp?
Re: How should i handle my mysql? (phoenix)
Quote:
Originally Posted by
tomsandz
Are you using IIS or xampp?
IIS, having 450-650 visitors daily..
Re: How should i handle my mysql? (phoenix)
Re: How should i handle my mysql? (phoenix)
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.
Re: How should i handle my mysql? (phoenix)
I suggest you taking a look at the configuration file for your mysql setup. Allow it to use more memory and take more connections.
Quote:
Originally Posted by
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.
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.