23 - Out of resources when opening file './ds071sql1/manufacturers.MYD' (Errcode: 24 - Too many open files)

select distinct m.manufacturers_id, m.manufacturers_name from manufacturers as m, products as p where m.manufacturers_id=p.manufacturers_id order by m.manufacturers_name

[XT SQL Error]