optimization
Just wanted to know how to fix the 3 fail below in the host tools:
MySQL:
- key_buffer_size = 1073741824 - OK
- query_cache_limit = 1048576 - OK
- query_cache_size = 0 - FAIL (must be >= 16777216)
- query_cache_type = OFF - FAIL (must be strcasecmp on)
- max_heap_table_size = 16777216 - OK
- tmp_table_size = 16777216 - OK
- thread_cache_size = 0 - FAIL (must be > 0)
-
Hello Michael Beloved !
Usually, it's better to ask your hosting support team to do it. Because it's need to operate with these settings of your MySQL server:
https://dev.mysql.com/doc/refman/5.6/en/query-cache-configuration.html
-
LeonidS,
Server wont do anything about that because of shared hosting. Can I just do without it for the time being.
=======
Response from server below:
Unfortunately, these changes can not be made, since they are global changes that would affect all of the user's on it.
Since you are using our Shared Hosting Environment, we would be unable to performed them.
If you would like to have them carried out, you would need to upgrade to one of our VPS packages.
After you are using a dedicated environment, we would be able to make the desired changes.
-
So, in many cases the upgrade to the more advanced plan is the only one