apps:mysql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| apps:mysql [2014-06-16 22:57] – delete root | apps:mysql [2023-01-02 18:10] (current) – Manuel Frei | ||
|---|---|---|---|
| Line 12: | Line 12: | ||
| //Notes:// | //Notes:// | ||
| * //I use prefix u_ for users and prefix db_ for databases that I never mix them up.// | * //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 64 characters. They can be generated on [[https://pwgen.ch/]] for example.// |
| Line 33: | Line 33: | ||
| </ | </ | ||
| + | ===== 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:// | ||
apps/mysql.1402952258.txt.gz · Last modified: 2014-12-18 20:10 (external edit)