Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 5.5.31
    • None

    Description

      Hi guys, long time ago (2006) i request a feature at mysql dev team, and it was too easy that a 15old years guy done it
      i want to know inoformation about query cache, like a select * from query_cache
      there´s more information at http://bugs.mysql.com/bug.php?id=23714
      this help a lot when debuging and checking what´s the best policy to use with query cache

      Attachments

        Issue Links

          Activity

            only running
            select * from query_cache_info;
            /* Affected rows: 0 Registros encontrados: 1 Avisos: 0 Duração de 1 query: 0,015 sec. */
            select * from query_cache_info;
            /* Erro SQL (6): Error on delete of 'C:\Users\Beto\AppData\Local\Temp#sqlc24_7_1a6.MAD' (Errcode: 13) */

            very fast, i get the same error sql(6), errcode:13

            show warnings
            "Level" "Code" "Message"
            "Error" "6" "Error on delete of 'C:\Users\Beto\AppData\Local\Temp#sqlc24_7_1a6.MAD' (Errcode: 13)"

            rspadim roberto spadim added a comment - only running select * from query_cache_info; /* Affected rows: 0 Registros encontrados: 1 Avisos: 0 Duração de 1 query: 0,015 sec. */ select * from query_cache_info; /* Erro SQL (6): Error on delete of 'C:\Users\Beto\AppData\Local\Temp#sqlc24_7_1a6.MAD' (Errcode: 13) */ very fast, i get the same error sql(6), errcode:13 show warnings "Level" "Code" "Message" "Error" "6" "Error on delete of 'C:\Users\Beto\AppData\Local\Temp#sqlc24_7_1a6.MAD' (Errcode: 13)"

            flush query cache; stop working...

            Qcache_queries_in_cache=1
            select * from query_cache_info -> return 1 row
            FLUSH QUERY CACHE;
            Qcache_queries_in_cache=1
            select * from query_cache_info -> return 1 row (the same row)

            rspadim roberto spadim added a comment - flush query cache; stop working... Qcache_queries_in_cache=1 select * from query_cache_info -> return 1 row FLUSH QUERY CACHE; Qcache_queries_in_cache=1 select * from query_cache_info -> return 1 row (the same row)

            flush tables work

            Qcache_queries_in_cache=1
            select * from query_cache_information -> return 1 rows

            flush tables
            Qcache_queries_in_cache=0
            select * from query_cache_information -> return 0 rows

            rspadim roberto spadim added a comment - flush tables work Qcache_queries_in_cache=1 select * from query_cache_information -> return 1 rows flush tables Qcache_queries_in_cache=0 select * from query_cache_information -> return 0 rows

            DELETE FROM `QUERY_CACHE_INFO` WHERE `STATEMENT_SCHEMA`='information_schema' AND `STATEMENT_TEXT`='select SQL_CACHE * from test.a where b like \'ab%\'' AND `RESULT_BLOCKS_COUNT`=1 AND `RESULT_BLOCKS_SIZE`=23936 AND `RESULT_BLOCKS_SIZE_USED`=23935 LIMIT 1;

            don't work... but i think it will not work since delete isn't implemented

            well =) very nice job guys!!!

            rspadim roberto spadim added a comment - DELETE FROM `QUERY_CACHE_INFO` WHERE `STATEMENT_SCHEMA`='information_schema' AND `STATEMENT_TEXT`='select SQL_CACHE * from test.a where b like \'ab%\'' AND `RESULT_BLOCKS_COUNT`=1 AND `RESULT_BLOCKS_SIZE`=23936 AND `RESULT_BLOCKS_SIZE_USED`=23935 LIMIT 1; don't work... but i think it will not work since delete isn't implemented well =) very nice job guys!!!

            please disconsider this comments
            putting they in MDEV-4516

            thanks!

            rspadim roberto spadim added a comment - please disconsider this comments putting they in MDEV-4516 thanks!

            People

              serg Sergei Golubchik
              rspadim roberto spadim
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.