Re: SQL Update 2.6.0 -> 2.6.1, (DONE)
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