Description:
mysqladmin does not iterate if -r is used in combination with -i

How to repeat:
The follows works correctly, doing an iteration every 10 seconds.
shell> mysqladmin -i 10 extended-status

The follows shows only one result, without doing any iteration.
shell> mysqladmin -i 10 -r extended-status

Suggested fix:
Honor the --relative/-r option

Thank you for the report.

I can not repeat described behavior. Please indicate accurate version of MySQL you use.

Probably this is same problem like in bug #37751

The MySQL version I tried is mysql-5.1.29-rc-linux-i686-glibc23.tar.gz

Thank you for the feedback.

Verified as described with mysql-5.1.29-rc-linux-i686-glibc23.tar.gz

Workaround: use self-compiled version

It must be broken between 5.1.26 and 5.1.28 (first work later not anymore)

Bug #44790 was marked as duplicate of this one.

Sorry Jorro, a mistake.

Confirmed on 5.1.34 also, source release

Thank you for taking the time to report a problem.  Unfortunately you are not using a
current version of the product you reported a problem with -- the problem might already be
fixed. Please download a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions, please change the
version on this bug report to the version you tested and change the status back to "Open".
 Again, thank you for your continued support of MySQL.

I've tried with both the latest 5.1-bk version and the 5.1.34-linux-x86_64 community
version (.tar.gz) and they were both bahving as expected with "-i 10 -r extended-status"

Georgi,

duplicate bug #44790 was verified using version 5.1.34. Also this is 32-bit issue, so it
is expected you can not repeat error with 64-bit binaries.

Output in my env:

$mysqladmin51 -i 10 -r extended-status
+-----------------------------------+----------+
| Variable_name                     | Value    |
+-----------------------------------+----------+
| Aborted_clients                   | 0        |
| Aborted_connects                  | 360      |
| Binlog_cache_disk_use             | 0        |
...
| Uptime                            | -711169274805027|
| Uptime_since_flush_status         | -143585  |
+-----------------------------------+----------+

/Users/apple/Applications/mysql-5.1/bin/mysqladmin: Unknown command: 'extended-status'

$mysqladmin51 -i 10 extended-status
+-----------------------------------+----------+
| Variable_name                     | Value    |
+-----------------------------------+----------+
| Aborted_clients                   | 0        |
| Aborted_connects                  | 362      |
| Binlog_cache_disk_use             | 0        |
...
| Uptime                            | 22049    |
| Uptime_since_flush_status         | 22049    |
+-----------------------------------+----------+

+-----------------------------------+----------+
| Variable_name                     | Value    |
+-----------------------------------+----------+
| Aborted_clients                   | 0        |
| Aborted_connects                  | 363      |
| Binlog_cache_disk_use             | 0        |
...

$mysqladmin51 --version
/Users/apple/Applications/mysql-5.1/bin/mysqladmin  Ver 8.42 Distrib 5.1.36, for
apple-darwin8.11.1 on i386

Verified also on mysql-5.4.0-beta-linux-x86_64-glibc23.tar.gz

64 bit.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/74429

2899 Jim Winstead	2009-05-18
      mysqladmin did not have enough space allocated for tracking all variables
      when using --vertical or --relative with extended-status. (Bug #40395)
      
        This patch simply increases the buffer size and adds an assert to
        check that it is big enough -- a more comprehensive fix would dynamically
        allocate the appropriate buffers.
      modified:
        client/mysqladmin.cc