Re: how to tell if innodb has enough memory

2002-05-29 Thread Jeremy Zawodny
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? > > I

how to tell if innodb has enough memory

2002-05-23 Thread Per Andreas Buer
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