Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6

[anand aundhekar]

Thanks Peter for reply.
I am getting all results as NULL or empty set. Please find below :

mysql> SELECT *
-> FROM performance_schema.memory_summary_global_by_event_name
-> WHERE EVENT_NAME LIKE 'memory/performance_schema/%';
Empty set (0.29 sec)

mysql> SELECT
-> Round( Sum( sum_number_of_bytes_alloc)/1024/1024/1024, 2 ) as 'GB Allocatwd',
-> Round( Sum( current_number_of_bytes_used) /1024/1024/1024, 2 ) As 'GB Used'
-> FROM performance_schema.memory_summary_global_by_event_name
-> WHERE EVENT_NAME LIKE 'memory/performance_schema/%';
+--------------+---------+
| GB Allocatwd | GB Used |
+--------------+---------+
| NULL | NULL |
+--------------+---------+
1 row in set (0.06 sec)

mysql> select * from sys.memory_global_total;
+-----------------+
| total_allocated |
+-----------------+
| NULL |
+-----------------+
1 row in set, 1 warning (0.34 sec)

mysql> select host, current_count_used ccu, current_allocated,
-> current_avg_alloc, current_max_alloc, total_allocated
-> from sys.memory_by_host_by_current_bytes
-> where host is not null;
Empty set (0.02 sec)


Now i started to restore a new table on server but again all inserts and updates get stuck of other tables for long time.
This is really weird behavior and surprising for me as restoring new table does not having any concern with other tables still all INSERTS, UPDATES stuck for other tables.