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
That did it -- show table status lists the upper limit as approx 1TB now =].
I'm still curious about the InnoDB issues, but now at least I can avoid it
and work with the original plan!
Thanks,
Nick Elliott
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Nicholas Elliott
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
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
FROM names
WHERE CONCAT(last,first,id)CONCAT('$previouslast', '$previousfirst',
'$previousid')
ORDER BY last, first, id
LIMIT 1
I think that would work, feel free to correct me!
Nicholas Elliott
-
Before posting
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
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
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 b
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]
Cc:
-
From: Mark [EMAIL PROTECTED]
To: Nicholas Elliott [EMAIL PROTECTED]; Benjamin Pflugmann
[EMAIL PROTECTED]; Brent Bailey
[EMAIL PROTECTED]
Cc: Octavian Rasnita [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 10:56 AM
Subject: Re: Hiding the password
- Original Message
it 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: Octavian Rasnita [EMAIL PROTECTED]; [EMAIL PROTECTED
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 PROTECTED]
Sent:
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
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, 2002
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
