[rt-users] User abusing the mysql

[Asif Iqbal]

Hi

Is there way to find out which user abusing mysql? Once in a while I
have user who runs a query which causes the mysql to take over about
45% of cpu and at the same time slow down mysql queries for the rest.

I am using RT 3.4.6 + Perl 5.8.6 + MySQL 4.0.24 on Solaris 10 + V20z
(4G / 2 1.8Ghz AMD Opteron)

I think all the tables are InnoDB type

Here is the innodb part of my conf file

innodb_data_home_dir = /export/home/ibdata
innodb_data_file_path = ibdata1:2000M;ibdata2:50M:autoextend
innodb_log_group_home_dir = /export/home/ibdata
innodb_log_arch_dir = /export/home/ibdata
innodb_log_files_in_group = 2
innodb_buffer_pool_size = 1G
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 250M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
"..there are two kinds of people: those who work and those who take the credit...try
 to be in the first group;...less competition there."  - Indira Gandhi