Increase KVM resources? Out of resources when opening file

[asmar]

Hi all,

After every reboot on a KVM machine mysql doesn't work and need to repair manually the DBs to make it work again.
Today after another reboot it doesn't. I'm getting:

ERROR 1016 (HY000) at line 1: Can't open file: .... wherever I'm starting/restarting the db and also:

MySQL said:
#23 - Out of resources when opening file '/tmp/#sql_cf2_0.MYI' (Errcode: 24)

and

mysqlcheck: Error: Couldn't execute 'SHOW DATABASES': Out of resources when opening file '/tmp/#sql_cf2_0.MYI' (Errcode: 24)

From what I read it seems that need to increase the open files or so on the system but I did and still the same.

Any help is much appreciated.

 

[asmar]

A little bit more debugging:

root@korina:~# cat /proc/sys/fs/file-nr
3008 0 104854

It shows that the total free allocated file descriptors

are 0

I have no clue what is this but might be the problem? Any idea how to increase this?

Thanks

 

[tom]

you talk about a mysql inside a VM.? if yes, you need to debug this inside your VM, not related to the Proxmox VE host.

if you need more RAM, add/assign more to your VM. If you need more virtual disk space, add more.

 

[asmar]

This is an old post but came up recently. The VM itself has lots of resources, the stats showing that it use just a couple of MB RAM, has plenty of space etc. No load problem. The host itself has no high load etc.
On the initial post I didn't manage to solve it and had to migrate it to a dedicated server.

Same issue arrive today on a LXC container.

Any help is very much appreciated.