MySQL Forums
Forum List  »  Performance

Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6
Posted by: anand aundhekar
Date: February 06, 2020 01:14AM

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.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.