After webp2y swtich from mysql-python driver to pymysql , theres no error raised when a packet size is bigger. Below error is never raised: version 1.98.2 MySQL :: ERROR 1153: Got a packet bigger than 'max_allowed_packet .
And i am thinking about how to handle Larger than 1GB inserts coz max_allowed_packet size is 1GB only and I am soon going to encounter >1GB text extracts from archives. Anyone have idea? My guess is to do chunk updates if size(text_to_inserted) >= 1024*1024*1024 : db.execute(UPDATE table SET field = CONCAT( field, ' this is appended' ) WHERE id = 1;) is concat supported in DAL ?
