Re: ROW_SIZE or something alike

2005-03-17 Thread Marco Neves
oix ppl, Nobody have any sugestion that can me help with this issue? thanks mpneves On Wednesday 16 March 2005 14:09, Marco Neves wrote: oix ppl, sorry for the question, but I looked in the Manual online and didn't find nothing that do this that I'm looking for, so I'm hopping someone

Re: ROW_SIZE or something alike

2005-03-17 Thread gerald_clark
Marco Neves wrote: oix ppl, Nobody have any sugestion that can me help with this issue? thanks mpneves On Wednesday 16 March 2005 14:09, Marco Neves wrote: Look under storage requirements in the manual. You are MySQL core certified? oix ppl, sorry for the question, but I looked in the Manual

Re: ROW_SIZE or something alike

2005-03-17 Thread Keith Ivey
Marco Neves wrote: I'm looking for some way to know the size each row of a table uses in my database (phisical - real disk space allocated or logical - datasize ignoring compression and any control data, don't mind, anything is better than nothing). You might try using the Data_length and

Re: ROW_SIZE or something alike

2005-03-17 Thread Merlin, the Mage
oix ppl, thanks a lot for the answers, but if it was this simple I wouldn't ask... Yes, I am Core Certificate, and yes I did read the show-table-status page. BUT, that don't satisfy my needs. The sugestion to use data_length divided by the number of rows is good if all rows have a fixed

ROW_SIZE or something alike

2005-03-16 Thread Marco Neves
oix ppl, sorry for the question, but I looked in the Manual online and didn't find nothing that do this that I'm looking for, so I'm hopping someone can help me. I'm looking for some way to know the size each row of a table uses in my database (phisical - real disk space allocated or