Re: (RADIATOR) MySQL accounting massively slows responses

2003-03-31 Thread Hugh Irvine
Hello Matthew - It sounds like your accounting table is much too large, causing SQL inserts to take a very long time. In general you should keep the accounting table as small as possible by archiving the older data. You should be able to see what is happening by looking at the database logs. As

(RADIATOR) MySQL accounting massively slows responses

2003-03-31 Thread Matthew Trout
Title: MySQL accounting massively slows responses We intended to use MySQL for both session databases, IP allocation and accounting; the former two seem to work fine, however as soon as we put accounting onto SQL the Accounting-Response packets take several seconds to be sent. The MySQL connec