Using the IMDB data, I have loaded the actor and actress database into a few simple InnoDB tables and have performed the following test:
MariaDB [imdb]> show status like "Innodb_rows_read"; +------------------+---------+ | Variable_name | Value | +------------------+---------+ | Innodb_rows_read | 1237459 | +------------------+---------+ 1 row in set (0.00 sec)
MariaDB [imdb]> select x.*