Yet another post about DBaaS. This time the updates are about database parameters.
1. We have added a few more parameters that can be set in the control panel.
For PostgreSQL:
→ max_connections
— maximum number of simultaneous requests to the database;
→ shared_buffers
— the amount of RAM the database server uses for shared memory buffers;
→ wal_buffers
— the amount of shared memory used for WAL data that has not yet been written to disk;
→ temp_buffers
— size of temporary buffers;
→ work_mem
— the amount of memory for sorting or hashing.
For MySQL:
→ max_connections
— maximum number of simultaneous requests to the database;
→ sql_mode
— setting of query processing mode;
→ query_cache_type
— enables or disables query cache;
→ query_cache_size
— sets the size of this cache.
2. All fields in the parameter section are now always pre-filled in. If you haven't changed the parameter via the control panel or API, we will show the default value. Previously in this case the field was empty.
3. You can reset all parameters to default values with one click.