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
219
January 14, 2021 09:07PM


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.