Hi!
>>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Ken Menzel writes:
>> >From show status (in mysql 4.0.1)
>> | Com_select | 192446 |
>> | Questions | 121881 |
>>
>> Why are there more selects than the total number of questions? Is
>> that correct?
>>
>> There are of course Insert, deletes and other Com_ variables as well.
>> I can provide the whole list!
>>
>> Thanks,
>> Ken
>>
>>
>> -----------------------------------------------------
>> Ken Menzel ICQ# 9325188
>> www.icarz.com [EMAIL PROTECTED]
Sinisa> Hi!
Sinisa> This is a bug that we shall soon sort out ...
Sinisa> You are evidently using our BK tree ...
This come from a wrong merge with between the 3.23 and 4.0 tree.
Here is a fix for this:
(/my/mysql) bk diffs -c sql/sql_parse.cc
===== sql/sql_parse.cc 1.208 vs edited =====
*** /tmp/sql_parse.cc-1.208-15803 Thu Jan 3 00:46:43 2002
--- edited/sql/sql_parse.cc Sat Jan 12 12:45:16 2002
***************
*** 1216,1222 ****
#endif
}
- thread_safe_increment(com_stat[lex->sql_command],&LOCK_thread_count);
/*
Skip if we are in the slave thread, some table rules have been given
and the table list says the query should not be replicated
--- 1216,1221 ----
I will push this to the 4.0 tree later today.
Regards,
Monty
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com
---------------------------------------------------------------------
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
