The data-integrity tag has no wiki summary.
3
votes
1answer
31 views
How can I enforce data integrity in this model with a M:2 relationship?
This model describes a part of my database (somewhat simplified):
A "Tumor model" describes an experiment a researcher does on animals. The "Animal line" is a breed of lab animals, e.g. a Black 6 ...
0
votes
0answers
25 views
Defacto way of fixing constraint issues without downtime?
I come across two constraint issues all the time (UNIQUE, and referential integrity constraints) within InnoDB. My question is when these issues arise reproducibly what is typically the solution? I'm ...
2
votes
1answer
104 views
How do I ensure consistent MySQL backups?
How can we ensure MySQL backups are consistent when they are taken as full backups as well as incremental backups using binlogs?
According to me, I record the COUNT(*) from random tables after ...
1
vote
1answer
113 views
Is SET INTEGRITY of any use after IMPORT statements, or just after LOAD statements?
I'm getting the feeling, both from documentation and empirically, that you can only put SET INTEGRITY to good use after a LOAD, not after an IMPORT. LOAD is mentioned for SET INTEGRITY, but not ...
1
vote
0answers
76 views
MySQL: Fixing Unique key constraint violation
I have a database with an unique key constraint.
When I import this database from a dump created by mysqldump I get
'14698-3' for key 'UNQ_CATALOGS EARCH_FULLTEXT_PRODUCT_ID_STORE_ID'
But when I ...
2
votes
1answer
123 views
Reformatting master MySQL server and temporary solution
We have MySQL master and replication servers both running on different machines. We have noticed some system files showing integrity issues in the master machine. Temporarily we would like to make the ...
8
votes
2answers
239 views
Modelling constraints on subset aggregates?
This is a cross-post from Stack Overflow. I figured I might get more interesting thoughts here. I am using PostgreSQL but I figure most of the top-end db's must have some similar capabilities, and ...
2
votes
1answer
358 views
How do you verify that all InnoDB tables are in good shape?
Without using a script, Is there a way to get mysql to check all the tables at once to make sure they're not corrupted?
8
votes
1answer
198 views
What is the actual lowest possible positive REAL number
MSDN says that the range of REAL numbers is - 3.40E + 38 to -1.18E - 38, 0 and 1.18E - 38 to 3.40E + 38. Apparently the true lower limit is much lower. The following script populates a REAL column ...
