Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-617

LP:671189 - Query cache is not used for tables or databases with dots in their names

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.0, 5.5.28, 5.3.9, 5.2.12, 5.1.62
    • Fix Version/s: 10.0.4
    • Component/s: None
    • Labels:

      Description

      I've confirmed this bug with mariadb 5.1.49 from our delta rep for lucid (5.1.49-mariadb82) it is not present on mysql 5.1.41 on lucid (5.1.41-3ubuntu12.6)

      Can be replicated as follows

      MariaDB [(none)]> CREATE DATABASE `foo.bar`;
      Query OK, 1 row affected (0.00 sec)
       
      MariaDB [(none)]> use foo.bar;
      Database changed
       
      MariaDB [foo.bar]> CREATE TABLE moocow (a int);
      Query OK, 0 rows affected (0.01 sec)
       
      MariaDB [foo.bar]> SHOW STATUS LIKE 'Qcache%';
      +-------------------------+-----------+
      | Variable_name           | Value     |
      +-------------------------+-----------+
      | Qcache_free_blocks      | 1         |
      | Qcache_free_memory      | 268415928 |
      | Qcache_hits             | 1         |
      | Qcache_inserts          | 1         |
      | Qcache_lowmem_prunes    | 0         |
      | Qcache_not_cached       | 15311     |
      | Qcache_queries_in_cache | 1         |
      | Qcache_total_blocks     | 4         |
      +-------------------------+-----------+
      8 rows in set (0.00 sec)
       
      MariaDB [foo.bar]> INSERT INTO moocow VALUES (1), (2), (3);
      Query OK, 3 rows affected (0.00 sec)
      Records: 3  Duplicates: 0  Warnings: 0
       
      MariaDB [foo.bar]> SELECT * FROM moocow;
      +------+
      | a    |
      +------+
      |    1 |
      |    2 |
      |    3 |
      +------+
      3 rows in set (0.00 sec)
       
      MariaDB [foo.bar]> SHOW STATUS LIKE 'Qcache%';
      +-------------------------+-----------+
      | Variable_name           | Value     |
      +-------------------------+-----------+
      | Qcache_free_blocks      | 1         |
      | Qcache_free_memory      | 268415928 |
      | Qcache_hits             | 1         |
      | Qcache_inserts          | 1         |
      | Qcache_lowmem_prunes    | 0         |
      | Qcache_not_cached       | 15312     |
      | Qcache_queries_in_cache | 1         |
      | Qcache_total_blocks     | 4         |
      +-------------------------+-----------+
      8 rows in set (0.00 sec)

        Attachments

          Activity

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            johnferlito John Ferlito (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration