70 Sites And Mysql connection error sometime

kenhirai
Posts: 330
Joined: Wed Jan 02, 2013 4:25 am

Re: 70 Sites And Mysql connection error sometime

Post by kenhirai »

My server has 16 gb ram already.

What should I do to optimize then?
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: 70 Sites And Mysql connection error sometime

Post by admin »

ok
So how do you see that Ram is overloaded ?
Don't forget to run script update
kenhirai
Posts: 330
Joined: Wed Jan 02, 2013 4:25 am

Re: 70 Sites And Mysql connection error sometime

Post by kenhirai »

ok first, tell me how to setup slave and master database with different server.

Master database in server A

Slave 1 2 3 4 5 Database in server B. How should I configure the Linked DB Server? Tell me this first.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: 70 Sites And Mysql connection error sometime

Post by admin »

Exactly the same way as with local master except host (not localhost)
Don't forget to run script update
kenhirai
Posts: 330
Joined: Wed Jan 02, 2013 4:25 am

Re: 70 Sites And Mysql connection error sometime

Post by kenhirai »

ok I gottcha. now back to the 160 copies of Smart CJ in one box. What kind of setting is he using man? I put 70 copies and MYSQL connection keep maxing and can't access. It says too much connection, I do not know what hardware is causing this. my Technician says every request of the gallery from the database cost a connection and I have 70 sites connect with each other, there are 4600 galleries in one database, so tell me what is wrong.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: 70 Sites And Mysql connection error sometime

Post by admin »

You told me your RAM and HDD are overloaded.
How do you check it ?
Don't forget to run script update
kenhirai
Posts: 330
Joined: Wed Jan 02, 2013 4:25 am

Re: 70 Sites And Mysql connection error sometime

Post by kenhirai »

What is optimize DB anyways. does it help?

also how to set priority with Cron?
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: 70 Sites And Mysql connection error sometime

Post by admin »

Can you please answer my question ?
Don't forget to run script update
kenhirai
Posts: 330
Joined: Wed Jan 02, 2013 4:25 am

Re: 70 Sites And Mysql connection error sometime

Post by kenhirai »

Myt techinician guy checks them for me.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: 70 Sites And Mysql connection error sometime

Post by admin »

ok, ask him how he does it.
Don't forget to run script update
Post Reply