+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: General Support Forum v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=36)
+---- Thread: Innodb Sentora question (/showthread.php?tid=2559)
Innodb Sentora question - PatrickA - 02-03-2016
I am some kind a newbie on this platform. I find a bug or probably an issue maybe someone can help me.
If I change my.cnf (MySql) an make some simple Innodb modifications for increase mysql performance, the Sentora Administration platform will stop to work properly. I can not change any previsions settings.
All php _POST or _GET interrogations scripts for change or insert in Sentora database will stop to work.
For developers put this in your mysql conf:
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 2G
innodb_data_file_path = ibdata1:10M:autoextend
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_force_recovery=1
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
Restart of course mysql and please try to make any modification on Sentora Panel.
Thank you and best regards,
Patrick
P.S. Sentora Platform 1.0.3, core 1.0.0 standard theme without any broken module.
RE: Innodb Sentora question - Me.B - 02-04-2016
Leave the defaults.
If you have performance issues like with wordpress better you enable plugins that would caches instead of messing up MySQL first.
Check the logs too what you changed.
did you add this values? From where you got them? Also do you have enough RAM? (innodb_buffer_pool_size = 2G).
RE: Innodb Sentora question - PatrickA - 02-13-2016
(02-04-2016, 09:45 PM)Me.B Wrote: Leave the defaults.
If you have performance issues like with wordpress better you enable plugins that would caches instead of messing up MySQL first.
Check the logs too what you changed.
did you add this values? From where you got them? Also do you have enough RAM? (innodb_buffer_pool_size = 2G).
Yeap I have enough RAM and I use pure php sites and in my case (sites) I use huge mysql databases. BTW: Even if I am WP developer I don't use CMS.
If you have a lot users probably you know that InnoDB has better performance than MyISAM.
Sincerly I like Sentora and I is solve some kind this issue by disabling innodb_force_recovery=1 and a lot of reseller modules.
You are a great team and thanks for your answer!