Re: munin MyISAM & InnoDB issues
> 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 ' main tablespace>'\G
>
> Look at the "Data_free: " line, it is probably bigger than 2^31.
Actually it's zero. Is that a problem?
- Grant
>> 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 TypeWarnCritInfo
>> Bytes free freegauge 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?
>>
>> - Grant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
RE: How do I select all rows of table that have some rows in another table (AND, not OR)
2013/06/13 23:08 +, Rick James
FIND_IN_SET might work the cleanest...
WHERE FIND_IN_SET('action', genres) OR/AND [NOT] ...
And have genres look like 'action,drama,foobar', that is comma-separators, and
no need for leading/trailing comma.
That would also work for genres = '1,3,10,19,38' and FIND_IN_SET('19', genres)
And you seem no fan of named BITs (SET), either. *sigh*
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
