On Thu, 2004-12-09 at 10:08 -0600, gerald_clark wrote: > > Patrick Marquetecken wrote: > > >Hi, > > > >I have 3 snort sensors logging to a central mySQL database after two weeks > >the size of the database is about 3.3GB and the machine is getting slow, as > >i'm not used to be working with mySQL is my question how far can i go before > >the machine stop responding ? > > > >HP Pentium4 - 2.2mhz - 512 mb, 99% used and no swap, HD of 40GB. > > > > > > > I f that is 99% disk used, you are already dead. > That is why it is slow. > You have no room to do anything. >
To be fair Gerald, I think he means he's out of memory (correct me if I'm wrong here Pat), but you simply *must* allow the machine work space to work things out. Adding some swap will actually help. How active is the server? Darryl Waterhouse --- Software Development Manager Orbis Monitoring Services t: +44 151 357 7800 m: +44 7876 390212 e: [EMAIL PROTECTED] Suite 3, Sycamore House, Lloyd Drive, Ellesmere Port, Cheshire, CH65 9HQ
