[mythtv-users] MySQL Status Variable Select_full_join Is Not 0

[Wade Maxfield]

Drew Tomlinson wrote:
> Bruce Markey wrote:
>> Drew Tomlinson wrote:
>>   
>>> I've been attempting to educate myself and do a little tuning to get the
>>> most out of my underpowered system.  In checking MySQL status variables
>>> using MySQL Administrator, I came across this:
>>>     
>> Although both project names begin with "My*" mythtv.org is
>> not the home for MySQL Administrator. Your best course to
>> a resolution would be using the resources at www.mysql.org .
>>
>> --  bjm
> 
> So are you confirming that MySQL Administrator is a "liar" and the 
> Select_full_join status variable is not an issue?
> 
> I agree that I'd find much better MySQL support on the MySQL lists
> 
> Cheers,
> 
> Drew
> 

I'm not an MySQL expert, but try these 2 queries:

show status LIKE 'select_full_join';

show /*! global */ status LIKE 'select_full_join';

They should give you 2 different results. One should be closer to the
missing number. What you do from here, is up to you.

  - Wade