[Buildroot] [PATCH] package/systemd: needs glibc

Nicolas Cavallari Nicolas.Cavallari at green-communications.fr
Tue Dec 4 11:17:37 UTC 2018


On 04/12/2018 12:02, Arnout Vandecappelle wrote:
> On 04/12/2018 11:32, Nicolas Cavallari wrote:
>> Adding an index on result_id helps:
>>
>> MariaDB [brautobuild]> create index resid on symbol_per_result (result_id);
>>
>> MariaDB [brautobuild]> select A.result_id from symbol_per_result A,
>> symbol_per_result B where A.result_id = B.result_id and A.symbol_id = (select id
>> from config_symbol where name = "BR2_INIT_SYSTEMD" and value = "y") and
>> B.symbol_id = (select id from config_symbol where name =
>> "BR2_TOOLCHAIN_USES_UCLIBC" and value = "y");
>> Empty set (9.55 sec)
> 
>  Maybe it would be even better to make (result_id, symbol_id) the primary key of
> symbol_per_result? Or do I misunderstand the implications of primary key?

i was a bit confused about the various id in symbol_per_result.  If
symbol_per_result.id is unused, then yes, remove it and make (result_id,
symbol_id) the primary key.

(i'm assuming that mysql can use an (a,b) index to search for a, it should be
the case now in 2018)



More information about the buildroot mailing list