How should i handle my mysql? (phoenix)

Printable View

15-01-14
NoOne96

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 :)
16-01-14
tomsandz

Re: How should i handle my mysql? (phoenix)

Are you using IIS or xampp?
16-01-14
NoOne96

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..
17-01-14
NoOne96

Re: How should i handle my mysql? (phoenix)

Bump.
17-01-14
Lewislol

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.
17-01-14
The General

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.