List:Commits« Previous MessageNext Message »
From:Guilhem Bichot Date:April 7 2009 3:15pm
Subject:Re: [Fwd: Review of the performance schema instrumentation interface
View as plain text  
Hello,

Marc Alff a écrit, Le 23.03.2009 18:34:
> Hi Guilhem & All
> 
> Guilhem Bichot wrote:
>> Hi Marc,
>>
>> You once explained that the data used by the Perf Schema is all-static,
>> allocated at startup. What happens if, after startup, a client does
>> "INSTALL PLUGIN a_plugin;"
>> and this plugin features your instrumentation?
>> Will the plugin's instrumented data be properly reported, or ignored?
>> Does a concurrent SELECT from the Perf Schema risk reading something wrong?
>> What about UNINSTALL PLUGIN?
>>
> 
> Let's assume that the server has room for 200 mutex instruments, for
> example because it was started with:
> 
> ./mysqld --performance-schema-max-mutex-instruments=200
> 
> Let's assume 150 mutex instruments have been loaded already.
> 
> Let's assume "a_plugin" contains 40 mutex instruments.
> Let's assume "b_plugin" contains 20 mutex instruments.
> 
> INSTALL PLUGIN a_plugin
> --> the server now has 150+40 = 190 mutex instruments.
> 
> UNINSTALL PLUGIN a_plugin
> --> the server still has 190 instruments
> All the historical data generated by the plugin code is still available

And thus, room in mutex_info_array (for example) is never freed, and as 
you explained, takes up space which the next to-be-installed plugin 
cannot use.
Is there a way to force uninstalled plugins to free space occupied in 
the above array? Is it planned?
Thread
[Fwd: Review of the performance schema instrumentation interface (was:moins de remplacements)]Marc Alff19 Mar
  • Re: [Fwd: Review of the performance schema instrumentation interface(was: moins de remplacements)]Guilhem Bichot23 Mar
    • Re: [Fwd: Review of the performance schema instrumentation interfaceMarc Alff23 Mar
      • Re: [Fwd: Review of the performance schema instrumentation interfaceGuilhem Bichot7 Apr
        • Re: [Fwd: Review of the performance schema instrumentation interfaceMarc Alff7 Apr
          • Re: [Fwd: Review of the performance schema instrumentation interfaceGuilhem Bichot7 Apr
            • Re: [Fwd: Review of the performance schema instrumentation interfaceMarc Alff7 Apr
              • Re: [Fwd: Review of the performance schema instrumentation interfaceGuilhem Bichot8 Apr
                • Re: [Fwd: Review of the performance schema instrumentation interfaceMarc Alff20 Jun
  • Instrumenting Maria system threads Re: [Fwd: Review of the performanceschema instrumentation interface (was: moins de remplacements)]Guilhem Bichot23 Mar
  • Re: Review of the performance schema instrumentation interfaceSergei Golubchik10 Apr
    • Re: Review of the performance schema instrumentation interfaceMichael Widenius13 Apr