Hi Ken,
You can actually use whatever storage backend you want, but I don’t think that there will be much of an efficiency advantage disabling InnoDB or BDB. MyISAM is the default for all stock installations but some apps explicitly specify a storage engine, like pERP requires InnoDB to function safely so don’t disable it if you use it.
Optimising tables once in a blue moon doesn’t hurt but its benefits are usually quite negligible unless you’re measuring queries in microseconds.
Optimising database efficiency is more of an art than a science, and usually performance tuning systems should be taken with a pinch of salt as they completely lack any awareness of the broader picture (the application level) and certain tweaks, under certain circumstances, can actually see you going backwards.
Backup, experiment and test.
Good luck,
WLD
Hi all
I have been working on tweaking the MySQL response time, and have seen improvement, thanks to Ralf.
I found a script that is supposed to examine the host and MySQL environment, and suggest changes. I am not familiar enough with the nuts & bolts, to know if the suggestions should be implemented in EGW. The report follows:
-------- Recommendations -----------------------------------------------------
General recommendations:
Add skip-innodb to MySQL configuration to disable InnoDB
Add skip-bdb to MySQL configuration to disable BDB
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Does EGW require InnoDB and BDB to be activated, or can I go ahead & disable?
thanks in advance
Ken
Live Security Virtual Conference
Exclusive live event will cover all the ways today’s security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
