top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration
Print Preview

munin MyISAM & InnoDB issues

0 votes
198 views

I have 4 out of 6 mysql graphs working in munin. "MySQL isam/myisam table-space usage" is a broken image and "MySQL InnoDB free tablespace" says:

"This service is in CRITICAL state because one of the values reported is outside the allowed range.
Field Internal name Type Warn Crit Info Bytes free free gauge 2147483648: 1073741824:"

I don't know enough about mysql (or munin) to figure out what's going on. I'm using both MyISAM and InnoDB tables. Can anyone help me out?

posted Jun 16, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button
I should add that I get the following:

    # munin-run mysql_isam_space_
    # munin-run mysql_innodb

free.value 0

1 Answer

+1 vote

I seem to understand this is the check on the innodb main tablespace.

Sounds like an overflow in munin check that builds the graph, due to the type of check ("MySQL InnoDB free tablespace") I would not mind too much(There's no such critical thing like too much free space!),
apart from patching the munin check to deal with numbers > 2^32.

To double check, look at:

mysql> SHOW TABLE STATUS LIKE ''G

Look at the "Data_free: " line, it is probably bigger than 2^31.

In this case it is basically not a problem, apart from Munin not able to represent that number.

For "MySQL isam/myisam table-space usage" broken image I have no idea on how that check is built,
moreover MyISAM does not have a real tablespace.
If it makes you feel better in http://demo.munin.jp/munin2/mysql-day.html that is broken too ;)

answer Jun 16, 2013 by anonymous
Similar Questions
0 votes

any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE command. the space on the hard drive gone down from 165 Gig to 70 Gig. I understand that during repair process MySQL creates temp file and remove it after the job done. Or removal process executes on the server restart? how can I get that space back? I can't check the table directory as I don't have root perm on that box.

+1 vote

I was trying to optimize the InnoDB tables. I have executed the next query to detect what are the fragmented tables.

SELECT TABLE_SCHEMA,TABLE_NAME
FROM TABLES WHERE TABLE_SCHEMA NOT IN ("information_schema","mysql") AND Data_free > 0

After that, I have seen that there are 49 fragmented tables. With one table, I have executed "optimize table table_name;" and "analyze table table_name;". The result is the same, the table continuous fragmented.

Any suggestions? I have followed the mysqltuner recommendations...

+1 vote

I have in my server database some tables that are too much big and produce some slow query, even with correct indexes created.

For my application, it's necessary to have all the data because we make an authentication process with RADIUS users (AAA protocol) to determine if one user can or not navigate in Internet (Depending on the time of all his sessions).

So, with 8GB of data in one table, what are your advises to follow? Fragmentation and sharing discarded because we are working with disk arrays, so not apply. Another option is to delete rows, but in this case, I
can't. For the other hand, maybe the only possible solution is increase the resources (RAM).

Any suggestions?


Useful Links with Similar Problem
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#470/147, 3rd Floor, 5th Main,
HSR Layout Sector 7,
Bangalore - 560102,
Karnataka INDIA.
QUERY HOME
...