1 Topic by kpty

  • kpty
  • Junior Member
  • Offline
  • Registered: 2006-06-15
  • Posts: 3

Topic: mySQL space usage enquiries

Hi

i recongnise that in one of the table name "online", the data space is accounted to 1,018 KB even though the table contain only the online user data.

Can anybody explain why Space usage just for this section is huge as compare to the rest of the table.

I am hosting in a free plan and i am only given 10MB to play with. I need to know what the space usage is huge

Below is my Statistics.

Space usage:   
Type Usage
Data 1,018 KB
Index 61,008 Bytes
Overhead 209 Bytes
Effective 1,078 KB
Total 1,078 KB

Row Statistics:   
Statements Value
Format dynamic 
Collation latin1_swedish_ci 
Rows 1 
Row length ø 209 
Row size  ø 1,077.8 KB

  • quaker
  • quaker
  • Senior Member
  • Offline
  • From: USA
  • Registered: 2006-02-22
  • Posts: 1,783

Re: mySQL space usage enquiries

link?

My stuff or my style might sux, but atleast I'm willing to help when I can.
Don't be stupid and help ! We are the stupid one's !!!

quaker's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: mySQL space usage enquiries

The online table is of a type called HEAP. This means it's never written to disk, it only stays in memory. So, you need not worry about the space.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

4 Reply by kpty

  • kpty
  • Junior Member
  • Offline
  • Registered: 2006-06-15
  • Posts: 3

Re: mySQL space usage enquiries

Thanks Rickard.

If this stay in memory, how come phpmyadmin actually view it as Space usage? The free plan account actually say I have use up Total 1,078 KB, where in actual fact, it is less than 5kb. Just curious.

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: mySQL space usage enquiries

kpty wrote:

If this stay in memory, how come phpmyadmin actually view it as Space usage?

Good question. I have no idea.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website