Consider using his plugin by default:
https://wordpress.org/plugins/index-wp-mysql-for-speed/
You only have to run it once, to create better indexing keys on the database tables, which in my eyes should be default in WordPress.
Unbelievable what I see in speed performance so far!
(Found this plugin actually by following the steps in this blog article for a client.)
But wait, there is more!
https://www.plumislandmedia.net/wordpress/performance/optimizing-wordpress-database-servers/
Sources: mostly here and not so much here.
Something about MySQL being swedish and having a default character set of latin1 and a collation of latin1_swedish_ci which is no good if you need to save utf8 data.
Continue reading How to Fix the Collation and Character Set of a MySQL DatabaseError Code: 1118
Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
See the possible solutions here:
https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/
Get your ‘create table’ sql code and add:
SET GLOBAL innodb_default_row_format='dynamic';Continue reading Row size too large (> 8126)
SET SESSION innodb_strict_mode=OFF;