You are probably a little short of RAM for that size db. Lack of swap may bite you as well. How big are your keys? Pat...
----- Original Message ----- From: "mos" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 10, 2004 10:48 AM Subject: Re: MYSQL is getting slow > At 09:49 AM 12/9/2004, 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. > > > >TIA > >Patrick > > > > Patrick, > Try running "Analyze Table" to get MySql to rebalance the key > distribution. See http://dev.mysql.com/doc/mysql/en/ANALYZE_TABLE.html Make > sure you have plenty of disk space and time before running it. > > Mike > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
