[Phpmyadmin-devel] Better chart reordering for monitor tab

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): http://www.tyron.at/tmp/ts.html There is still a bug when an element is dropped before the 'preview animation' is over (200ms). But apart from that it's kinda fun to play with, thus I'm posting it here ;-)

Hi Dne Tue, 12 Jul 2011 21:59:43 +0300 Tyron Madlener <tyronx@gmail.com> napsal(a):
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):
http://www.tyron.at/tmp/ts.html
There is still a bug when an element is dropped before the 'preview animation' is over (200ms). But apart from that it's kinda fun to play with, thus I'm posting it here ;-)
I'm not sure if it is the bug you are talking about, but I managed to move cells out of table (and in fact out of screen) - before first column. Also it is sometimes possible to place two cells at single place. Not sure if I can describe how to reproduce, it was more or less random moving :-). -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

On Tue, 2011-07-12 at 21:11 +0200, Michal Čihař wrote:
Hi
Dne Tue, 12 Jul 2011 21:59:43 +0300 Tyron Madlener <tyronx@gmail.com> napsal(a):
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):
http://www.tyron.at/tmp/ts.html
There is still a bug when an element is dropped before the 'preview animation' is over (200ms). But apart from that it's kinda fun to play with, thus I'm posting it here ;-)
I'm not sure if it is the bug you are talking about, but I managed to move cells out of table (and in fact out of screen) - before first column. Also it is sometimes possible to place two cells at single place. Not sure if I can describe how to reproduce, it was more or less random moving :-).
+1, moving the boxes randomly makes them go bonkers. Screenshot attached. Rouslan

On Tue, Jul 12, 2011 at 10:21 PM, Rouslan Placella <rouslan@placella.com> wrote:
On Tue, 2011-07-12 at 21:11 +0200, Michal Čihař wrote:
Hi
Dne Tue, 12 Jul 2011 21:59:43 +0300 Tyron Madlener <tyronx@gmail.com> napsal(a):
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):
http://www.tyron.at/tmp/ts.html
There is still a bug when an element is dropped before the 'preview animation' is over (200ms). But apart from that it's kinda fun to play with, thus I'm posting it here ;-)
I'm not sure if it is the bug you are talking about, but I managed to move cells out of table (and in fact out of screen) - before first column. Also it is sometimes possible to place two cells at single place. Not sure if I can describe how to reproduce, it was more or less random moving :-).
+1, moving the boxes randomly makes them go bonkers. Screenshot attached.
Yes that's the same bug.
Rouslan
------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

On Wed, Jul 13, 2011 at 12:51 AM, Tyron Madlener <tyronx@gmail.com> wrote:
On Tue, Jul 12, 2011 at 10:21 PM, Rouslan Placella <rouslan@placella.com> wrote:
On Tue, 2011-07-12 at 21:11 +0200, Michal Čihař wrote:
Hi
Dne Tue, 12 Jul 2011 21:59:43 +0300 Tyron Madlener <tyronx@gmail.com> napsal(a):
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):
http://www.tyron.at/tmp/ts.html
There is still a bug when an element is dropped before the 'preview animation' is over (200ms). But apart from that it's kinda fun to play with, thus I'm posting it here ;-)
I'm not sure if it is the bug you are talking about, but I managed to move cells out of table (and in fact out of screen) - before first column. Also it is sometimes possible to place two cells at single place. Not sure if I can describe how to reproduce, it was more or less random moving :-).
+1, moving the boxes randomly makes them go bonkers. Screenshot attached.
Yes that's the same bug.
Now it's fixed. Everything should be working correctly now.
Rouslan
------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Hi Dne Wed, 13 Jul 2011 10:34:50 +0300 Tyron Madlener <tyronx@gmail.com> napsal(a):
Now it's fixed. Everything should be working correctly now.
There is still small bug I can see - when you drag cell out of window, it stays attached to the mouse even if you release the button and you have to click again to drop it. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

On Wed, Jul 13, 2011 at 10:40 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Wed, 13 Jul 2011 10:34:50 +0300 Tyron Madlener <tyronx@gmail.com> napsal(a):
Now it's fixed. Everything should be working correctly now.
There is still small bug I can see - when you drag cell out of window, it stays attached to the mouse even if you release the button and you have to click again to drop it.
Ok, fixed as well. Thanks for pointing that out.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com

On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener <tyronx@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.
http://www.tyron.at/tmp/ts.html
There is still a bug when an element is dropped before the 'preview animation' is over (200ms). But apart from that it's kinda fun to play with, thus I'm posting it here ;-)

----- Original Message -----
From: Tyron Madlener <tyronx@gmail.com>
On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener <tyronx@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. -- Aris Feryanto

Le 2011-07-13 07:46, Aris Feryanto a écrit :
----- Original Message -----
From: Tyron Madlener<tyronx@gmail.com>
On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx@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. -- Marc Delisle http://infomarc.info

On Wed, Jul 13, 2011 at 4:36 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-07-13 07:46, Aris Feryanto a écrit :
----- Original Message -----
From: Tyron Madlener<tyronx@gmail.com>
On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx@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) Every change you make in the monitor is currently saved into localStorage. Building a better configuration handling is part of my plan, the current solution is just the very first version :-)
-- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Le 2011-07-13 10:05, Tyron Madlener a écrit :
On Wed, Jul 13, 2011 at 4:36 PM, Marc Delisle<marc@infomarc.info> wrote:
Le 2011-07-13 07:46, Aris Feryanto a écrit :
----- Original Message -----
From: Tyron Madlener<tyronx@gmail.com>
On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx@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?
Every change you make in the monitor is currently saved into localStorage. Building a better configuration handling is part of my plan, the current solution is just the very first version :-)
-- Marc Delisle http://infomarc.info

