Hi. On Tue, Nov 20, 2001 at 02:23:31PM +0100, [EMAIL PROTECTED] 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. -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
