On Wed 12 Jul 2006 01:36, Jon Hall wrote: > Hi, > > Is there a way to remove the un-needed fields in a mysql database? > > I am not using at least half of them and wanted to remove that added > storage/complexity from the equation. > > If I simply delete the fields from the schemas, my inserts and updates from > nfacctd error.
You may delete rows from the schema as long as you don't use those fields in an aggregate clause and if you include "sql_optimize_clauses: true" in your config file. Cheers -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
pgpcpTbYkjf2L.pgp
Description: PGP signature
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
