We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
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.