MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: MySQL usage profiling?
Posted by: STARYNKEVITCH Basile
Date: November 21, 2004 02:37AM

Deomid Ryabkov wrote:
> the question is simple: how do i know who (of more
> than 4000 users) uses my database server the
> most?
>
> the server is a backend for our webhosting
> services, which means that i know absolutely
> nothing about applications our users run.
>
> server is becoming quite busy, cpu utilization is
> starting to reach 100% on regular basis.

Maybe my suggestion is too simple, but did you try to issue a "SHOW PROCESSLIST;" MySQL query, or to run the 'mysqladmin processlist' command when your MySQL server is quite loaded?

--
Basile STARYNKEVITCH :::: http://starynkevitch.net/Basile/

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL usage profiling?
Deomid Ryabkov
November 20, 2004 05:41PM
Re: MySQL usage profiling?
Erik Petersen
November 21, 2004 02:35AM
Re: MySQL usage profiling?
Deomid Ryabkov
November 21, 2004 04:30AM
Re: MySQL usage profiling?
Deomid Ryabkov
November 29, 2004 06:36AM
Re: MySQL usage profiling?
STARYNKEVITCH Basile
November 21, 2004 02:37AM
Re: MySQL usage profiling?
Deomid Ryabkov
November 21, 2004 04:04AM
Re: MySQL usage profiling?
Mike Hillyer
November 29, 2004 10:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.