Developers June 2011

developers@phpmyadmin.net

13 participants
69 discussions

[Phpmyadmin-devel] Plans for the status page
by Tyron Madlener 23 Jun '11

23 Jun '11

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 ;-)

2 2

[Phpmyadmin-devel] notices in libraries/RecentTables.class.php
by Marc Delisle 23 Jun '11

23 Jun '11

From current master, when browsing a table: Warning in ./libraries/RecentTable.class.php#190 array_unshift() expects parameter 1 to be array, null given Backtrace ./libraries/RecentTable.class.php#190: array_unshift( NULL, string sakila.actor, ) ./libraries/header.inc.php#22: PMA_RecentTable->add( string sakila, string actor, ) ./libraries/header.inc.php#171: PMA_addRecentTable( string sakila, string actor, ) ./libraries/tbl_links.inc.php#40: require_once(./libraries/header.inc.php) ./sql.php#881: require(./libraries/tbl_links.inc.php) -- Marc Delisle http://infomarc.info

3 8

[Phpmyadmin-devel] about "add a new"
by Marc Delisle 23 Jun '11

23 Jun '11

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

1 0

[Phpmyadmin-devel] AJAXify phpMyAdmin Interface - GSOC 2011 - Table->Browse ->Mutiple rows-> Change
by Thilanka Kaushalya 22 Jun '11

22 Jun '11

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/

3 15

[Phpmyadmin-devel] Translatable messages
by Michal Čihař 22 Jun '11

22 Jun '11

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

3 3

[Phpmyadmin-devel] about QA_3_4
by Marc Delisle 22 Jun '11

22 Jun '11

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

3 5

[Phpmyadmin-devel] warning about missing mcrypt extension
by Marc Delisle 22 Jun '11

22 Jun '11

Hi, Since today's changes, this warning is displayed but I have the extension. -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] Animations in routines functionality
by Rouslan Placella 22 Jun '11

22 Jun '11

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

4 12

[Phpmyadmin-devel] about Blowfish in PHP
by Marc Delisle 21 Jun '11

21 Jun '11

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

2 2

[Phpmyadmin-devel] Users survey
by Michal Čihař 21 Jun '11

21 Jun '11

Hi all when I did setup survey site for deciding default theme for 3.4, I've also got idea to get more feedback from our users. This can help us in making some decisions about future development. We can take inspiration from Git User's Survey [1] (check last survey and results [2]). I think the survey should be open for pretty long time, let's say two months, to acquire as much feedback as possible. I've started collecting questions on wiki [3], basically starting with questions based on the Git ones. [1]:https://git.wiki.kernel.org/index.php/GitSurvey2010 [2]:https://www.survs.com/results/33Q0OZZE/MV653KSPI2 [3]:http://wiki.phpmyadmin.net/pma/User%27s_Survey_2011 -- Michal Čihař | http://cihar.com | http://blog.cihar.com

7 10

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers June 2011