1
Computing Services Fax: (573) 341-4216
> -Original Message-
> From: Dean Harding [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 2:12 PM
> To: 'Daniel Koch'; [EMAIL PROTECTED]
> Cc: 'Egor Egorov'; Neulinger, Nat
Assume I have a mysql table (myisam most likely) with a few hundred
thousand rows in it. One of the columns indicates success or failure.
99.9% of the rows will have "0" in that column. But a small number will
have 1. I need to be able to fetch those rows quickly, without slowing
everything else do
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
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]
>
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
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
