Many reports are based on aggregating by date or hour. Currently these columns are calculated on the fly, but grouping on them is very slow. By allowing for alternate time columns we can index the table more efficiently for common reports and gain a huge improvement in speed. Also fixed one bug in graph zoom related to filtering
+ added group by digest to default perf_schema report + cleaned up numerous warnings + created show_query page for perf_schema
Re #64, verify php version in index.php before doing anything else. This...
Small tweaks to make these files actually work. + fixed USE statements + fixed EXECUTE
+ the filtering to auto detect which columns on which to aggregate wasn't handling some fields correctly + added exception to keep group by from being ambiguous
EXECUTE needs to use stmt, not @stmt.
use db foo - tries to connect to "db", not "foo".
small change, but need to use the db before you create tables in it.
…his should prevent people from trying to run on outdated php versions.
- the challenge was to handle many cases: + visually we want to display column names without table prefix + expressions which alias to a name must be unchanged + a couple special fields have to be ignored + maintain backwards compatability with get params which do not provide exact field names
Update README with updated proper instructions
- in addition all places where checksum is passed as a parameter should now handle both formats, including search. - this behavior requires a change to the config.inc.php file. The sample has been updated, but end users will have to merge with thier local conf
- Updated instructions so that you grab the code before importing install.sql - You can't import something that has not been checked out - Updated some minor wording. i.e. apache server is now web server and web root is now document root for clarification
Use QDUI Query Rewriter which supports a much wider set of queries to ex...
Fix an issue where dbFields would be rendered incorrectly and cause a js...
Move all css/js assets locally, this allows use in a network limited env
Quote field and table names
… explain. Fixes #17
… js error
These were causing messy UI jumps to the top of page when clicked.