https://bugzilla.wikimedia.org/show_bug.cgi?id=48875
Web browser: ---
Bug ID: 48875
Summary: Unable to explain queries on replicated databases
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: Unprioritized
Component: tools
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Mobile Platform: ---
Although not essential, it would be very useful to be able to explain queries
run against the replicated Wiki databases and examine table indexes without
having to refer to external docs.
Transcript follows:
-----
tb@tools-login:~$ mysql -h enwiki.labsdb;
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 618336
Server version: 5.5.30-MariaDB-mariadb1~precise-log mariadb.org binary
distribution
Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use enwiki_p;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [enwiki_p]> show index in page;
Empty set (0.03 sec)
MariaDB [enwiki_p]> explain select count(*) from page where page_namespace = 0;
ERROR 1345 (HY000): EXPLAIN/SHOW can not be issued; lacking privileges for
underlying table
MariaDB [enwiki_p]>
-----
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
