Re: Mysql question and sql request. Are they the same?

[Benjamin Pflugmann <benjamin-mysql@xxxxxxxxxxxx>]

Hi.

On Tue, Nov 20, 2001 at 02:23:31PM +0100, rafael@xxxxxxxxxx wrote:
> 
> Hei
> 
> I asked this question sometime ago but I did not get any answer :-( 

I think the problem is that people are not sure what you are referring
to (includes me).

> and I can not find any explanation of this in the mysql manual.
> 
> Could anybody explain me the different between a question and a
> sql-request in mysql?.
> 
> F.example:
> 
> If I send a sql-request to mysql:
> select * from Table where column_A=1 and column_B=2 order by column_C;
> 
> num.sql_request = 1 and num.questions = 1
> 
> Is this true? Can I send 1 sql_request that generate many questions?
> I am asking this because I am getting around 17.000.000 QUESTIONS a day in
> my DB (show status), but I am sure we don't send 17 mill sql-request to
> mysql.

I assume the questions in the "status" of the MySql server refers to
requests from clients. E.g. for me, with one db, questions is almost
exactly the double of the number of (SQL) queries I issue. According
to http://www.mysql.com/doc/S/H/SHOW_STATUS.html, questions refers to
queries, which seems wrong.

For my situation, I presume that the client library silently issues
some query after opening the connection (like choosing the default
database to work with).

Bye,

	Benjamin.

-- 
benjamin-mysql@xxxxxxxxxxxx

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92401@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php