distal-attribute
distal-attribute
distal-attribute
distal-attribute

Problem with apparently full table

sergioaccc posted 5 months ago in General
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 posted 5 months ago
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 posted 5 months ago
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.
sergioaccc posted 5 months ago
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 posted 5 months ago
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.
sergioaccc posted 5 months ago



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 posted 5 months ago
It would help if you write in whole sentences. Also I see no picture here?
sergioaccc posted 5 months ago
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 posted 5 months ago
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.