MyISAM or InnoDB? What is the ideal configuration for optimal performance?

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Locked
marvado

MyISAM or InnoDB? What is the ideal configuration for optimal performance?

Post by marvado »

Hi,

What is the ideal configuration for optimal performance? MyISAM or InnoDB? My site has reasonably low load and not many pages (under 20). It just seems a little slow. How can I speed it up?
I already posted another topic for a way to export pages to flat .php files (http://forum.cmsmadesimple.org/index.ph ... 938.0.html), without answers yet.

Appreciate any input
thanks,
-Pedro
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm

Re: MyISAM or InnoDB? What is the ideal configuration for optimal performance?

Post by calguy1000 »

well, you could configure the mysql cache, that would help considerably.  enable some compression on output in your php.ini or apache configuration (both have their drawbacks though).

just some ideas.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
cyberman

Re: MyISAM or InnoDB? What is the ideal configuration for optimal performance?

Post by cyberman »

1. Use the last stable CMSms version.
2. Activate caching for all pages.
3. Delete all unused modules and tags. Be sure they are really unused.
4. Include your stylesheet from external source with a link.
5. Ask your provider about server resources (processor, ram, how many sites works on server). Perhaps it will be better to change  ;D ...

Also just some ideas ...
Locked

Return to “CMSMS Core”