1. event_scheduler 설정 확인
MariaDB [mysql]> show variables like'%event_scheduler%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.001 sec)
2. event_scheduler 를 ON 으로 설정
MariaDB [mysql]> set global event_scheduler = ON;
ERROR 1408 (HY000): Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
에러가 난다.
3. Mariadb 서버를 빠져나와 mysql_upgrade 를 실행
mysql_upgrade 파일은 /usr/bin 에 있다.
[root@localhost my.cnf.d]# whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
[root@localhost my.cnf.d]# cd /usr/bin
[root@localhost bin]# pwd
/usr/bin
[root@localhost bin]# ls mysql* -ls
4308 -rwxr-xr-x. 1 root root 4409824 Aug 10 2022 mysql
112 -rwxr-xr-x. 1 root root 111950 Aug 10 2022 mysqlaccess
3828 -rwxr-xr-x. 1 root root 3917696 Aug 10 2022 mysqladmin
4076 -rwxr-xr-x. 1 root root 4171992 Aug 10 2022 mysqlbinlog
3820 -rwxr-xr-x. 1 root root 3910760 Aug 10 2022 mysqlcheck
8 -rwxr-xr-x. 1 root root 4217 Aug 10 2022 mysql_convert_table_format
28 -rwxr-xr-x. 1 root root 27326 Aug 10 2022 mysqld_multi
32 -rwxr-xr-x. 1 root root 30778 Aug 10 2022 mysqld_safe
3464 -rwxr-xr-x. 1 root root 3543896 Aug 10 2022 mysqld_safe_helper
3920 -rwxr-xr-x. 1 root root 4010816 Aug 10 2022 mysqldump
12 -rwxr-xr-x. 1 root root 8242 Aug 10 2022 mysqldumpslow
20876 -rwxr-xr-x. 1 root root 21373048 Aug 10 2022 mysql_embedded
4 -rwxr-xr-x. 1 root root 3290 Aug 10 2022 mysql_find_rows
4 -rwxr-xr-x. 1 root root 1250 Aug 10 2022 mysql_fix_extensions
36 -rwxr-xr-x. 1 root root 34963 Aug 10 2022 mysqlhotcopy
3816 -rwxr-xr-x. 1 root root 3905592 Aug 10 2022 mysqlimport
20 -rwxr-xr-x. 1 root root 20092 Aug 10 2022 mysql_install_db
3504 -rwxr-xr-x. 1 root root 3587144 Aug 10 2022 mysql_plugin
16 -rwxr-xr-x. 1 root root 12527 Aug 10 2022 mysql_secure_installation
20 -rwxr-xr-x. 1 root root 17542 Aug 10 2022 mysql_setpermission
3812 -rwxr-xr-x. 1 root root 3899944 Aug 10 2022 mysqlshow
3832 -rwxr-xr-x. 1 root root 3923520 Aug 10 2022 mysqlslap
3500 -rwxr-xr-x. 1 root root 3582424 Aug 10 2022 mysql_tzinfo_to_sql
3596 -rwxr-xr-x. 1 root root 3678784 Aug 10 2022 mysql_upgrade
3492 -rwxr-xr-x. 1 root root 3573856 Aug 10 2022 mysql_waitpid
4. mysql_upgrade 를 수행해 본다.
[root@localhost bin]# ./mysql_upgrade
This installation of MariaDB is already upgraded to 10.11.8-MariaDB.
There is no need to run mysql_upgrade again for 10.11.8-MariaDB.
You can use --force if you still want to run mysql_upgrade
이미 업그레이드가 되어 있어서 할 필요가 없다 하므로 강제로 다시 시도한다.
[root@localhost bin]# ./mysql_upgrade -f
Phase 1/8: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.global_priv OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry OK
Phase 2/8: Installing used storage engines... Skipped
Phase 3/8: Running 'mysql_fix_privilege_tables'
Phase 4/8: Fixing views
...
중략
...
performance_schema
sys
sys.sys_config OK
test
Phase 7/8: uninstalling plugins
Phase 8/8: Running 'FLUSH PRIVILEGES'
OK
5. my.cnf 파일에도 추가한다.
[root@localhost bin]# vi /etc/my.cnf.d/server.cnf
[mysqld]
event_scheduler = on
6. Mariadb 서버를 재시작한다.
[root@localhost bin]# systemctl restart mariadb
7. Mariadb 서버에 접속하여 event_scheduler 설정상태를 확인해 본다.
MariaDB [mysql]> show variables like '%event_scheduler%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.001 sec)
MariaDB [mysql]>
event_scheduler 를 ON 으로 세팅한다.
MariaDB [mysql]> set global event_scheduler = ON;
Query OK, 0 rows affected (0.000 sec)
MariaDB [mysql]> show variables like '%event_scheduler%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
1 row in set (0.002 sec)
MariaDB [mysql]>
