I've got the following replication situation...
A --> B --> C
All data changes, updates and adds go into DB-A. I work with DB-C and
pull all my queries for reporting from that. Would there be any problem
with adding new indexes or different indexes to DB-C than exist in DB-A
or B?
Is there a command/query I can issue to show me the indexed columns for
tables in DB-C (I inherited these DB's so there's still a lot I don't
know about their structure).
Thanks,
Jeff McKeon
IT Manager
Telaurus Communications LLC
jmckeon@telauru s.com
(973) 889-8990 ex 209=20
***The information contained in this communication is confidential. It
is intended only for the sole use of the recipient named above and may
be legally privileged. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this communication, or any of its contents or attachments,
is expressly prohibited. If you have received this communication in
error, please re-send it to the sender and delete the original message,
and any copy of it, from your computer system. Thank You.***
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3...ie.nctu.edu.tw
A --> B --> C
All data changes, updates and adds go into DB-A. I work with DB-C and
pull all my queries for reporting from that. Would there be any problem
with adding new indexes or different indexes to DB-C than exist in DB-A
or B?
Is there a command/query I can issue to show me the indexed columns for
tables in DB-C (I inherited these DB's so there's still a lot I don't
know about their structure).
Thanks,
Jeff McKeon
IT Manager
Telaurus Communications LLC
jmckeon@telauru s.com
(973) 889-8990 ex 209=20
***The information contained in this communication is confidential. It
is intended only for the sole use of the recipient named above and may
be legally privileged. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this communication, or any of its contents or attachments,
is expressly prohibited. If you have received this communication in
error, please re-send it to the sender and delete the original message,
and any copy of it, from your computer system. Thank You.***
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3...ie.nctu.edu.tw