(This is somewhat a follow up on my last question)
I am using MySQL 5.5 with innodb.
My Log table consists of two columns. One for user number, and the other for a string consisting of IP, request method, request body, and so on. The two columns use no index.
Usually the content of the logs are below 200 letters. However, there are special cases that the content go up to more than 5000 words.
I've thought of three ways to log long contents. First is to split the content into 200 words and put it in several rows. Second is to set the data type to TEXT or VARCHAR(10000). Third is to make a new table only for storing long contents.
What is the normal approach to storing logs?