ED]>
To: "Nicholas Elliott" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 11, 2003 11:29 AM
Subject: Re: InnoDB Performance issues
> In the last episode (Jul 11), Nicholas Elliott said:
> > I've been experimenting with the best way to store a l
Hey all,
I've been experimenting with the best way to store a large (~100GB) of data for
retrieval. Essentially, I'm storing 9 variables for approximately 1,000,000 locations
a day for the last ten years. This can work out at around 4MB a variable a day - but
not all variables are always presen
Remember that this is a binary XOR, not a logical XOR. Mysql does have a
binary XOR operator, the '^' operator. So 'ipAddress1 ^ ipAddress2' is the
binary XOR between the two values. The binary AND is the '&' operator and
the binary OR is the '|'. Just don't confuse them with the AND operator
a
I'd recommend a column of type SET.
Read about it here: http://www.mysql.com/doc/en/SET.html
Basically, if your list of product types is static, this may be a good bet. The SET
type can store any combination of 64 members,
stored as bits.
To list all items int a product type, you might use some
ing Elliott, Nicholas, the Query would _not_ find Bob Smith, even
though 'Smith'>'Elliott', because 'Bob' is not greater that 'Nicholas'.
So, whats the best way to rewrite this? Perhaps a Concat?
SE
Actually, had I read your (second?) email properly, I would've suggested
something slightly different. (I guess, to get a 0, rather than count(*) it
should've been a count(startyear)).
Instead of a LEFT JOIN, which will create NULL rows for any years that don't
have a project, do a straight JOIN u
Sounds to me like you'll need to join for that -- and list all the years you
are interested in in another table. Try this?
SELECT y.Year, count(*) FROM Year as y LEFT JOIN projects ON
project.startyear<=y.Year AND project.endyear>=y.Year GROUP BY y.Year;
This will give you a count of 0 for any y
Hey there,
Does anyone know why a query would take a very long time (>15 minutes) from
my CGI script, yet takes less than a second if I cut-and-paste into my
console?
The query itself amounts to this:
SELECT ((a.PRECIP>(0.00*AVG(b.PRECIP/100, a.DATE
FROM clim_data AS a
LEFT JOIN clim_data as
t was.
Ah well. I figured that out right after I sent out my last email... turns
out 511 didn't work (551 did, of course).
Sorry! =]
Nick Elliott
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: "Nicholas Elliott" <[EMAIL PROTECTED]>
Cc: "
sword.
Nick Elliott
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: "Nicholas Elliott" <[EMAIL PROTECTED]>; "Benjamin Pflugmann"
<[EMAIL PROTECTED]>; "Brent Bailey"
<[EMAIL PROTECTED]>
Cc: "Octavian Rasnita&quo
Does the CGI-script need to be world-readable, or just world-executable?
All my perl CGI scripts are set up that way, so while anyone can run it,
only I can read the source code
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Brent Bailey" <[EMAIL PROTECTED]>
C
Alternatively, use the IF() function --
SELECT IF(captain=0, "C", "") from stats where captain > 0 and number = '23'
group by number;
Or something similar.
Nick
- Original Message -
From: "Insanely Great" <[EMAIL PROTECTED]>
To: "Alex Behrens" <[EMAIL PROTECTED]>; "MYSQL" <[EMAIL PROTE
So essentially, you want to put an index on part of the column, and not the
whole column, right? As in, an index on just the date part, and not the time
part. (Or both -- it seems like you want it to do both at the same time).
Much like you can with a char column -- put a char on the first 2 letter
Wouldn't you need if
(!mysql_query("INSERT INTO table(field) VALUES('$var')")) die("Always die");
?? (Put the $var in single quotes, as it's a text field)
Nick Elliott
- Original Message -
From: "Erumba Gotha Henri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 19,
Hey folks,
I've looked around, but haven't seen anything similar to _quite_ the problem
I have. The symptoms are thus: memory usage for each mysqld process in top
creeps up to around 13%, 274MB, and stays there, no matter what I set my
config to.
79 processes: 76 sleeping, 3 running, 0 zombie,
15 matches
Mail list logo
