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: [EMAIL PROTECTED] 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
