Re: Amazing with MySQL 5.1.7

[David]

I've change as bellow:

mysql> optimize table member.user2;
+--------------+----------+----------+----------+
| Table        | Op       | Msg_type | Msg_text |
+--------------+----------+----------+----------+
| member.user2 | optimize | status   | OK       |
+--------------+----------+----------+----------+
1 row in set (4.20 sec)

mysql> select  
table_name,engine,round((data_length+index_length)/1024/1024,2) from  
information_schema.tables where table_name='user2';
+------------+------------+-----------------------------------------------+
| table_name | engine     | round((data_length+index_length)/1024/1024,2) |
+------------+------------+-----------------------------------------------+
| user2      | MyISAM     | 479.44                                        |
| user2      | NDBCLUSTER | 259.84                                        |
+------------+------------+-----------------------------------------------+
2 rows in set (0.01 sec)



-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/