-
I need some assistance with this Alex T⚜️ or Baloo
If I want to switch from MyISAM to InnoDB to help make my site faster, I understand the 1st part of adding
define('BX_DATABASE_ENGINE', 'INNODB'); ///< db engine
to my header.inc.php file but, where do I make the 2nd part of the changes?
Then the following server side settings for MySQL is needed in [mysqld] section:
innodb_stats_on_metadata = off innodb_buffer_pool_instances = 4 # number of CPUs
innodb_buffer_pool_size = 4096M # ~80% of available RAM
transaction_isolation = READ-COMMITTED lock_wait_timeout = 4 innodb_lock_wait_timeout = 4 innodb_rollback_on_timeout = 1 binlog_format = MIXED innodb_log_file_size = 400MJust for clarification, these settings will work with my existing MySQL database for my site right?
-
No, I have not tried yet, so I do not compare with Maria here. I was considering it, but as it works well now, I keep this solution for the next slowdown.
-
Chris you also need to convert your tables from MyISAM to InnoDB
-
Cem I didn't check/test AriaDB yet, but generally if AriaDB is new version of MyISAM then if you have no high concurrency then it should work definitely faster.