Contents
How to optimize MySQL for Drupal hosting?
Here are some basic, but high impact ways to optimize MySQL for Drupal (there are much more sophisticated and expensive ways to speed up your database of course): Note that if you are on a shared hosting plan then only your host will be able to tune MySQL since you won’t have access to the my.cnf file.
What can I use to optimize MySQL database server?
You can use the DB Maintenance module or use the mysqlcheck commands below in a cronjob. If you have complete control of the database server you can use: MySQL supports many different engine types including Archive (MySQL 5+), MyISAM, and InnoDB.
How to improve site performance with MySQL 5.7?
In sites running MySQL 5.7.1 or older, if a query is called at least twice with no modifications to the queried tables a significant performance improvement may be gained by avoiding the processing of the query and the execution of the query by reading the query from the MySQL query cache.
Why do I need to turn on caching in Drupal?
One of those options is to turn on caching for blocks and pages that you create using the Views module. This allows you to cache the output of the query used to generate the view, or the end HTML output of your View, and you can tune the cache for them separately.
Which is the best MySQL server for site performance?
Performance sites should use InnoDB for most tables particularly tables such as node that get a lot of writes and reads. MyISAM exclusive table locks for updates before selects versus InnoDB’s row level locking can mean MyISAM blocks reads if there are many writes.
How to increase redo log size in Drupal 8?
I have just installed a Drupal 8 website on a shared host. Everything went fine and is working fine, but when I try to activate a new module, I get this error : The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb log_file_size.