Ok, I think I know now where I should be heading to. I've just put the
latest dev version of pma onto my own dedicated server that runs a few
websites and to my amazement I get to see that my mysql server creates
huge amounts of traffic (4.3 GiB total in 2 days 6 hrs runtime) with
bursts of up to 0.5 mb on the traffic live chart with 2sec refresh
rate. Looking over the list of the alert values in the status
variables I see them being very high too.
I caught myself tabbing between the traffic and query live chart and
wondering which queries create this big amounts of traffic.
So, for pma to be a useful query optimization tool the following could be done:
- Allow users to make every numeric status variable chart-able.
There's many more variables worth watching than just queries, traffic
and connections/processes.
- Build an interface that allows you create your own reporting page
containing the charts you want. A little bit like the custom reporting
feature of google analytics. As an example in my case, I would want to
see queries, connections/processes and traffic chart all on one page.
This configuration could be later saved in the pma_config db
- On this custom reporting page, I not only want to have variable
charts, but (on demand) also a constantly refreshing list of top 5
slowest queries, maybe also something in connection with queries per
session - extracted from the general log.
- If the host is 'localhost'
- Read the slow_query_log from file giving us microsecond accuracy
instead of second.
- Allow additional charts for the reporting page such as cpu usage
and memory usage
- More importantly, I guess I will also have to build a feature that
allows recording of all this data, so that you can precisely track
down which queries are being slow. I'm not quite sure how to do this
yet. (Automatically building a custom table of each configuration?).
This will also require some time selection functionality for the
reporting page. This feature is probably going to take some longer
time to implement.
One advantage of grouped charts is I can retrieve all live data within
one http request. I only need some intelligent server<=>client
communication on what data should be sent.
And the ultimate ownage would be when we feed all this channeled
together data sources into a JavaScript rules-engine that can infer
concrete suggestions on how to optimize the queries :D
Anyway, I just thought its probably a good idea to write my plans here
so I can get some suggestions and verify that I'm on the correct path.
Thanks for taking the time to read it all ;-)
Hi,
in the last few weeks or months we have changed some redundant messages,
for example
Create new database -> Create database
Create new table -> Create table
Also we removed some unneeded initial uppercase letters.
I just saw this message:
"Add a new Event"
I suggest this:
"Add an event"
--
Marc Delisle
http://infomarc.info
Hi Marc,
I'm planning to ajaxify the Table->Browse->Multiple rows->Changes by using
the click event for "*rowsDeleteForm*". I'm planing to add it to "sql.js"
file. Is it okay. I'll update you soon on this.
Regards,
Thilanka.
--
L G Thilanka Kaushalya
Computer Science & Engineering,
University of Moratuwa,
Sri Lanka
Connect with me at,
Gmail : lgtkaushalya(a)gmail.com
Twitter : @thilanka_k
Facebook : Thilanka Kaushalya
Yahoo : lgtkaushalya(a)yahoo.com
Blog : http://coders-view.blogspot.com/
Hi all
while translating to Czech, I noticed that some messages are not really
good translatable. I've fixed what I've found so far and I've written
some guidelines to avoid such problems in future.
You can find the hints on our wiki:
http://wiki.phpmyadmin.net/pma/Gettext_for_developers#Translatable_messages
Please try to remember that phpMyAdmin is being translated to wide range
of languages and they compose the sentence in different ways.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
Hi Rouslan,
Now that version 3.4.3-rc1 is out, normal bug fixes in QA_3_4 should
target version 3.4.4. Therefore
- in ChangeLog, they should be under this line:
3.4.4.0 (not yet released)
- in the bug tracker, you should write (ok 3.4.4).
The MAINT_3_4_3 branch is open but should not receive fixes unless we
agree about their urgency for the final 3.4.3.
Thanks,
--
Marc Delisle
http://infomarc.info
Hi there,
I've added some animations to the routines functionalities in my branch
and I'm just looking for your opinions about this. A demo video is
available on my site [1]. Please let me know if you think that it's too
much eye-candy or if you think that it's OK. I didn't check this into my
repo yet and I'm keeping the code in my git-stash.
Also I'm wondering if it's worth adding a new configuration variable to
disable animations in PMA (there are already quite a few of them arou)
for users that have slower computers. What do you think?
Rouslan
[1]: http://www.placella.com/pma/routine_animations.ogv
Michal,
This is to answer your question in the git comment about updating
Blowfish library.
Indeed it would be a good idea to switch to PEAR package Crypt_Blowfish.
By the way, did you test the new version from Horde?
I am curious about the response time, because we found in the past that
running Blowfish encryption in PHP (for those who don't have the mcrypt
PHP extension) added many seconds of delay *for each click in phpMyAdmin*.
--
Marc Delisle
http://infomarc.info