Sunday, July 10, 2011

Week 7 report

I've been making good progress on the 'Monitor' Tab. Now the user has the ability to select a time span in any chart, which will load intelligently grouped data from the logs.
Also the current configuration is now saved in the browsers local storage (however, currently it doesn't save how the charts are ordered).
I'm quite happy how the monitor turned out so far, though there's still a lot of rough edges that I will have to even out ;-)

Regarding intelligently grouped data:
Currently, selecting log data does the following (more will come):
- Returns only INSERT, UPDATE, DELETE, SELECT
- Groups together queries that are identical and therefore adds a 'count' column to the result table.
- Truncates long INSERTs and UPDATEs (above 300 chars)
- If selected, groups together INSERTs into the same table.
- Also creates some statistics what query types have been found in this time range

What I made this week:
- Linux CPU / Swap Usage are now correct
- Lots of UI work on for selecting data from the logs. The user can now select a time span in any chart that will load the logs from the general_log or slow_log in that given time span.
- Play/Pause button
- An Instructions/Setup dialog that contains useful information on how to use the Monitor, as well as a bunch of links that allow the user to configure the server to start logging.
- A first implementation of saving the settings to the browsers storage (localStorage)
- A lot of other small UI improvements (e.g. edit mode, better chart tooltip)

What I will do next week:
I will have a lot of small things to do for the Monitor:
- Take into consideration that not every server is on localhost
- Test Monitor without super user rights
- Proper l10n
- A better "chart grid". I think one should be able to select how many 'columns' of charts he wants to have. Maybe some autosize to window width would be useful too.
- More ways to save the monitor settings
- IE compatibility
- Import/Export config
- Save how the charts are ordered

- More ways to extract the data you need for optimizing server/queries
- Generally improve the Monitor to make it more usable for query optimization. Need to research on this a bit more.

If some time is left, I will improve some other parts of pma on which I have wrote a lot of suggestions on the mailing list (i.e. create table dialog).

No comments:

Post a Comment