Drizzle

data_dictionary table for protocol counters need to be added

Bug #686135 reported by Andrew Hutchings
12
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
High
Andrew Hutchings
Drizzle 2011-02-14
7.0
Fix Released
High
Andrew Hutchings
Drizzle 2011-02-14

Bug Description

mysql_protocol has a data_dictionary table for connection counters and drizzle_protocol used to have one but it was removed when drizzle_protocol switched to use mysql_protocol.

We need to remove these tables and add a single table for all protocol counters.

See original description

Related branches

lp:~linuxjedi/drizzle/trunk-bug-686135
Lee Bieber (community): Needs Fixing
Diff: 933 lines (+239/-277)
17 files modified
docs/installing/ubuntu.rst (+1/-1)
drizzled/plugin/listen.cc (+16/-7)
drizzled/plugin/listen.h (+24/-4)
plugin/drizzle_protocol/drizzle_protocol.cc (+3/-3)
plugin/drizzle_protocol/plugin.ini (+0/-1)
plugin/drizzle_protocol/status_table.h (+0/-66)
plugin/information_schema_dictionary/tests/r/tables.result (+4/-8)
plugin/mysql_protocol/mysql_protocol.cc (+8/-100)
plugin/mysql_protocol/mysql_protocol.h (+1/-0)
plugin/mysql_protocol/plugin.ini (+1/-1)
plugin/mysql_protocol/table_function.h (+0/-57)
plugin/mysql_unix_socket_protocol/protocol.cc (+1/-0)
plugin/protocol_dictionary/dictionary.cc (+98/-0)
plugin/protocol_dictionary/dictionary.h (+50/-0)
plugin/protocol_dictionary/plugin.ini (+9/-0)
plugin/schema_dictionary/tests/r/data_dictionary.result (+21/-25)
tests/r/information_schema.result (+2/-4)
Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

Needs to wait until lp:~linuxjedi/drizzle/trunk-max-connections is merged as this includes code to separate the counters to per-protocol.

Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

After discussion with Brian we should have a single table for all the protocol counters.

Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

This branch adds a data_dictionary.protocol_counters table which contains the separate counters for each protocol. At the same time it removes the individual per-protocol tables which currently only works for mysql_protocol anyway.

I believe max_connections came up in the conf call, you should be able to find this using:
show variables like '%max_connections';

summary: - data_dictionary tables for protocol counters need to be added back
+ data_dictionary table for protocol counters need to be added
description: updated
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.