Team,
I noticed that percona does not have a my.cnf file by default like MySQL does.
I tried to add one with minimal changes to increase the packet limit, but the service restart failed.
I was able to start again without the my.cnf changes and make a global setting change, but I don’t think this will persist across service restarts. Is there any way to get this setting to work in a my.cnf file?
There are 6-8 settings we typically run with here, and not sure what other issues we might run into without these other settings.
The commands I used to update the packet limit were:
mysql> show global variables like ‘max_allowed_packet’;
±-------------------±--------+
| Variable_name | Value |
±-------------------±--------+
| max_allowed_packet | 1048576 |
±-------------------±--------+
1 row in set (0.00 sec)
mysql> set global max_allowed_packet=104857600;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like ‘max_allowed_packet’;
±-------------------±----------+
| Variable_name | Value |
±-------------------±----------+
| max_allowed_packet | 104857600 |
±-------------------±----------+
1 row in set (0.00 sec)
These are the other setting used in past testing with MySQL and how to set the below variables in percona?
[mysqld]
innodb_buffer_pool_size = 256M
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 32M
tmp_table_size = 32M
max_heap_table_size = 32M
max_connections = 500
thread_cache_size = 50
open_files_limit = 65535
table_definition_cache = 4096
table_open_cache = 512
max_connections = 300
max_allowed_packet = 100M
Thanks,
Dismi