Compatability with Percona Server 8.0.36-28 #1
Description
Hi there,
Is it planned compatibility with Percona server ? I tried running the sql files on the above Percona server version and only create_user_and_db.sql was executed without errors .
mysql> \s
--------------
mysql Ver 8.0.36-28 for Linux on x86_64 (Percona Server (GPL), Release '28', Revision '47601f19'$)
Connection id: 24443
Current database:
Current user: admin@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.0.36-28 Percona Server (GPL), Release '28', Revision '47601f19'$
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb3
Db characterset: utf8mb3
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/lib/mysql/mysql.sock
Binary data as: Hexadecimal
Uptime: 1 day 3 hours 41 min 50 sec
Threads: 5 Questions: 1324244 Slow queries: 62 Opens: 890508 Flush tables: 7 Open tables: 4096 Queries per second avg: 13.280
--------------
mysql> \! ls -l /root/dbstat
total 76
-rw-r--r-- 1 root root 18092 Mar 15 11:26 LICENSE
-rw-r--r-- 1 root root 4041 Mar 15 11:26 README.md
-rw-r--r-- 1 root root 1076 Mar 15 11:26 create_global_status.sql
-rw-r--r-- 1 root root 1657 Mar 15 11:26 create_global_variables.sql
-rw-r--r-- 1 root root 2899 Mar 15 11:26 create_metadata_lock.sql
-rw-r--r-- 1 root root 1569 Mar 15 11:26 create_processlist.sql
-rw-r--r-- 1 root root 1617 Mar 15 11:26 create_table_size.sql
-rw-r--r-- 1 root root 2653 Mar 15 11:26 create_trx_and_lck.sql
-rw-r--r-- 1 root root 479 Mar 15 11:26 create_user_and_db.sql
-rw-r--r-- 1 root root 2307 Mar 15 11:26 query_global_status.sql
-rw-r--r-- 1 root root 236 Mar 15 11:26 query_global_variables.sql
-rw-r--r-- 1 root root 281 Mar 15 11:26 query_metadata_lock.sql
-rw-r--r-- 1 root root 986 Mar 15 11:26 query_processlist.sql
-rw-r--r-- 1 root root 1246 Mar 15 11:26 query_table_size.sql
-rw-r--r-- 1 root root 547 Mar 15 11:26 query_trx_and_lck.sql
mysql> source /root/dbstat/create_user_and_db.sql;
Query OK, 0 rows affected (0.02 sec)
Query OK, 1 row affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> use dbstat;
Database changed
mysql> source /root/dbstat/create_global_status.sql;
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EVENT gather_global_status
ON SCHEDULE EVERY 1 MINUTE
DO
BEGIN
INSERT INTO `gl' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EVENT purge_global_status
ON SCHEDULE EVERY 1 MINUTE
DO
BEGIN
DELETE FROM `glo' at line 1
mysql> source /root/dbstat/create_global_variables.sql;
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EVENT gather_global_variables
ON SCHEDULE EVERY 1 MINUTE
DO
BEGIN
DECLARE done' at line 1
mysql>
Obviously the create event part is not working correctly and the event is not created in the DB.
Please advise, thank you.