Hello Martin,
Adding "and log_namespace = 2" to the where clause solves the performance
problem.
Regards.
On Monday, June 3, 2019, 8:31:44 PM GMT+3, Martin Urbanec
wrote:
Hello,
I'm trying to run this query more fastly. Can you help me how to optimalize it?
MariaDB [commonswiki_p]> s
To use those indexes on title you also need to filter by log_namespace:
MariaDB [commonswiki_p]> select count(*) from logging_logindex where
log_type="thanks" and log_title="Martin_Urbanec" and log_namespace = 2;
+--+
| count(*) |
+--+
|6 |
+--+
1 row in set (0.03 se
Hello,
On Mon, Jun 3, 2019 at 7:31 PM Martin Urbanec
wrote:
>
> Hello,
>
> I'm trying to run this query more fastly. Can you help me how to optimalize
> it?
>
> MariaDB [commonswiki_p]> select count(*) from logging_logindex where
> log_type="thanks" and log_title="Martin_Urbanec";
> +--
Hello,
I'm trying to run this query more fastly. Can you help me how to optimalize
it?
MariaDB [commonswiki_p]> select count(*) from logging_logindex where
log_type="thanks" and log_title="Martin_Urbanec";
+--+
| count(*) |
+--+
|6 |
+--+
1 row in set (8 min 42.87
