[Phpmyadmin-devel] Better chart reordering for monitor tab

[Tyron Madlener]

On Thu, Jul 14, 2011 at 3:55 PM, Marc Delisle <marc at infomarc.info> wrote:
> 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.
>

I think that would be the same as hiding taskmgr.exe from the windows
task manager ;-)

>
> --
> Marc Delisle
> http://infomarc.info
>
> ------------------------------------------------------------------------------
> AppSumo Presents a FREE Video for the SourceForge Community by Eric
> Ries, the creator of the Lean Startup Methodology on "Lean Startup
> Secrets Revealed." This video shows you how to validate your ideas,
> optimize your ideas and identify your business strategy.
> http://p.sf.net/sfu/appsumosfdev2dev
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>