我有一个巨大的表，我需要处理其中的所有行。我总是收到此“丢失的连接”消息，并且无法重新连接并将光标恢复到原来的位置。这基本上是我在这里的代码：

import MySQLdb

class DB: conn = None

def connect(self): self.conn = MySQLdb.connect('hostname', 'user', '*****', 'some_table', cursorclass=MySQLdb.cursors.SSCursor)

def query(self, sql): try: cursor = self.conn.cursor() cursor.execute(sql) except (AttributeError, MySQLdb.OperationalError): self.connect() cursor = self.conn.cursor() cursor.execute(sql) return cursor

db = DB() sql = "SELECT bla FROM foo" data = db.query(sql)

for row in data: do_something(row)

但是我总是这样：

Traceback (most recent call last): File "teste.py", line 124, in run() File "teste.py", line 109, in run for row in data: File "/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py", line 417, in next row = self.fetchone() File "/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py", line 388, in fetchone r = self._fetch_row(1) File "/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py", line 285, in _fetch_row return self._result.fetch_row(size, self._fetch_type) _mysql_exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query') Exception _mysql_exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query') in <bound method SSCursor. del of <MySQLdb.cursors.SSCursor object at 0x7f7e3c8da410>> ignored

你有什么主意吗？