Innodb Sentora question
#1
Innodb Sentora question
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.
Reply
#2
RE: Innodb Sentora question
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).
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask

200$ free to start your VPS 60 days credit
Reply
#3
RE: Innodb Sentora question
(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!
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Sentora cp steps 421darren 6 17 ,312 06-12-2025, 03:29 PM
Last Post: AnthonyDillard
Improving Security on Your Sentora Panel: Best Practices DylanForeman 0 455 05-27-2025, 06:10 PM
Last Post: DylanForeman
Is Sentora dead? rajeevrrs 2 5 ,684 12-17-2022, 09:20 AM
Last Post: TGates

Forum Jump:


Users browsing this thread: 1 Guest(s)