Re: Changing table engine to innodb manually
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 ...
Subject
Views
Written By
Posted
597
January 14, 2021 07:45AM
299
January 14, 2021 12:08PM
Re: Changing table engine to innodb manually
281
January 14, 2021 09:07PM
296
January 14, 2021 11:29PM
246
January 15, 2021 12:35PM
305
January 15, 2021 03:50AM
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.