Hi Dennis, On Tue, Aug 30, 2011 at 01:13:14PM +0200, Dennis Koster wrote:
> After this change, I haven't seen any duplicate entries. > But I'm seeing some weird locking issues. > > pmacct is trying to lock the table (LOCK TABLES `acct_v7` WRITE). > And this is done 16 times. > > Also the table lock is preventing SELECTs while the table is being updated. OK, one problem gone and it appears the sql_locking_style is not the source of the overall slowness (which in turn is the bottom line of having 16 LOCKs - IMHO). Can you check the process list, do you see roughly the same amount of LOCKs in MySQL and pmacct writer processes? Also, can you check CPU and memory wise how the box is doing? Perhaps the monthly SQL table is getting big, many - and too frequent - index updates to do, the MySQL is eating it all? Cheers, Paolo _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
