Details
-
Type:
Task
-
Status: Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
hi i will send a patch based in MDEV-4516 informations and many others flags
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
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)
now with tables in query entries
please review the code i never used this (strings) in c/c++
tables, rows, and every thing that i want =)
select * from query_cache_queries where tables like "%`teste`.`a`%"
!!!!Unable to render embedded object: File (it works) not found.!!!! /) (\
please close this mdev i will update it in MDEV-4581
please disconsider it
i put another one, with the "i" value of the for() inside query cache HASH