Move MySQL to second server is a good idea?

bypazs · 2019-05-08T15:49:20.928Z

I have plan to move MySQL to second server because I think maybe can be increased speed.
any ideas?

TheIndra · 2019-05-08T16:08:58.876Z

It won’t really increate your database speed, maybe even decreate it as it has to connect to another computer… are you worried about ram or something?

bypazs · 2019-05-08T16:59:53.632Z

I got a slow query warning, maybe I should set Index MySQL or upgrade my VPS?

TheIndra · 2019-05-08T17:05:35.112Z

That’s most likely because your queries are too intense, for example don’t request a whole table with x rows in one query

Nimoa · 2019-05-08T17:06:28.561Z

To improve MySQL performance, read this : Speeding up your Server 101 (Windows)

bypazs · 2019-05-08T17:09:09.299Z

thank you I’ll try