Problem with apparently full table

[expired user #8093]'s profile image [expired user #8093] posted 10 years ago in General Permalink
I'm reviewing a table in mysql, and I realized that one of the tables in the size field mark my cell all in green, as if they were full. I'm having problems in that table that records are lost.

That will be the problem and how can I fix it?
ansgar's profile image ansgar posted 10 years ago Permalink
No, these tables are not full. It's just that they consume the largest hard disk space of all your tables. These green "progress bars" are relatvive to each other. "100%" is just the biggest table. That's just a cosmetic feature in HeidiSQL.

What do you mean with "records are lost"? How do you notice that?
TTSneko's profile image TTSneko posted 10 years ago Permalink
sergioaccc: "... records are lost"

I *assume* that you have checked your database for consistency and still mysteriously 'lose' entries.

Check the set key(s) of your database. These commonly 'control' the number of table entries. E.g. a numeric key that is defined as INT(4) can hold a maximum of four digits, meaning that the table can only hold up to 9999 entries. If your table exceeds that number, entries get dropped in favor of new additions to the table.
[expired user #8093]'s profile image [expired user #8093] posted 10 years ago Permalink
ANSGAR: Users indicated that they are losing me records that had already entered a long time ago now, and actually reviewing the table was cleared, what worries me is that they have reached the maximum capacity but strange because I had just spent 96 MB of space that basis data and that table in specific 14 mb, which is the largest and by that I mark the green progress bar according explained to me, but then not be the problem with that loss, would you recommend?
ansgar's profile image ansgar posted 10 years ago Permalink
I'm very unsure if I understand what you're saying. I'm guessing: You propose to make the green "progress bar" relative to the very maximum possible for tables in a database? If yes, I'm afraid that's not supported by most MySQL and PostgreSQL table engines. But probably I'm totally misunderstanding you.
[expired user #8093]'s profile image [expired user #8093] posted 10 years ago Permalink



Look at this picture, and I was clear that the green bar me which brand is the largest table, which is not because they have lost data randomly.

Perhaps the image you can see better understand how the database
ansgar's profile image ansgar posted 10 years ago Permalink
It would help if you write in whole sentences. Also I see no picture here?
[expired user #8093]'s profile image [expired user #8093] posted 10 years ago Permalink
Sorry, my writing is not good, first, I am assured that the green bar I only marks the largest table, now, do I to determine the reason for the loss of data already entered?

What steps can I take?
ansgar's profile image ansgar posted 10 years ago Permalink
Ok, so we forget bout the green bar now.

Data loss. TTSneko already wrote something probably very helpful above. Did you read that, man?

Please login to leave a reply, or register at first.