Re: SQL Update 2.6.0 -> 2.6.1, (DONE)

From: Andreas Schulze <sca_at_andreasschulze.de>
Date: Thu, 28 Jun 2012 14:39:37 +0200 (CEST)

I updated all databases. Notice the timimgs :-)

my test system:
> mysql> ALTER TABLE messages ADD KEY(msgtime);
> Query OK, 268 rows affected (0,11 sec)
> Records: 268 Duplicates: 0 Warnings: 0

my private system:
mysql> ALTER TABLE messages ADD KEY(msgtime);
Query OK, 5361 rows affected (0.76 sec)
Records: 5361 Duplicates: 0 Warnings: 0

my 'big' system:
mysql> ALTER TABLE messages ADD KEY(msgtime);
Query OK, 11858181 rows affected (18 min 3,48 sec)
Records: 11858181 Duplicates: 0 Warnings: 0

Andreas
Received on Thu Jun 28 2012 - 12:39:49 PST

This archive was generated by hypermail 2.3.0 : Mon Oct 29 2012 - 23:20:40 PST