Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Enhance query statistics #61

Open
renecannao opened this issue Apr 27, 2014 · 0 comments
Open

Enhance query statistics #61

renecannao opened this issue Apr 27, 2014 · 0 comments
Labels
enhancement
Milestone
Hebe - stable

Comments

@renecannao
Copy link
Owner

Query statistics module needs to be extended to support more information, like:

  • username
  • schema
  • bytes
  • client source
  • backend used (if any)
  • execution time
@renecannao renecannao added this to the Hebe - stable milestone Apr 29, 2014
renecannao added a commit that referenced this issue Apr 29, 2014
@renecannao
Several improvements for several issues
34d491d 
Issue #60
Issue #61

Fixed a typo in README : mysql_query_statistics_enabled instead of mysql_query_statistics
statsdb is accessible via admin interface
Added table query_stats in statsdb
Added function __sqlite3_statsdb__flush_query_stats() to dump query statistics in statsdb
Extended __qr_hash_entry
Reintroduced L_SFC_MID_ELEM_SIZE and L_SFP_ARRAY_MID to improve memory management
Added functions mysql_query_digest() , cleanup_query_stats() and process_query_stats()
Removed function process_query_stats()
mysql_query_metadata_t extended with a qr_hash_entry
Added debug module PROXY_DEBUG_QUERY_STATISTICS
Added function __admin_sqlite3__check_and_build_statsdb_tables() to build tables in table_defs_statsdb[]
Initialized alloc_cnt and free_cnt in l_mem_init()
Disabled deprecated g_thread_init()
pthread_join() for query cache is called only if QC is enabled
Pointers in stackspts are deallocated only if not NULL
Cleanup of my->input.mypkt and my->output.mypkt in mysql_data_stream_delete()
Improved __default_hostgroup__find_defHG() to avoid some errors in valgrind
renecannao added a commit that referenced this issue Apr 29, 2014
@renecannao
Adding username and schemaname in query statistics
69b1822 
Issue #61
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement
Projects
None yet
Milestone
Hebe - stable
Development

No branches or pull requests
1 participant
@renecannao