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
753
January 14, 2021 07:45AM
354
January 14, 2021 12:08PM
Re: Changing table engine to innodb manually
343
January 14, 2021 09:07PM
363
January 14, 2021 11:29PM
289
January 15, 2021 12:35PM
380
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.