I know that www.yahoo.com uses it somewhere... but I can't remember where I read that
(probably on this list a while ago)
- Original Message -
From: "Anthony R. J. Ball" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 12:48 PM
Subject: Need examples of companies
PID USER PRI NI SIZE RSS SHARE LC STAT %CPU %MEM TIME
671 root 90 31292 30M 15960S 0.0 3.0
0:11
Above is a SMALL snip of data from the TOP program in linux. If I am reading this
correctly than each child is sharing 1.5M or RAM
and u
Does anybody know if this amount of memory usage is normal? (taken from *top*)
PID USER PRI NI SIZE SWAP RSS SHARE LC STAT %CPU %MEM TIME COMMAND
677 root 90 19228 0 18M 15801S 0.0
2.1 0:07 mysqld
679 root 9
nal Message -
From: "Noor Dawod" <[EMAIL PROTECTED]>
To: "Jason Terry" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 9:23 AM
Subject: RE: TEXT's are giving us headaches!
> Hi
>
> Hmm, this seems to me like redundant
A mistake I made for a long time with MATCH AGAINST is to not include it in the WHERE
clause
eg I did
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq
instead of
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq WHERE MATCH Q,A AGAINST ("This")
The latter will give much better perfo
Cool, I like this info. (especially key_buffer_size stuff)
However, I was running my numbers against what you said would be good. And this is
what I came up with...
The Key_reads/Key_read_request = 0.002 (much less than you suggest so that is good...
I think)
However this one worries me a b
Just a side note... you can do JOINs on tables from different databases on the same
mySQL server
eg
SELECT t1.UserName FROM db1.table AS t1, db2.anothertable AS t2 WHERE t1.UserName =
t2.UserName
As for database layout... I would go with what makes the most sense... If having 84
tables in o
Anybody have a quick way to make a CSV dump of a SELECT?
If MySQL can't do it directly is there an easy way in PERL?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I have a need for a SELECT query...
I don't really want any of the data from the select...
Rather I need the size of the data
basically I need
SELECT sum(length(*)) FROM MyDB WHERE MyDB.Something LIKE 'this%'
-
Before posting
