On Thu, June 9, 2011 11:59, Jerry Schwartz wrote:
>
>
>>
>>A single table is
always consistent. Data inconsistency occurs in sets of
>>interrelated tables, in other words, on the database level.
>>
> [JS] Not even a single table is always consistent
(unless there is
> transactions). Consider a
>
>A single table is always consistent. Data inconsistency occurs in sets of
>interrelated tables, in other words, on the database level.
>
[JS] Not even a single table is always consistent (unless there is
transactions). Consider a single transaction that consists of two steps:
1. Delete recor
Hi! Inline, again.
On Jun 9, 2011, at 4:58 AM, Johan De Meersman wrote:
> True, but I have never seen an application that checks for inconsistency in
> it's tables. Making sure all users have stopped using the app ensures no
> in-flight transactions, and then you have a consistent database - s
Hello people!
I'm developing a system that needs to find places around a point informed by
the user!
I have a lot of place in a db and all of them has the coordinates
information ( gotten by google maps api geocoding );
When I use mbrcontains to find all places into a polygon (circle with the
in
>> If that's all you did, you indeed 'removed the default NULL' but did not
>specify another default. Hence, if you don't explicitly specify a value in
>your
>insert statement, the insert can not happen as the server doesn't know what
>to
>put there and is explicitly disallowed from leaving the
- Original Message -
> From: "Karen Abgarian"
>
> This however means that the resulting snapshot will be consistent.
> The fact of taking a backup really cannot create more consistency
> than what the application has by design. If the application inserts
> related rows in say two relate
Hello, comments inline. Regards, Karen.
>
>
> I checked up in the mean time, and it does not make a truly consistent backup
> of MyISAM - it locks all tables - yes, ALL tables - and then copies the
> files. Given that MyISAM doesn't support transactions, that means that any
> "transactions" (
