Hi Steve, On Tue, Jan 04, 2005 at 05:28:23PM -0000, Steve Wright wrote: > > As a n00b to pmacct, I am trying to get my Netflow output into MySQL. > However, my MySQL server has just died under the load put upon it (about > 40000 rows in 30 minutes). > > Is it expected that MySQL will not be able to cope with this volume without > a suitable 'beefy' hardware configuration?
40,000 tuples isn't a crazy amount of data. My suggestion is to check your indexes. Use EXPLAIN ANALYZE <sql query> to see if the INSERT/UDPATEs are actually using the index... What sort of hardware do you have now? Cheers, Wim
