Hello - I am getting a very long response time for posts to load and suspect it is a database issue with my site. I am not that technical and thus am trying to find a solution to this issue. I know that I am getting the notice from invision that

Some of your database tables are not using InnoDB.

Please contact your host to discuss how to convert your tables to InnoDB. InnoDB tables are recommended for v4 and required for v5.

When I reach out to my host they are saying it is out of their area and would require additional programming etc and something they are not typically set up to do. I was wondering if anyone on here did database work and if so could reach out to me as I need some assistance with this issue. Not sure if this is even the issue. Appreciate any feedback or assistance.

I would very much advise on looking at what hosting you are using there. INNODB is the setup of your database, and database tables storage engine, and does not in any way require additional programming. It is indeed likely one of the things causing database performance issues

Take a look here, which shows how to change tables to INNODB

https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html

However the basic command to change a table is

ALTER TABLE table_name ENGINE=InnoDB;

I would ask, have you considered our cloud solution, which would save you ever having to deal with things like this?

Indeed. Changing the table engine doesn't require any programming, and it's easy enough to do as long as you know what you're doing. 🙄

You also need to ensure the DYNAMIC row format is used instead of COMPACT, or there might be some index length issues.

In case your database does not have the option available, the hosting needs to enable it. But again, no extra programming is needed, it's just a matter of configuring properly the server.

Edited March 13Mar 13 by teraßyte
typo

Thank you both so much for the feedback. Yes it should be handled by my server but they are balking at it. I am planning on going to cloud as you suggest just trying my best to keep the site running whilest I make that transition happen. I will push back on them again however if there is anyone on here willing to help me for a fee please PM. thanks for listening.

 

Thank you both so much for the feedback. Yes it should be handled by my server but they are balking at it. I am planning on going to cloud as you suggest just trying my best to keep the site running whilest I make that transition happen. I will push back on them again however if there is anyone on here willing to help me for a fee please PM. thanks for listening.

Please feel free to reach out to our sales team if you wish to discuss a quick transition over to cloud.

I was helped and I thank the community for their support. Shout out to Terabyte for his expertise. This can now be closed. Thank you all!