Hi,
In MySQL, I do:
mysql> SELECT * FROM my_table WHERE myconditions LIMIT
10;
It retrieves 10 rows of data that meets 'myconditions'
from my_table. Is it possible to get the total row
count that meets 'myconditions' without another query?
Thanks.
Dexin
n receiving the status
> back in Europe...times 5000 records.
>
> Hope this helps,
>
> Jack
>
> -Original Message-
> From: William Wang [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 1:12 PM
> To: [EMAIL PROTECTED]
> Subject: many updates really slo
Hi everyone,
Please help.
I have MySQL server running on host A in US and I am
using it on host B in Europe. Every query takes about
0.3 seconds.
Now I want to do update db with 5000 updates. So I put
all the "UPDATES" commands in a file cmd.sql and do:
mysql -hA < cmd.sql
and it takes 30 MINU
To: William Wang; [EMAIL PROTECTED]
Subject: Re: very slow mysql server, help please
On Thursday 06 Mar 2003 3:11 am, William Wang wrote:
> Question 1: Does sleeping processes slow down database server?
Nope, I have had many a discussion whats best to use, pcconect or
normall
connect but have
Hi All:
I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql
database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load
balancer. All those servers are FreeBSD. For some reason, mysql server can
be easily max out without many users. Also there are many processes in
slee
Hi All:
I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql
database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load
balancer. All those servers are FreeBSD. For some reason, mysql server can
be easily max out without many users. Also there are many processes in sl