Re: Changing table engine to innodb manually

[Mohammad Mohammad]

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 ...