[MDEV-4581] QUERY CACHE - ADD more columns in QC_INFO plugin - JIRA

Details

Type: Task
Status: Closed
Priority: Major
Resolution: Duplicate
Fix Version/s: N/A
Component/s: Plugins
Labels:

Description

new fields (flags) to qc_info plugin

Gliffy Diagrams

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

diff_10_0_3_qc_info.cc
31 kB
2013-06-20 16:49

Issue Links

blocks

MDEV-4584 QUERY CACHE - SQL Control Interface

Open

is part of

MDEV-4682 QUERY CACHE - add STATISTICS per query and show this informations in qc_info plugin

Closed

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

roberto spadim added a comment - 2013-05-26 02:15

now last version...
some fields maybe should be human readable but idon't know how to do it, like:
COLUMN_FLAGS_CHARACTER_SET_CLIENT_NUM,
COLUMN_FLAGS_CHARACTER_SET_RESULTS_NUM,
COLUMN_FLAGS_COLLATION_CONNECTION_NUM,
COLUMN_FLAGS_SQL_MODE,
COLUMN_FLAGS_DEFAULT_WEEK_FORMAT

and
just two flags that i don't understand how to show it : LC_TIME_NAMES and TIME_ZONE

but, work is done, please close this mdev, and if possiblem, submit patch to review =)

thanks!

Show

roberto spadim added a comment - 2013-05-26 02:15 now last version... some fields maybe should be human readable but idon't know how to do it, like: COLUMN_FLAGS_CHARACTER_SET_CLIENT_NUM, COLUMN_FLAGS_CHARACTER_SET_RESULTS_NUM, COLUMN_FLAGS_COLLATION_CONNECTION_NUM, COLUMN_FLAGS_SQL_MODE, COLUMN_FLAGS_DEFAULT_WEEK_FORMAT and just two flags that i don't understand how to show it : LC_TIME_NAMES and TIME_ZONE but, work is done, please close this mdev, and if possiblem, submit patch to review =) thanks!

44 older comments

Hide

Permalink

Sergei Golubchik added a comment - 2013-08-18 11:49

unit tests — see unittest/ directory.
sql tests — see mysql-test/ directory.
for a plugin you would probably want to see the plugin suite, mysql-test/suite/plugin
or your own suite in plugin/qc_info/mysql-test/

See also https://kb.askmonty.org/en/mysql-test/

Show

Sergei Golubchik added a comment - 2013-08-18 11:49 unit tests — see unittest/ directory. sql tests — see mysql-test/ directory. for a plugin you would probably want to see the plugin suite, mysql-test/suite/plugin or your own suite in plugin/qc_info/mysql-test/ See also https://kb.askmonty.org/en/mysql-test/

Hide

Permalink

roberto spadim added a comment - 2014-09-21 00:24

please close this mdev, everything is inside mdev-4682

Show

roberto spadim added a comment - 2014-09-21 00:24 please close this mdev, everything is inside mdev-4682

Hide

Permalink

Daniel Black added a comment - 2015-05-18 15:06

https://github.com/MariaDB/server/pull/67/files contains just the flags addition.

Show

Daniel Black added a comment - 2015-05-18 15:06 https://github.com/MariaDB/server/pull/67/files contains just the flags addition.

Hide

Permalink

Daniel Black added a comment - 2015-05-21 04:56

i assume by upping the priority you might look at this. If so opening the issue again is probably also required.

Show

Daniel Black added a comment - 2015-05-21 04:56 i assume by upping the priority you might look at this. If so opening the issue again is probably also required.

Hide

Permalink

Sergei Golubchik added a comment - 2015-05-21 09:15

I'll look at ~~MDEV-4682~~

Show

Sergei Golubchik added a comment - 2015-05-21 09:15 I'll look at MDEV-4682

People

Assignee:

Sergei Golubchik

Reporter:

roberto spadim

Votes:

0 Vote for this issue

Watchers:

4 Start watching this issue

Dates

Created:

2013-05-25 13:23

Updated:

2015-05-21 09:15

Resolved:

2014-10-09 23:09

Time Tracking

Estimated:

1d 2h

Remaining:

1d 1h

Logged:

Agile

View on Board