fragmentation in innodb tables

2013-05-21 Thread Miguel González
Dear all, I'm a newbie in MySQL so bare my questions. I have run mysqltuner.pl and It says I have fragmentation in my tables. Searching around I found this script which reports the fragmentation in my tables: #!/bin/sh echo -n "MySQL username: " ; read username

RE: fragmentation in innodb tables

2013-05-21 Thread Rick James
The "fragmented" message is bogus. It says it to everyone. Almost no one needs to OPTIMIZE their tables. > -Original Message- > From: Miguel González [mailto:miguel_3_gonza...@yahoo.es] > Sent: Tuesday, May 21, 2013 2:03 PM > To: mysql@lists.mysql.com > Subject