MySQL Out of Resources

masson · Post by **masson** » Tue Sep 29, 2015 9:15 am

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 ?.

Post by **tjebbeke** » Tue Sep 29, 2015 10:02 am

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, ...).

ugnelakys · Post by **ugnelakys** » Wed Sep 30, 2015 11:19 am

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.

Elizine · Post by **Elizine** » Thu Oct 01, 2015 11:12 am

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.

Vesta Control Panel - Forum