SQL_NO_CACHE should optionally be supported

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.

https://webyog.com/

GNU General Public License v2.0

2.15k stars 316 forks source link

SQL_NO_CACHE should optionally be supported #1538

Open atulwy opened 9 years ago

atulwy commented 9 years ago

Original issue 1538 created by webyog on 2010-10-25T14:41:29.000Z:

Rationale is that if Query Cache is enabled on a server optimized for a specific application, working on the database with a GUI client may spoil the QC efficiency.

It should just be a 'preference' and if set SQL_NO_CACHE should be added to every SELECT query (at least every SELECT generated by the GUI).

atulwy commented 9 years ago

Comment #1 originally posted by webyog on 2011-09-04T07:16:23.000Z:

Request also for export/backup tools: http://www.webyog.com/forums/index.php?showtopic=6247

atulwy commented 9 years ago

Comment #2 originally posted by webyog on 2012-01-29T12:50:21.000Z:

Data Sync obviously.

atulwy commented 9 years ago

Comment #3 originally posted by webyog on 2012-04-10T19:12:24.000Z:

(http://code.google.com/p/sqlyog/issues/detail?id=1647) backup/export requested.

adleylcm commented 4 months ago

YES，SQL_NO_CACHE should optionally be supported。 After 5,7.20 'SQL_NO_CACHE' is deprecated，if you continue to use “sql_no_chache”, an warning will be generated, which is not good for error sql detection