I have a classic node with couple of m2o in it (but no child node/s). It had been working fine. Off late the data in the node table and m2o tables has grown a lot .... node table has now a almost million rows. A strange behaviour is observed .... on clicking menu on all-rows (admin) screen. Count of rows at the paginator are shown correctly but actual data ie rows are not shown .... the grid is empty .... on searching something on the empty grid then those rows are shown!!!

On stop/start mysql ..... it works fine for couple of of hours/days and again this behaviour starts.

As i understand it may something to do with mysql/memory. But then even count(*) query should NOT have worked.

Any clue?

Could also be the caching of the templates which sometimes give strange empty adminlists.

ok tks oblygre - what is the remedy any clue?