On Wed, 2011-07-13 at 10:29 -0400, Marc Delisle wrote:
Le 2011-07-13 10:05, Tyron Madlener a écrit :
On Wed, Jul 13, 2011 at 4:36 PM, Marc Delisle<marc@infomarc.info> wrote:
Le 2011-07-13 07:46, Aris Feryanto a écrit :
----- Original Message -----
From: Tyron Madlener<tyronx@gmail.com>
On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx@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?
I think that questions is queries as executed by the server. So, if you have defined a stored procedure as follows: CREATE PROCEDURE `proc`() BEGIN SELECT NULL; SELECT 0; END and you call it with CALL `proc`(); that would make 1 query, but 3 questions (the CALL + the 2 SELECTs that the server will run) Bye, Rouslan

On Wed, Jul 13, 2011 at 5:29 PM, Marc Delisle <marc@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@infomarc.info> wrote:
Le 2011-07-13 07:46, Aris Feryanto a écrit :
----- Original Message -----
From: Tyron Madlener<tyronx@gmail.com>
On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx@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_...
Every change you make in the monitor is currently saved into localStorage. Building a better configuration handling is part of my plan, the current solution is just the very first version :-)
-- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

2011/7/13 Tyron Madlener <tyronx@gmail.com>:
On Wed, Jul 13, 2011 at 5:29 PM, Marc Delisle <marc@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@infomarc.info> wrote:
Le 2011-07-13 07:46, Aris Feryanto a écrit :
----- Original Message -----
From: Tyron Madlener<tyronx@gmail.com>
On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx@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_...
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. -- Regards, Piotr Przybylski

Le 2011-07-13 15:29, Piotr Przybylski a écrit :
2011/7/13 Tyron Madlener<tyronx@gmail.com>:
On Wed, Jul 13, 2011 at 5:29 PM, Marc Delisle<marc@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@infomarc.info> wrote:
Le 2011-07-13 07:46, Aris Feryanto a écrit :
----- Original Message -----
> From: Tyron Madlener<tyronx@gmail.com> > > On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx@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_...
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? -- Marc Delisle http://infomarc.info

On Wed, Jul 13, 2011 at 11:25 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-07-13 15:29, Piotr Przybylski a écrit :
2011/7/13 Tyron Madlener<tyronx@gmail.com>:
On Wed, Jul 13, 2011 at 5:29 PM, Marc Delisle<marc@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@infomarc.info> wrote:
Le 2011-07-13 07:46, Aris Feryanto a écrit : > ----- Original Message ----- > >> From: Tyron Madlener<tyronx@gmail.com> >> >> On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx@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_...
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.
-- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Le 2011-07-14 00:38, Tyron Madlener a écrit :
On Wed, Jul 13, 2011 at 11:25 PM, Marc Delisle<marc@infomarc.info> wrote:
Le 2011-07-13 15:29, Piotr Przybylski a écrit :
2011/7/13 Tyron Madlener<tyronx@gmail.com>:
On Wed, Jul 13, 2011 at 5:29 PM, Marc Delisle<marc@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@infomarc.info> wrote: > Le 2011-07-13 07:46, Aris Feryanto a écrit : >> ----- Original Message ----- >> >>> From: Tyron Madlener<tyronx@gmail.com> >>> >>> On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx@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_...
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

On Thu, Jul 14, 2011 at 3:55 PM, Marc Delisle <marc@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@infomarc.info> wrote:
Le 2011-07-13 15:29, Piotr Przybylski a écrit :
2011/7/13 Tyron Madlener<tyronx@gmail.com>:
On Wed, Jul 13, 2011 at 5:29 PM, Marc Delisle<marc@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@infomarc.info> wrote: >> Le 2011-07-13 07:46, Aris Feryanto a écrit : >>> ----- Original Message ----- >>> >>>> From: Tyron Madlener<tyronx@gmail.com> >>>> >>>> On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener<tyronx@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_...
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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Hi Dne Thu, 14 Jul 2011 08:55:52 -0400 Marc Delisle <marc@infomarc.info> napsal(a):
Le 2011-07-14 00:38, Tyron Madlener a écrit :
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.
Monitoring does always introduce some load on the monitored system and it should not be magically hidden. Also you usually don't monitor idle system and few extra queries will be hidden in real load. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

On Wed, Jul 13, 2011 at 2:46 PM, Aris Feryanto <aris_feryanto@yahoo.com> wrote:
----- Original Message -----
From: Tyron Madlener <tyronx@gmail.com>
On Tue, Jul 12, 2011 at 9:59 PM, Tyron Madlener <tyronx@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.
Oh yes, will fix that.
- also, when I enter "Rearrange/edit charts" mode, the export chart button and the gear button next to it cannot be clicked.
This is now fixed and pushed to my repo. Thanks for the reports!
-- Aris Feryanto
participants (6)
-
Aris Feryanto
-
Marc Delisle
-
Michal Čihař
-
Piotr Przybylski
-
Rouslan Placella
-
Tyron Madlener