I am doing a query to several databases at the same time (can be between 1 to 150) asking for edit_count on the user table and I order them desc.
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, 'memory exhausted near \'UNION ALL SELECT "cawiki",user_editcount FROM cawiki_p.user WHERE user_name LIKE\' at line 1')
This is the message I am getting. I wonder if I can do anything with the code or with the limitation (increasing RAM?).
Every query is independent, so I don't need to keep any information. Maybe there is something to empty temporal space in python?
Thank you so much.