How to set variables in perconamysql

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

Percona Server can use the same my.cnf file you’ve been using for Oracle MySQL Server, put your my.cnf on the default location (eg /etc/) and restart Percona Server and it should use the configs on your my.cnf.