Also, I have a ~4 million row test table. Queries done with:
LIKE '%string'
are taking about 90 seconds on a seperate SQL node, but only 11 seconds on an SQL node on the same physical machine as one of two NDB nodes.
I turned on pushdown, hoping that the table scan over my 100mbit switch would be eliminated, but...
...the seperate SQL node now takes slightly MORE time to perform the query, as does the SQL node on the same physical machine.
It seems like the pushdown really isn't happening.
How can I speed up this query? considering I'm only retreiving about 30 rows out of 4 million after the where condition, shouldn't that be the only data sent over the wire?
Thanks!
mysql@31338.com