I would like to know if it is possible to find the row size of a MySQL table.
The challenge is we have 704 columns in the row. I know MySQL supports 65,535 bytes (MyISAM).
Please help me with the query or Perl script to find it.
Asked
Active
Viewed 60 times
1
-
5This kind of problem is sometimes symptomatic of poor design. – Strawberry Oct 12 '16 at 10:42
-
1This just has to be a database design mistake. – RiggsFolly Oct 12 '16 at 10:42
-
This will depend on a number of things and if you even have one variable lenght column on a row, each row will potentially be a different size – RiggsFolly Oct 12 '16 at 10:43
-
We have no other option now. The database created 15 years back. Please anyone help me to figure out the solution. – Vasanth Oct 12 '16 at 10:44
-
`select length(col1) + length(col2) + ...` – juergen d Oct 12 '16 at 10:44
-
2_The database created 15 years back_ Dont tell me the original designer is now the manager, right? – RiggsFolly Oct 12 '16 at 10:46
-
I am not sure who created it :) – Vasanth Oct 12 '16 at 10:49
-
2If I had a nickel... – Strawberry Oct 12 '16 at 10:49
-
@ThisSuitIsBlackNot I was confident. Just confused that I could hammer it. – simbabque Oct 12 '16 at 14:14
-
Why do you need to know this information? What are you going to do with the number once you have found it? Are you referring to to the maximum possible space occupied by all the fields in a record? Do you have any true varchar fields? – Borodin Oct 13 '16 at 11:50