MySQL缓存是否正在发生,如何解决? [英] Is MySQL caching occurring, how to fix it?
问题描述
我认为MySQL或ASP.NET正在缓存我的查询.
I think that MySQL or ASP.NET is caching my queries.
我编辑了我的MySQL程序以删除一些参数,但它一直说那些参数丢失了.如何解决此问题或使其重新工作?
I edited my MySQL sproc to remove some parameters but it keeps saying that those parameters are missing. How do I fix this or make it work again?
修改:
我遇到此问题: MySQL缓存
除了我无权执行 RESET QUERY CACHE
我还能做什么?
Except that I don't have permissions to execute RESET QUERY CACHE
What else can I do?
推荐答案
您需要了解的有关MySQL存储过程缓存的信息
与MySQL的每个单一连接服务器维护自己的存储空间过程缓存.
来自 SQL
这意味着重新启动浏览器,计算机,进一步修改过程等,这些都将无法正常工作.
What that means is that restarting your browser, computer, modifying the procedure further, etc, etc, all will not work.
您有几个选择:
- 重新启动MySQL数据库服务器或MySQL数据库服务器计算机 如果您具有特权,请在MySQL中
-
RESET QUERY CACHE
- 通过重新上传web.config,global.asax或整个应用程序来强制您的ASP.NET应用重新编译
- restart the MySQL database server or the MySQL database server computer
RESET QUERY CACHE
in MySQL if you have the priveladges- force your ASP.NET app to recompile by re-uploading the web.config, global.asax, or entire application
第三个是最简单,最好的选择.
The third is the easiest and best bet.
这篇关于MySQL缓存是否正在发生,如何解决?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!