Page 1 of 1
MySQL Out of Resources
Posted: Tue Sep 29, 2015 9:15 am
by masson
Hi Guys,
I'm very new to Vesta CP. I have setup 2 different servers but on both they have MySQL issues in about 24hrs. time. I don't have many websites on those servers, but i still get an error such as "Out of Resources". Do you know what could be causing this ?. I'm guessing that i need to configure it better ?.
Re: MySQL Out of Resources
Posted: Tue Sep 29, 2015 10:02 am
by tjebbeke
masson wrote:Hi Guys,
I'm very new to Vesta CP. I have setup 2 different servers but on both they have MySQL issues in about 24hrs. time. I don't have many websites on those servers, but i still get an error such as "Out of Resources". Do you know what could be causing this ?. I'm guessing that i need to configure it better ?.
You can try to optimize your configs (
http://mysqltuner.com/). Or upgrade your server (more RAM, Add swap, ...).
Re: MySQL Out of Resources
Posted: Wed Sep 30, 2015 11:19 am
by ugnelakys
masson wrote:Hi Guys,
I'm very new to Vesta CP. I have setup 2
different servers but on both they have MySQL issues in about 24hrs. time. I don't have many websites on those servers, but i still get an error such as "Out of Resources". Do you know what could be causing this ?. I'm guessing that i need to configure it better ?.
Who eats you resources? Who eats RAM? Who eats useage of processor?:
PHP?
Too many queries?
May some queries are slow?
External server scripts?
Another site?
Mysql server simply is crashed?
enable logs for slow queries; maybe for all queries. Examine server state - caches and variables with mysql command line tool.
Re: MySQL Out of Resources
Posted: Thu Oct 01, 2015 11:12 am
by Elizine
Hi,
You may receive an error message when you try to run an existing CLR object or create an assembly that has the external_access or unsafe permission set on a database that is attached or restored from a different server.