MySQL concurrency limitation

[durjoy]

I am running 4 GB memorry on my server . but some of my users misusing mysql resources . due to that my other sites are running extremly slow . i would like to put concurrency limitation on my server . how to do that with Direct admin ??

please help ... i need to setup concurrency limitation badly on my server .


Joy

 

[tillo]

What do you mean by "concurrency limitation"? A limit on the amount of concurrent connections by user?

Modifying MySQL caches configuration you can change a lot about its performance and overheads.
DA doesn't manage MySQL configuration, no control panel does: it's a complicated task, you have to audit it and see what's needed where.
I suggest you use a script that helps doing just that and suggests some settings: Tuning Primer.