A short time ago, at a computer terminal far, far away, Paolo Lucente wrote: > 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?
The DB Writer processes are the same amount. MySQL is doing about 90% cpu and a little bit of memory hoghing. What else can I provide for information? -- Met vriendelijke groet, Dennis Koster "I take no responsibility if it formats your server, defrosts your fridge, or touches your cat inappropriately." _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
