Not the answer you need?
Register and ask your own question!

How to set variables in perconamysql

dismipaul@fico.com[email protected] EntrantInactive User Role Beginner
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

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.