How to read a large table with more than 522 million rows?

MySQL & MariaDB
1

I want to select the rows from the range x to y in a MyISAM table. The table description is

CREATE TABLE table_name (column_1 varchar(255) NOT NULL, column_2 varchar(255) NOT NULL, PRIMARY KEY (column_1,column_2)) ENGINE=MyISAM DEFAULT CHARSET=ascii;

For example, I need to select rows from 100000000 to 100001000. I tried using limit with offset but it became too slow after a certain number of rows. How can it be achieved? Could you guys please help?

2

Hello @Sri_Ram ,

Welcome to Percona and thanks for reaching out.

Can you share what exact query you are trying to execute ?