curs = conn.cursor()
curs.execute('select x,y from TABLENAME')
data = numpy.array(curs.fetchall(), dtype=float)
print(time.time() - t)
Fastest way to load numeric data into python/pandas/numpy array from MySQL