Paging operation in MariaDB is usually handled using the LIMIT clause along with the OFFSET clause in a SQL statement. You can use it to restrict, or paginate, the number of records retrieved from the database.
Here is an example:
```
SELECT * FROM table
ORDER BY column
LIMIT 10 OFFSET 20;
```
This query will return 10 records, start on record 21 (OFFSET is 0-indexed, so OFFSET 20 is the 21st row).
In another words, this returns records (rows) 21-30.
If you use this in a pagination context, you could retrieve 10 records at a time, then adjust the OFFSET to retrieve the next or previous set.
In a real application, you’d replace the offset and limit number, probably with variables inside your application code, so you can dynamically adjust which section of the table to retrieve.