(RADIATOR) Mysql table format for accounting

[Fabio Erri]

What kind of system do you use to "rotate" the accounting table?


Andy De Petter wrote:
> 
> The insert happens very fast, as we tend to keep the amount of records
> in those tables *very* small.   Records are only temporarily kept there,
> and usually there are not more than a couple of thousand records in
> there.
> 
> a
> 
> > -----Original Message-----
> > From: Fabio Erri [mailto:f.erri at elitel.it]
> > Sent: dinsdag 16 april 2002 20:00
> > To: Andy De Petter
> > Cc: radiator at open.com.au
> > Subject: Re: (RADIATOR) Mysql table format for accounting
> >
> >
> > Doesn't MyIsam table format locking all table during the insert? For
> > accounting this is reccomandable?
> >
> > Andy De Petter wrote:
> > >
> > > Yes. :P
> > >
> > > -a
> > >
> > > > -----Original Message-----
> > > > From: owner-radiator at open.com.au
> > > > [mailto:owner-radiator at open.com.au] On Behalf Of Fabio Erri
> > > > Sent: dinsdag 16 april 2002 18:32
> > > > To: Andy De Petter
> > > > Cc: radiator at open.com.au
> > > > Subject: Re: (RADIATOR) Mysql table format for accounting
> > > >
> > > >
> > > > > MyISAM works fine for us (~700 accounting records/sec
> > during peak)
> > > >
> > > > 700 writing per second? Are you sure?
> > > >
> > > >
> > > >
> > > > >
> > > > > -Andy
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: owner-radiator at open.com.au
> > > > > > [mailto:owner-radiator at open.com.au] On Behalf Of Fabio Erri
> > > > > > Sent: dinsdag 16 april 2002 14:50
> > > > > > To: radiator at open.com.au
> > > > > > Subject: (RADIATOR) Mysql table format for accounting
> > > > > >
> > > > > >
> > > > > > Hello to all,
> > > > > > in your implementation of Radiator with mysql, which mysql
> > > > > > table format
> > > > > > have you choose for accounting one? Standart MyIsam
> > or another.
> > > > > > In your opinion, in case of heavy traffic (about 15
> > > > insert per second)
> > > > > > which is the best choice?
> > > > > >
> > > > > > Thanks.
> > > > > > --
> > > > > > Fabio Erri
> > > > > > Elitel S.p.A.
> > > > > > Tel. 02.44104.652
> > > > > >
> > > > > >
> > > > > > ===
> > > > > > Archive at http://www.open.com.au/archives/radiator/
> > > > > > Announcements on radiator-announce at open.com.au
> > > > > > To unsubscribe, email 'majordomo at open.com.au' with
> > > > > > 'unsubscribe radiator' in the body of the message.
> > > > > >
> > > >
> > > > --
> > > > Fabio Erri
> > > > Elitel S.p.A.
> > > > Tel. 02.44104.652
> > > >
> > > >
> > > > ===
> > > > Archive at http://www.open.com.au/archives/radiator/
> > > > Announcements on radiator-announce at open.com.au
> > > > To unsubscribe, email 'majordomo at open.com.au' with
> > > > 'unsubscribe radiator' in the body of the message.
> > > >
> >
> > --
> > Fabio Erri
> > Elitel S.p.A.
> > Tel. 02.44104.652
> >
> >
> >
> 
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.


-- 
Fabio Erri
Elitel S.p.A.
Tel. 02.44104.652
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.