On Thu, May 23, 2002 at 10:17:33AM +0200, Per Andreas Buer wrote: > Hi. > > I've got an database-server with 768MB RAM running > MySQL/InnoDB. There is quite a lot of I/O activity - about > 7Mbytes/s. I am not quite sure why there is so much I/O - maybe the > indexes won't fit into memory? > > Is there a way to tell how innodb is spending available memory? Or > even better - a small guide telling you how to find the appropriate > memory configuration for innodb.
What do your InnoDB settings in /etc/my.cnf look like? Are you using transactions or running in autocommit mode? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 0 days, processed 3,016,914 queries (258/sec. avg) --------------------------------------------------------------------- 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