(RADIATOR) Mysql table format for accounting

[Andy De Petter]

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.