[Phpmyadmin-devel] Better chart reordering for monitor tab

[Marc Delisle]

Le 2011-07-14 00:38, Tyron Madlener a écrit :
> On Wed, Jul 13, 2011 at 11:25 PM, Marc Delisle<marc at infomarc.info>  wrote:
>> Le 2011-07-13 15:29, Piotr Przybylski a écrit :
>>> 2011/7/13 Tyron Madlener<tyronx at gmail.com>:
>>>> On Wed, Jul 13, 2011 at 5:29 PM, Marc Delisle<marc at infomarc.info>    wrote:
>>>>> Le 2011-07-13 10:05, Tyron Madlener a écrit :
>>>>>> On Wed, Jul 13, 2011 at 4:36 PM, Marc Delisle<marc at infomarc.info>      wrote:
>>>>>>> Le 2011-07-13 07:46, Aris Feryanto a écrit :
>>>>>>>> ----- Original Message -----
>>>>>>>>
>>>>>>>>> From: Tyron Madlener<tyronx at gmail.com>
>>>>>>>>>
>>>>>>>>> On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx at gmail.com>
>>>>>>>>> wrote:
>>>>>>>>>> Just built a reusable jquery plugin for elegant reordering of
>>>>>>>>>> table cells. I will be using it for the Monitor Tab as it greatly
>>>>>>>>>> improves the usability of chart reordering
>>>>>>>>>
>>>>>>>>>> (mainly because I want the user to select a column width and have
>>>>>>>>>> automatic chart size, instead of setting a chart size and have
>>>>>>>>>> automatic column width):
>>>>>>>>>
>>>>>>>>> Column selection instead of chart size is now implemented in the
>>>>>>>>> Monitor Tab.
>>>>>>>>>
>>>>>>>>
>>>>>>>> The Monitor Tab looks great. However, I notice some bugs:
>>>>>>>>
>>>>>>>>
>>>>>>>> - when I change "Chart columns" to a smaller number, and then change
>>>>>>>> it to a bigger number, I see that there are some gap (blank cells)
>>>>>>>> between the charts. For my scenario, I change from 4 to 2 to 4. -
>>>>>>>> also, when I enter "Rearrange/edit charts" mode, the export chart
>>>>>>>> button and the gear button next to it cannot be clicked.
>>>>>>>
>>>>>>> Tyron,
>>>>>>> even when I activate all what's needed from the Monitor instructions
>>>>>>> panel, I still see five charts with "Chart title" as their title.
>>>>>>>
>>>>>>
>>>>>> Those two things are independent from each other. Having things
>>>>>> disabled in the monitor instructions dialog will just cause that you
>>>>>> won't be receiving any log data once you made a selection in any of
>>>>>> the charts.
>>>>>>
>>>>>> But about the bug, I think in one version the chart title was not set
>>>>>> correctly and you probably have it now in your browsers localStorage,
>>>>>> if you go to Settings=>Clear monitor config and reload the page it
>>>>>> should be displaying correct titles again (this loads the default
>>>>>> values)
>>>>>
>>>>> It worked (I had to clear the browser's cache too).
>>>>>
>>>>> What's the meaning of Questions? are these Queries?
>>>>>
>>>>
>>>> Questions is the name of a status variable.
>>>> See also http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Questions
>>>>
>>>
>>> I haven't looked at charts yet, but if this is translatable I suggest:
>>> * Questions ->    Queries sent to the server
>>> * Queries ->    Queries executed by the server
>>> or something similar. If it's too long: 'Queries sent' and 'Queries
>>> executed', with a footnote describing the difference.
>>>
>> IMO "Questions" should not be translated because it's like a keyword.
>> However we could do as in the "All status variables" (where we don't
>> translate the names of the status variables) and put a link to the MySQL
>> manual.
>>
>> By the way, on a idle server I get 8 questions per second, this must be
>> the monitoring system overhead. Shouldn't the monitor take this into
>> account when showing the stats?
>
> Yes that's the overhead. What do you mean with take it into account?
> Distract it from the Graph? I think that would be misleading to not
> show the real value of a status variable.

Well, there is no perfect solution here. It's also slightly misleading 
to produce a load just to measure it, then report this produced load.


-- 
Marc Delisle
http://infomarc.info