hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : How to find out which account is making the biggest load on mysql?
Reply

Forum Jump

How to find out which account is making the biggest load on mysql?

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 04-26-2008, 02:00 AM
Hawi Hawi is offline
Newbie
 
Join Date: Apr 2006
Posts: 17

How to find out which account is making the biggest load on mysql?


Hi
My Server Is down nearly every day in the last three days

I think one of my clients is sending emails from his forum to his members.
How can I know who is he, And most important can I stop him from emailing his members?

Also,
How can I find out which account is making the biggest load on MySQL?


Thank you All



Sponsored Links
  #2  
Old 04-26-2008, 04:40 AM
racked_solutions racked_solutions is offline
Temporarily Suspended
 
Join Date: Apr 2008
Location: Bury St Edmunds
Posts: 158
If you are using Cpanel/WHM if you click server status from the main home/index page then cpu/memory usage it tells you how much load accounts are using, if its high it will be either yellow or red.

I dont think you should stop him from emailing his members this is a important function of a forum and as a webhost this is a resource your expected to offer, but i would suspend his account untill you can find a sutible resolution, most webhosts have a limit to how many emails you can send a hour, you should implement this into your hosting service and remeber to include it into the TOS, or you could ask him to throttle the number of emails sent out most forum scripts can do this now.

There is a option to limit the number of emails a account can send out per hour in whm. i would suggest reading through the cPanel manual if this is your control panel

cpanel.net/docs/cpanel/

If not i recomend you look at the user manual related to your control panel or hire a sysadmin to do some config adjustments to your server if your not comfortable doing it

  #3  
Old 04-26-2008, 03:07 PM
karem karem is offline
WHT Addict
 
Join Date: Aug 2005
Location: Egypt
Posts: 108
watch mysqladmin process this show all process to every data

and u can see emails log by tail -f /var/log/exim_mainlog

Regards

__________________
GNU/Linux system Engineer
Contact Me: 00201003338749


Sponsored Links
  #4  
Old 04-27-2008, 08:18 AM
activelobby4u activelobby4u is offline
Your support partner
 
Join Date: Apr 2005
Location: Queen of Arabian Sea
Posts: 2,408
you can also use the tool mytop and also log slow queries to make sure you track teh abuser

__________________
Sam
Supportlobby.com - Specialist in Windows Server Management
Spiralbean.com - Custom Software Development

  #5  
Old 04-27-2008, 07:56 PM
karem karem is offline
WHT Addict
 
Join Date: Aug 2005
Location: Egypt
Posts: 108
tool mytop = watch mysqladmin process

__________________
GNU/Linux system Engineer
Contact Me: 00201003338749


Reply

Related posts from TheWhir.com
Title Type Date Posted
How Social Engineering Attacks Target Web Hosting Support Staff Web Hosting News 2014-03-20 12:16:14
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2013-08-19 12:25:00
GoGrid Launches Dynamic Load Balancer Service Built for Cloud Web Hosting News 2013-01-29 10:07:53


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?