As the title says my fresh installation of percona server is not reading my old /etc/my.cnf from mysql 5.5 .
I have tried to put the file also in /etc/mysql/my.cnf, /usr/etc/my.cnf and ~/.my.cnf, but still not being applied after restart percona server.
I check it using mysql > show variables like '%timeout%'; and values are always different from the ones i apply in my.cnf .
The default settings of percona server don't allow me to perform some heavy tasks in database in my development server, therefore i need to apply different settings.
mysql console output:
/etc/my.cnf
/etc/mysql/conf.d/mysqld_safe_syslog.cnf
I have tried to put the file also in /etc/mysql/my.cnf, /usr/etc/my.cnf and ~/.my.cnf, but still not being applied after restart percona server.
I check it using mysql > show variables like '%timeout%'; and values are always different from the ones i apply in my.cnf .
The default settings of percona server don't allow me to perform some heavy tasks in database in my development server, therefore i need to apply different settings.
mysql console output:
Code:
mysql> Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 544 Server version: 5.6.19-67.0 Percona Server (GPL), Release 67.0, Revision 618 Copyright (c) 2009-2014 Percona LLC and/or its affiliates Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. show variables like "%timeout%"; +-----------------------------+----------+ | Variable_name | Value | +-----------------------------+----------+ | connect_timeout | 10 | | delayed_insert_timeout | 300 | | have_statement_timeout | YES | | innodb_flush_log_at_timeout | 1 | | innodb_lock_wait_timeout | 50 | | innodb_rollback_on_timeout | OFF | | interactive_timeout | 50 | | lock_wait_timeout | 31536000 | | net_read_timeout | 30 | | net_write_timeout | 60 | | rpl_stop_slave_timeout | 31536000 | | slave_net_timeout | 3600 | | thread_pool_idle_timeout | 60 | | wait_timeout | 50 | +-----------------------------+----------+ 14 rows in set (0.00 sec)
/etc/my.cnf
Code:
[client] port=3306 socket=/var/run/mysqld/mysqld.sock [mysqld_safe] socket=/var/run/mysqld/mysqld.sock [mysqld] user=mysql pid-file=/var/run/mysqld/mysqld.pid socket=/var/run/mysqld/mysqld.sock port=3306 basedir=/usr datadir=/var/lib/mysql tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log max_connections=200 max_user_connections=30 wait_timeout=300 interactive_timeout=100 long_query_time=60 innodb_file_per_table !includedir /etc/mysql/conf.d
/etc/mysql/conf.d/mysqld_safe_syslog.cnf
Code:
[mysqld_safe] syslog
Comment