Mozie

OK so my host told me the site runs on MyISAM.

Do you think I should should move over to InnoDB? Would it be better for searches if the database is very big?

And yes I will get the site on cloudflare with litespeed and additional security measures.

My host just replied about the database query and said this:

MyISAM performs just fine for database read operations, but when it comes to writing or updating data, the entire table is locked until the process is complete. This prevents any other read/write operations from starting in that table until that individual process is done. InnoDB only locks the single row being written to, freeing up the rest of the table for simultaneous operations.

Another big difference is the way both storage engines interact with memory on the server. There is a specific pool of Memory called the InnoDB Buffer Pool to be used by InnoDB tables. Tables which use MyISAM are not able to use this Memory pool, meaning they write to disk (swap) instead of using the database memory. Due to the above reasons Innodb should work faster than MyISAM.

Thanks to everyone for your answers. I really appreciate it.

I am currently with KnownHost on their best VPS with litespeed, they have been awesome so far to be honest. But their basic support was not able to answer these questions and I was requested to pay $35/hour to speak to “professional services dept”.

I don’t mind paying for help. But I just wanted to know if what I want to do is possible.

@catacaustic Thanks for that. That is something I’d need to look into. Is there any chance I could give you login so you can tell me how things are displayed?

I’m a total Noob when it comes to checking things like this.