hi All,
Last month, one of the our server got stuck but We could n't find the
reason. Here I have attached the OS(Red Hat Enterprise Linux AS relese 4)
message log. I think issue may be in MySQL.
We are using MySQL Server version: 5.1.12-beta MySQL Community Server (GPL)
So if you can please send
Mariella Petrini wrote:
...MySQL 6.0.2 with Falcon on Linux with Debian 4.
I have compiled the source code for 64 bit executable.
The system is an Intel 2 cpus 4 cores each, with 8 GB
of RAM.
After having created
approximately 8,500 empty tables mysqld server was
still alive, you could connect
Mathieu Bruneau wrote:
I never tried the falcon engine, but could it be that mysql is running
out of file descriptor ?
That's less likely with Falcon than with engines that put each
table and index in its own file. By default, Falcon tables share
a single tablespace.
Regards,
Ann
--
My
How can I send a query that retrieves only the first 'N' rows that match a
condition? As far as I know you must call mysql_fetch_row() until the last
row has been processed or the resources allocated won't be free.
Am creating a program in PHP that should retrieve only 'N' records each
time a
qu
Look up the LIMIT clause of SELECT statement, also ASCENDING/DESCENDING
- depending on how you want it. Remember LIMIT can take a number and an
offset.
Terry
- Original Message -
> *From:* Renito 73 <[EMAIL PROTECTED]>
> *To:* mysql@lists.mysql.com
> *Date:* Sun, 9 Sep 2007 10:05:52 -0
Hello
How can I send a query that retrieves only the first 'N' rows that match a
condition? As far as I know you must call mysql_fetch_row() until the last
row has been processed or the resources allocated won't be free.
Am creating a program in PHP that should retrieve only 'N' records each ti
