Bug #28434 InnoDP Parameter tab accepts negativ / NaN values
Submitted: 15 May 2007 7:02 Modified: 19 Jun 2009 9:13
Reporter: Heinz Schweitzer (Gold Quality Contributor) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.12 OS:Windows (XP Pro SP2)
Assigned to: CPU Architecture:Any

[15 May 2007 7:02] Heinz Schweitzer
Description:
InnoDP Parameter tab accepts negativ / NaN values

Obviously there is no value check or something similar

MySQL Administrator 1.2.12
MySQL Server Information

--------------------------------------------------------------------------------
Mit MySQL-Serverinstanz verbunden
  Benutzername:            root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Serverinformation
  MySQL-Version:           MySQL 5.0.27-community-nt via TCP/IP
  Netzwerkname:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Clientinformation
  Version:                 MySQL Client Version 5.1.11
  Netzwerkname:            xxxxxxxxxxx
  IP:                      xxxxxxxxxxx
  Betriebssystem:          Windows XP
  Hardware:                2x Intel(R) Core(TM)2 CPU         T7200  @ 2.00GHz, 2.0 GB RAM

How to repeat:
Open German MySQL Administrator 1.2.12

in The left pane select 'Startvariable'
In the right pane activate the 'InnoDB Parameters' tab

For Bufferd Pool Size enter -80 M and for 
Zus.  aaaaaa K

see screen shot s1

Press the 'Anwenden' Button then
exit MA

Start German MySQL Administrator 1.2.12 again

in The left pane select 'Startvariable'
In the right pane activate the 'InnoDB Parameters' tab

The value for Bufferd Pool Size is mapped to 80 k
and for Zus to 0 k

see screen shot s2

Suggested fix:
Please have these error fixed.
[15 May 2007 7:03] Heinz Schweitzer
s1

Attachment: s1.jpg (image/pjpeg, text), 177.07 KiB.

[15 May 2007 7:03] Heinz Schweitzer
s2

Attachment: s2.jpg (image/pjpeg, text), 178.36 KiB.

[15 May 2007 9:44] Sveta Smirnova
Thank you for the report.

Verified as described.
[19 Jun 2009 9:13] Axel Schwenke
Many thanks for writing a bug report. We will not fix this in MySQL Administrator because this tool is end of life now. The designated successor of MySQL Administrator is MySQL Workbench and will take care of this (and many more) problems.

Please have a look at MySQL Workbench (http://dev.mysql.com/workbench/) and feel free to write a bug report if you miss functionality.