-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi,
Ive setup nfacctd collector collecting data from 2 linux routers. The data is exported with fprobe. I am keeping history and nfacctd is exporting the collected data to mysql. The problem is as follows: Mysql is becoming quite slow and that's with a low number of rows ~400K. It is especially bad when exploring the data with bwstat. I tend to think that the problem is the mysql indexes. Any suggestions on which and what indexes to set will be greatly appreciated. Also a suggestion for another frontend for data exploration will be nice. - -- If everything fails, use a hammer Vladimir Vitkov <vvitkov [at] gmail [dot] com pgp KeyID: 0x9215F7F7 Fingerprint: DDC0 DC86 AE97 D9EE F654 7EDC 5F03 309C 9215 F7F7 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGPZ0yXwMwnJIV9/cRAuQOAJ9SUxC+AlKoqy7VqzxEg6GE6chAMwCfQ4Qj NEAsD3LdA8rV9R3oV8mZjA8= =7/oB -----END PGP SIGNATURE----- _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
