Can't set query-cache-size

Bug #1544793 reported by Haw Loeung
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysql (Juju Charms Collection)
New
Undecided
Unassigned

Bug Description

Hi,

It seems there's issues with the query-cache settting. In config.yaml, it says it's of type 'int:

| query-cache-size can
| query-cache-size:
| default: 0
| type: int

But when I try set it to query-cache-size=8388608, it produces an invalid config:

| /usr/bin/mysqladmin: connect to server at 'localhost' failed
| error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
| Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
| Unknown suffix '.' used for variable 'query_cache_size' (value '8388608.0')
| 160212 0:16:46 [ERROR] /usr/sbin/mysqld: Error while setting value '8388608.0' to 'query_cache_size'
| 160212 0:16:46 [ERROR] Aborting

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.