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
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 'any innodb table that was created in the 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
