[MDEV-4580] query cache information patch Created: 2013-05-25  Updated: 2013-05-26  Resolved: 2013-05-26

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: roberto spadim Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None

Attachments: Text File diff_qc_info.cc    

 Description   

hi i will send a patch based in MDEV-4516 informations and many others flags



 Comments   
Comment by roberto spadim [ 2013-05-25 ]

please disconsider it
i put another one, with the "i" value of the for() inside query cache HASH

Comment by roberto spadim [ 2013-05-25 ]

now =) this one have the "ENTRY_POSITION_IN_CACHE"
so we know where is the "row" in hash tables or hash queries

=)
well i think that's done
must put some conversion to be more human readable in some flags like:
FLAGS_PROTOCOL_TYPE
FLAGS_CLIENT_LONG_FLAG
FLAGS_PKT_NR ???
FLAGS_CHARACTER_SET_CLIENT_NUM
FLAGS_CHARACTER_SET_RESULTS_NUM
FLAGS_COLLATION_CONNECTION_NUM
add FLAGS_TIME_ZONE
FLAGS_SQL_MODE ??? how to convert to string?
add FLAGS_LC_TIME_NAMES
RESULT_TABLES_TYPE ??? what this do?

and at query_cache_tables
what this do? TABLE_HASHED

and how to add tables that are being used in a query? like:
database.table, database1.table1, database2.table2 ......

or maybe create another table just to do this (the only problem is the qc lock)

Comment by roberto spadim [ 2013-05-25 ]

now with tables in query entries

please review the code i never used this (strings) in c/c++

Comment by roberto spadim [ 2013-05-25 ]

tables, rows, and every thing that i want =)

Comment by roberto spadim [ 2013-05-25 ]

select * from query_cache_queries where tables like "%`teste`.`a`%"

!!!!Unable to render embedded object: File (it works) not found.!!!! /) (\

Comment by roberto spadim [ 2013-05-25 ]

please close this mdev i will update it in MDEV-4581

Generated at Thu Feb 08 06:57:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.