Avatar of David Smithstein
David Smithstein
Flag for United States of America

asked on 

MySQL Row Formatting Recommendations

Does anyone understand MySQL row formatting enough to makes some recommendations for best performance?  

There are about 401 tables, and the vast majority mostly contain 10-40 fields comprising of varchar, longtext, datetime, timestamp, int, and tinyint fields.  The exception is about 3 or 4 tables that also contain BLOB data fields holding document file types. .doc, docx, .pdf. .xlsx, etc.   The data being entered is consistent with what would be otherwise entered on a business form for a quality management system, or in a material management database.  Most of the databases are version 5.7, although we are in the process of upgrading everyone to MySQL 8.0

Is there a default row format I should be using that is likely to give me the best performance?  And what circumstances might make an exception to that default setting?
DatabasesMySQL Server

Avatar of undefined
Last Comment
David Favor

8/22/2022 - Mon