RE: suggestions for implementing heavily used log tables with nightly delete

2001-03-19 Thread Neulinger, Nathan R.
ay to go as well... I might give that a shot. -- Nathan > -Original Message- > From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 19, 2001 4:01 PM > To: Neulinger, Nathan R. > Cc: '[EMAIL PROTECTED]' > Subject: Re: suggestions for implemen

RE: suggestions for implementing heavily used log tables with nightly delete

2001-03-19 Thread Neulinger, Nathan R.
ywhere from 3-5%. Jeremy also mentioned trying out innobase tables... I might give them a shot as well. -- Nathan > -Original Message- > From: Jens Vonderheide [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 19, 2001 3:49 PM > To: Neulinger, Nathan R.; [EMAIL PROTECTED] >

suggestions for implementing heavily used log tables with nightly delete

2001-03-19 Thread Neulinger, Nathan R.
Got any suggestions on how these could be implemented? particular table types/setups/etc? I basically have a situation where 300,000+ rows are being inserted into a log table daily, and also needing to be cleared out based on a tstamp. What I've found is that the inserts work fantastic, but when

buglet in my.cnf parsing/handling

2001-03-05 Thread Neulinger, Nathan R.
I consider this a bug... other might not. I have: .my.cnf: --- [client] password host = mysql.rollanet.org [mysql] verbose --- If I type "mysql" by itself, everything works fine. But if I try to use "-ppassword" on any tool, it fails. I think that "password" in the config shouldn't tri