Hi, I am running 3.23.49 and had a quick question I hope someone can answer.
70% of the time my sql server is doing just fine. I have 4 GIGs of memory,
and a 1.33 Ghz processor.I am running Redhat 7.3 with a 2.4.19 kernel.
70% of the time my server is fine, the other 30% it is 100%
() operation
works? I can't find a specification out there for it.
Thanks,
Matt Heaton
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
I can't seem to find a specificatoin on order by rand() and have a question.
Lets say a table has 10,000 rows in it, and I want to get one row that
matches
so I do a
select * from table where number=1 order by rand() limit 1;
What if 100 rows match? Does it first get all 100 rows and then