RE: BillMax questions -- Slow Account Load Issues/Removing ClosedServices

[Chris Snyder <casnyder@pennswoods.net>]

Personally I'd move the service to an account/user specifically intended
to hold dead services.

Intermittently, when you want to truly prune them, you can run
billmax-admin delete (read the man/doc page for options) on the holding
account.  You probably want to make sure your backups are good, because
otherwise billmax-admin delete is forever.

billmax-admin delete will pretty much delete everything associated with
what you delete, and aside from a healthy backup, there is no reversal.
There is a dry run mode though, to see what it will do.

I think you can delete individual services too, but I can never trust
humans to really know what they want.  To that end I find it safer to
set records to the side for at least a few days.  That way if someone
barks about missing data, it is easier to recover.


On Fri, 2007-06-29 at 11:40 -0700, Paul Krensky wrote:
> Chris/Ted thanks for the info, probably need to do both (prune closed services and upgrade hardware).
> 
> Question, to permanently remove a closed service from an account what is the recommended method?
> 
> Thanks,
> 
> Paul
> 
> Native Hosting, Inc.
> 
> 
> 
> -----Original Message-----
> From: "Internet Partners, Inc. Tech Support" <support@ipinc.net>
> Sent: Fri, June 29, 2007 11:31 am
> To: Paul Krensky <paul@nativehosting.com>, questions@billmax.com
> Subject: RE: BillMax questions -- Slow Account Load Issues
> 
> 
> You can try playing with the mysql settings, (ie: my.conf I think) there's
> websites that are devoted to tuning mysql for best performance.
> 
> But, in the last analysis, nothing speeds up a database like big
> expensive fast disks, lots of memory, and a fast CPU
> 
> We are running a dual 500Mhz Xeon with 500MB of ram right now and a raid
> array.  But,
> we do not take call accounting records so our datacall table is empty.
> 
> We previously had a 200Mhz uniprocessor Pentium Pro with 256Mb of
> ram.
> 
> When I moved the billmax server, reports that took an hour took a
> few minutes to run.
> 
> Ted
> 
> >-----Original Message-----
> >From: owner-questions@billmax.com [mailto:owner-questions@billmax.com]On
> >Behalf Of Paul Krensky
> >Sent: Thursday, June 28, 2007 2:52 PM
> >To: questions@billmax.com
> >Subject: BillMax questions -- Slow Account Load Issues
> >
> >
> >
> >Good day List,
> >
> >Wondering if anyone else has seen performance issues (very slow 
> >loads) for accounts with a longer list of services (300 or so open 
> >plus half as many closed). The time it takes to load seems to be 
> >increasing as the list of services increases. 
> >
> >Loading the main account page and trans void pages are taking 
> >close to a minute now to load. Main user (which has most of the 
> >services) interestingly doesn't take a long time to load (few seconds). 
> >
> >Other accounts with less services and all reports load quickly.
> >
> >Any suggestions on how to eliminate or at least reduce this 
> >problem would be appreciated. 
> >
> >Thanks,
> >
> >Paul
> >
> >Native Hosting, Inc.
> >
> >-------------------------------------------------------------------
> >----------
> >To unsubscribe from the "BillMax Questions" mailing list, please
> >send a message to "majordomo@billmax.com" with "unsubscribe questions"
> >in the message body. The message must be sent from the exact email
> >address on the list.
> >
> 
> 
> -----------------------------------------------------------------------------
> To unsubscribe from the "BillMax Questions" mailing list, please
> send a message to "majordomo@billmax.com" with "unsubscribe questions"
> in the message body. The message must be sent from the exact email
> address on the list.

-----------------------------------------------------------------------------
To unsubscribe from the "BillMax Questions" mailing list, please
send a message to "majordomo@billmax.com" with "unsubscribe questions"
in the message body. The message must be sent from the exact email
address on the list.