Glad to here it. I hadn't tried it myself, but I heard that it helped under
some circumstances. You'll take a small performance hit for the case where
you're dealing with lots of small files I've heard.
I haven't tried XFS.
I Just installed RH7.2 on a box last weekend using the ext3 filesystem.
> Any thoughts, besides switching to Linux?
Linux beeps also, as evidenced by this intentionally incorrect query (had to
get "query" in there so the message wouldn't bounce!):
mysql> select * from junk;
ERROR 1146: Table 'SBS4_run_db_25_10_2001__16hr8min36sec.junk' doesn't exist
(and a beep)
--
>> I'm not sure what the problem with this is? The first (unique) column is
>> independent of the second (random) column. If the random column has
>> duplicate values, it just means that the corrosponding first column
values
>> will be adjacent in the sorted table.
>If you're really depending o
>I can see one problem with this, which is that in the case that you
>get two identical number in the second column their order will be
>strongly dependent on the values in the first column.
I'm not sure what the problem with this is? The first (unique) column is
independent of the second (rand
How about this:
Create a table with two columns. The first is autoincrement, so guarenteed
unique. The second is random (but not neccesarily unique).
Now sort this table by the second column.
The first column, read in order, should now suit your needs, but I don't
think you can do inserts auto
Is there any function/command/neat query that you can use to get a histogram
of a column's values? I didn't find anything in the manual or the DuBois
book.
If not, can anybody comment on how difficult this might be to implement as a
user defined function? I haven't looked into this to much yet,
do not have a target match in "tracked"
- tracked.window would = NULL in those cases.
--Greg Johnson
-Original Message-----
From: George Eric R Contr AFSPC/CVYZ
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 11:50 AM
I'm not getting the behavior I expect from this select.
SELECT available.target, tracked.sensor
FROM available LEFT JOIN tracked ON available.target=tracked.target
WHERE available.window=137 AND tracked.window=137 AND available.sensor=8;
Now, I know for this window, that there are 25 records for
Oops,
Yea, that's pretty obvious now that you pointed it out!
Thanks
Eric
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 1:11 PM
To: George Eric R Contr AFSPC/CVYZ; mysql
Subject: Re: How to Dump only Data
Yes, the mysql proce
I just tried this, but I get the result:
mysql> SELECT * FROM ga_perf INTO OUTFILE "/home/georgee/ga_perf.out";
ERROR 1: Can't create/write to file '/home/georgee/ga_perf.out' (Errcode:
13)
my username (georgee) is fully priveledged, and /home/georgee is my home
directory, so I certainly have pe
CTED]]
Sent: Tuesday, September 25, 2001 1:12 PM
To: George Eric R Contr AFSPC/CVYZ; [EMAIL PROTECTED]
Subject: RE: Inserting Numeric Data with the C API
I searched pretty thoroughly for a way to access mysql data in their native
field types (e.g. an int field I wouldn't have to use atoi()/it
Hi,
Is there anyway to do this other then copying a representation of the data
into the query string?
This just seems pretty inneffiecient (making an extra copy of the data) &
error prone (getting the representation right when you copy it to the
string).
Thanks
Eric
--
12 matches
Mail list logo