wow after 11 GB out uf 12 GB or so teh frist progress display with 0%
MariaDB [dbmail]> OPTIMIZE TABLE `dbmail_mimeparts`;
Stage: 1 of 1 'altering table' 0% of stage done
-rw-rw---- 1 mysql mysql 11G 30. Sep 21:56 #sql-ib3030-2883732087.ibd
Am 30.09.2017 um 21:43 schrieb Reindl Harald:
https://mariadb.com/kb/en/library/defragmenting-innodb-tablespaces/
seems to be silently broken in 10.2 or why is there a fat temp-file as
well as the progress display from previous versions don't work in
10.1/10.2 in a useable way (a pseudo progress for small tables is nice
but when you see no output at all when 'optimize table' is running on a
table with 10 GB it's broken)
"innodb-defragment = 1" is set
-rw-rw---- 1 mysql mysql 2,6G 2017-09-30 21:39 '#sql-ib3030-2883732087.ibd'
MariaDB [dbmail]> OPTIMIZE TABLE `dbmail_users`;
+---------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+---------------------+----------+----------+-------------------------------------------------------------------+
| dbmail.dbmail_users | optimize | note | Table does not support
optimize, doing recreate + analyze instead |
| dbmail.dbmail_users | optimize | status | OK
|
+---------------------+----------+----------+-------------------------------------------------------------------+
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
