Differences

This shows you the differences between two versions of the page.

--- apps:mysql [2014-06-16 22:57] – delete root
+++ apps:mysql [2016-11-19 16:17] – [Create new User+DB] root
@@ Line 12: / Line 12: @@
 //Notes://
   * //I use prefix u_ for users and prefix db_ for databases that I never mix them up.//
-  * //I recommend passwords with 42 characters. They can be generated on [[http://strongpasswordgenerator.com/]] for example.//
+  * //I recommend passwords with 42 characters. They can be generated on [[https://strongpasswordgenerator.com/]] for example.//
@@ Line 33: / Line 33: @@
 </code>
+===== Caching =====
+To make use of the MySQL query cache, the statements have to be exactly the same (including case):
+Following statements are treated differently by the cache but deliver the same results:
+  * SELECT * FROM tbl_name
+  * select * FROM tbl_name
+  * select * from tbl_name
+// More details: [[http://dev.mysql.com/doc/refman/5.6/en/query-cache-operation.html|How the Query Cache Operates]]//