Row Size Limit in MySql

September 22, 2020

Solution

Export Data

delete databases

Take Site offline

add the following to the /usr/local/etc/my.cnf

innodb_file_per_table=1
innodb_file_format = Barracuda
innodb_page_size=32K

go to /usr/local/var/mysql

remove ibdata1, ib_logfile0, ib_logfile1

restart mysql

create databases

re-import data

Personal Updates

This is a password protected section available to those who know me in some fashion. If you know me and you do not already have a login, you can request a login here.

Personal Updates
Book Reviews

I am nuts about books. I read on all kinds of topics. I attempt to review each book I read for the sake of my own enrichment as well as conversation starters with others.

My Book Reviews
Pastoral Ministry

God has called me to be a pastor, and occasionally I have some pastoral thoughts I like to share.

Pastoral Posts
The Attic

You never know what you will find in an attic! Usually there is a hodgepodge of things buried under dust.

Explore the Attic
Technology

Most of what is included here are notes to myself. The majority of folks will not find interest in these posts.

Technology Posts