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 :( ].