Re: Integrity on large sites

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/23/07 12:48, PFC wrote:
>
>> Some big sites do of course juggle performance vs in-database run-time
>> checks, but the statements as typically presented by MySQL partisans,
>
> Live from the front :
>
> This freshly created database has had to endure a multithreaded
> query assault for about 2 hours.
> It gave up.
>
> TABLE `posts` (
> `post_id` int(11) NOT NULL auto_increment,
> `topic_id` int(11) NOT NULL,
> etc...
>
> mysql> SELECT max(post_id) FROM posts;
> +--------------+
> | max(post_id) |
> +--------------+
> | 591257 |
> +--------------+
>
> mysql> INSERT INTO posts (topic_id,post_text,user_id) VALUES (1,'DIE
> BASTARD',666);
> ERROR 1062 (23000): Duplicate entry '591257' for key 1
>
> mysql> CHECK TABLE posts;
> +-------------------+-------+----------+-----------------------------+
> | Table | Op | Msg_type | Msg_text |
> +-------------------+-------+----------+-----------------------------+
> | forum_bench.posts | check | warning | Table is marked as crashed |
> | forum_bench.posts | check | error | Found 588137 keys of 588135 |
> | forum_bench.posts | check | error | Corrupt |
> +-------------------+-------+----------+-----------------------------+
>
> mysql> REPAIR TABLE posts;
> +-------------------+--------+----------+----------+
> | Table | Op | Msg_type | Msg_text |
> +-------------------+--------+----------+----------+
> | forum_bench.posts | repair | status | OK |
> +-------------------+--------+----------+----------+
>
> mysql> INSERT INTO posts (topic_id,post_text,user_id) VALUES (1,'DIE
> BASTARD',666);
> Query OK, 1 row affected, 1 warning (0.10 sec)
>
> mysql> SHOW WARNINGS;
> +---------+------+------------------------------------------------+
> | Level | Code | Message |
> +---------+------+------------------------------------------------+
> | Warning | 1364 | Field 'post_time' doesn't have a default value |
> +---------+------+------------------------------------------------+

What version of that pathetic RDBMS is this?

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGVLLGS9HxQb37XmcRAgpiAJ4nHpdGXL5HFdosWvkIy16CEyXiSwCgjqtB
qYgCmePqgZkGCpdJ/JAFLoE=
=P7OR
-----END PGP SIGNATURE-----