MZMcBride wrote:
Platonides wrote:
A few hours ago I issued the following command in
commonswiki_p
mysql> select * from logging where log_namespace=6 and
log_title='Estatuas_y_fuentes_de_La_Granja_de_San_Ildefonso_1.jpg' limit 10;
Empty set (1 hour 5 min 33.53 sec)
You probably want logging_ts_alternative instead of logging.
That's *much* faster (0.00 sec), using the 261 len index, and having
log_page.
Why is there a second view logging_ts_alternative?
The only "documentation" I found is you mail from July "it simply omits
certain redacted rows rather than checking their permissions, or
something" but afaik all toolserver views work by adding sql to skip the
hidden rows (but in this case, it shouldn't matter).
The wiki reports no log entries for that
title/namespace/wiki combination,
by the way.
I know. But I wanted to provide the real sql. I was testing queries for
finding the log entry of a rename /to/ that name [it is logged at the
old name, and the new one appears in log_params :( ].