Hi there, In the Mysql query log, is there any way of logging for each query the number of disk I/Os, amount of CPU time spent processing and network data sent? What about a way to ensure that each "user" and/or "database" gets a fair turn at disk I/O? Or even getting mysql to switch to a different userid after authentication so that I can approach the problem at the kernel level? I've got a mysql server with about 300 active databases on it and I'm having difficulty tracking down recent performance problems. I've got lots of people doing lots of complex queries, but finding out which ones are hitting the database the hardest is not simple. Any ideas? Has anyone else run into this before? -- Sam Vilain, [EMAIL PROTECTED] Easyspace: an accredited ICANN GPG: http://sam.vilain.net/sam.asc registrar & web hosting company 7D74 2A09 B2D3 C30F F78E Have your domain run by techies 278A A425 30A9 05B5 2F13 with a clue. www.easyspace.com --------------------------------------------------------------------- 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
