Hello, I have just installed a 8 website on a shared host. Everything went fine and is working fine, but when I try to activate a new Drupal 10 module, I get this error Drupal 10 Maintenance and Support Service The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodblog_file_size. Complete error is more like Drupal 10 Maintenance and Support Service CoreDatabaseDatabaseExceptionWrapper Drupal 10 Maintenance and Support Service SQLSTATE[42000] Drupal 10 Maintenance and Support Service Syntax error or access violation Drupal 10 Maintenance and Support Service 1118 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. Drupal 10 Maintenance and Support Service INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES ( Drupal 10 Maintenance and Support Servicedb_insert_placeholder_0, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_1, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_2, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_3, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_4, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_5, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_6, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_7, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_8, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_9); Array ( [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_0] => 1 [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_1] => php [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_2] => %type Drupal 10 Maintenance and Support Service @message in %function (line %line of %file). [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_3] => a Drupal 10 Maintenance and Support Service6 Drupal 10 Maintenance and Support Service{s Drupal 10 Maintenance and Support Service5 Drupal 10 Maintenance and Support Service”%type”;s Drupal 10 Maintenance and Support Service45 Drupal 10 Maintenance and Support Service”CoreDatabaseDatabaseExceptionWrapper”;s Drupal 10 Maintenance and Support Service8 Drupal 10 Maintenance and Support Service”@message”;s Drupal 10 Maintenance and Support Service1344878 Drupal 10 Maintenance and Support Service”SQLSTATE[42000] Drupal 10 Maintenance and Support Service Syntax error or access violation Drupal 10 Maintenance and Support Service 1118 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. Drupal 10 Maintenance and Support Service INSERT INTO {batch} (bid, timestamp, token, batch) VALUES [and a lot more text] After some research, it seems that MySQL 5.6 introduced a redo log BLOB write limit (https Drupal 10 Maintenance and Support Service//stackoverflow.com/questions/25277452/how-to-configure-mysql-5-6-…) who generate the error. I could just in fact increase the inno_db_log_file_size, but I can’t on a shared host. And its making the website completely unusable. I have other 8 website running perfectly on the same hosting service but with MySQL 5.5. I have asked to revert the database to that version and waiting for a reply. But surely, somethning can be done on the side ? Thanks for your help ! version Drupal 10 Maintenance and Support Service 8.x Source Drupal 10 Maintenance and Support Service https Drupal 10 Maintenance and Support Service//www.Drupal 10.org/taxonomy/term/22/feed Source Drupal 10 Maintenance and Support Service Drupal 10 blender
8, shared host, MySQL 5.6 and innodblog_file_size error
Call Us: 1(800)730-2416
Pixeldust is a 20-year-old web development agency specializing in Drupal and WordPress and working with clients all over the country. With our best in class capabilities, we work with small businesses and fortune 500 companies alike. Give us a call at 1(800)730-2416 and let’s talk about your project.
FREE Drupal SEO Audit
Test your site below to see which issues need to be fixed. We will fix them and optimize your Drupal site 100% for Google and Bing. (Allow 30-60 seconds to gather data.)
8, shared host, MySQL 5.6 and innodblog_file_size error
On-Site Drupal SEO Master Setup
We make sure your site is 100% optimized (and stays that way) for the best SEO results.
With Pixeldust On-site (or On-page) SEO we make changes to your site’s structure and performance to make it easier for search engines to see and understand your site’s content. Search engines use algorithms to rank sites by degrees of relevance. Our on-site optimization ensures your site is configured to provide information in a way that meets Google and Bing standards for optimal indexing.
This service includes:
- Pathauto install and configuration for SEO-friendly URLs.
- Meta Tags install and configuration with dynamic tokens for meta titles and descriptions for all content types.
- Install and fix all issues on the SEO checklist module.
- Install and configure XML sitemap module and submit sitemaps.
- Install and configure Google Analytics Module.
- Install and configure Yoast.
- Install and configure the Advanced Aggregation module to improve performance by minifying and merging CSS and JS.
- Install and configure Schema.org Metatag.
- Configure robots.txt.
- Google Search Console setup snd configuration.
- Find & Fix H1 tags.
- Find and fix duplicate/missing meta descriptions.
- Find and fix duplicate title tags.
- Improve title, meta tags, and site descriptions.
- Optimize images for better search engine optimization. Automate where possible.
- Find and fix the missing alt and title tag for all images. Automate where possible.
- The project takes 1 week to complete.
