Re: Logging Data: Should I use MyIsam or InnoDB?

2005-01-19 Thread Martijn Tonies
> > > > I have a curious issue here, maybe someone can help. > > > > > > > > I have a single process that inserts data into tables that contain > > > > purely logging information. This table is then searched by our Care > > > > department to troubleshoot issues. I am looking for the best way to

Re: Logging Data: Should I use MyIsam or InnoDB?

2005-01-19 Thread SGreen
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 01/19/2005 03:33:32 AM: > Hello Jeremy, > > > > I have a curious issue here, maybe someone can help. > > > > > > I have a single process that inserts data into tables that contain > > > purely logging information. This table is then searched by our C

Re: Logging Data: Should I use MyIsam or InnoDB?

2005-01-19 Thread Javier Armendáriz
Martijn Tonies wrote: Hello Jeremy, I have a curious issue here, maybe someone can help. I have a single process that inserts data into tables that contain purely logging information. This table is then searched by our Care department to troubleshoot issues. I am looking for the best way to st

Re: Logging Data: Should I use MyIsam or InnoDB?

2005-01-19 Thread Martijn Tonies
Hello Jeremy, > > I have a curious issue here, maybe someone can help. > > > > I have a single process that inserts data into tables that contain > > purely logging information. This table is then searched by our Care > > department to troubleshoot issues. I am looking for the best way to > > st

RE: Logging Data: Should I use MyIsam or InnoDB?

2005-01-18 Thread Thomas Lekai
: Tuesday, January 18, 2005 3:30 PM To: Thomas Lekai Cc: mysql@lists.mysql.com Subject: Re: Logging Data: Should I use MyIsam or InnoDB? Hi Thomas, > Thanks, this is what I was originally thinking of, but how I am > getting rid of the data in log_view_today? OR, are you saying that > log_view

Re: Logging Data: Should I use MyIsam or InnoDB?

2005-01-18 Thread Jeremy Cole
Hi Thomas, Thanks, this is what I was originally thinking of, but how I am getting rid of the data in log_view_today? OR, are you saying that log_view_today is a merge table for only the current day? That table def is defined every night? Then I would go about dropping everything in whatever fas

RE: Logging Data: Should I use MyIsam or InnoDB?

2005-01-18 Thread Thomas Lekai
omas Lekai Cc: mysql@lists.mysql.com Subject: Re: Logging Data: Should I use MyIsam or InnoDB? Hi Thomas, > I have a curious issue here, maybe someone can help. > > I have a single process that inserts data into tables that contain > purely logging information. This table is then sear

Re: Logging Data: Should I use MyIsam or InnoDB?

2005-01-18 Thread Jeremy Cole
Hi Thomas, I have a curious issue here, maybe someone can help. I have a single process that inserts data into tables that contain purely logging information. This table is then searched by our Care department to troubleshoot issues. I am looking for the best way to store this data, and the struc