MySQL Out of Resources
MySQL Out of Resources
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 ?.
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 ?.
-
- Collaborator
- Posts: 783
- Joined: Mon May 11, 2015 8:43 am
- Contact:
- Os: CentOS 6x
- Web: apache + nginx
Re: MySQL Out of Resources
You can try to optimize your configs (http://mysqltuner.com/). Or upgrade your server (more RAM, Add swap, ...).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 ?.
Re: MySQL Out of Resources
Who eats you resources? Who eats RAM? Who eats useage of processor?: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 ?.
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
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.
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.