analyzing mysql general query log

[Pete Mocat]

Hello,

Can anyone recommend a script to analyze a mysql server general query log.

My goal is to determine which users are putting the most load on the server.

Any other methods to achieve this same goal would be appreciated as well.

Thank you.

_
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

redhat 6.1 / 6.2

[Pete Mocat]

Hi,

In regard to my previous message - I would also be interested if anyone is 
aware of a general source for MySQL rpm's built for 6.1/6.2. I would prefer 
to build my own but if I do not succeed I would also be interested in anyone 
else's. I assume that there are no MySQL supplied rpm's for 6.1 / 6.2 (old 
libc)

Thanks again!




_
MSN 8: advanced junk mail protection and 3 months FREE*. 
http://join.msn.com/?page=features/junkmailxAPID=42PS=47575PI=7324DI=7474SU= 
http://www.hotmail.msn.com/cgi-bin/getmsgHL=1216hotmailtaglines_advancedjmf_3mf


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

rpm source build problems

[Pete Mocat]

Hi,

I hope this message is not out of place, but I have not been able to solve 
this problem. I need to rebuild the latest MySQL rpm's for use
on some RedHat 6.1/6.2 machines and have been having quite a few problems.

I've made sure I have :

autoconf-2.52
automake-1.5
libtool-1.4.3

which I believe another person said was necassary in a previous thread.

I also have replaced redhat's egcs compiler with gcc 2.95 (rebuilt from 
yellowdog source rpms as per another thread).

When running

rpm --rebuild MySQL-3.23.54a-1.src.rpm

I get:

+ mv Docs/manual.ps.save Docs/manual.ps
+ automake
aclocal.m4: 1272: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL'
aclocal.m4: 1273: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL'
aclocal.m4: 1379: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL'
libmysql_r/Makefile.am:26: library used but `LIBTOOL' not defined in 
`configure.in'
error: Bad exit status from /var/tmp/rpm-tmp.70620 (%build)


RPM build errors:
   Bad exit status from /var/tmp/rpm-tmp.70620 (%build)


any ideas?

Thanks so much!






_
The new MSN 8: smart spam protection and 3 months FREE*.  
http://join.msn.com/?page=features/junkmailxAPID=42PS=47575PI=7324DI=7474SU= 
http://www.hotmail.msn.com/cgi-bin/getmsgHL=1216hotmailtaglines_smartspamprotection_3mf


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php