iqbala-rt-users at qwestip
May 3, 2006, 10:46 AM
Post #1 of 2
(402 views)
Permalink
|
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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sales [at] bestpractical
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
|
