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:[EMAIL PROTECTED]] > > Sent: dinsdag 16 april 2002 20:00 > > To: Andy De Petter > > Cc: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > > > [mailto:[EMAIL PROTECTED]] On Behalf Of Fabio Erri > > > > Sent: dinsdag 16 april 2002 18:32 > > > > To: Andy De Petter > > > > Cc: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] > > > > > > [mailto:[EMAIL PROTECTED]] On Behalf Of Fabio Erri > > > > > > Sent: dinsdag 16 april 2002 14:50 > > > > > > To: [EMAIL PROTECTED] > > > > > > 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 [EMAIL PROTECTED] > > > > > > To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] > > > > To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.