MySQL Forums
Forum List  »  InnoDB

Re: Changing table engine to innodb manually
Posted by: Mohammad Mohammad
Date: January 14, 2021 09:07PM

Dear Peter,

Thanks for your reply. It seems the memory allocated to mysql server is very low although we have 24GB of server memroy:

+--------+---------+---------+---------+
| engine | data | indexes | total |
+--------+---------+---------+---------+
| MyISAM | 3.27 GB | 0.26 GB | 3.53 GB |
| InnoDB | 0.16 GB | 0.00 GB | 0.16 GB |
| Aria | 0.00 GB | 0.00 GB | 0.00 GB |
| CSV | 0.00 GB | 0.00 GB | 0.00 GB |
| MEMORY | 0.00 GB | 0.00 GB | 0.00 GB |
| TOTALS | 3.43 GB | 0.26 GB | 3.69 GB |


and,the innodb_buffer_pool_size=4GB;

What could be the safest changes to gain performance keeping the rollback plan??

1)should i increase memory allocation to MyIsam??

or

2) Changing all the tables engines to innodb to get better performance??


Thanks again ...

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Changing table engine to innodb manually
95
January 14, 2021 09:07PM


Sorry, only registered users may post in this forum.

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.