MariaDB [yii2advanced]> select min(id) from scan order by id desc limit 1000000;
+---------+
| min(id) |
+---------+
| 25694 |
+---------+
1 row in set (7.372 sec)MariaDB [yii2advanced]> DESCRIBE select * from scan limit 1;
+------+-------------+-------+------+---------------+------+---------+------+----------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------+------+---------------+------+---------+------+----------+-------+
| 1 | SIMPLE | scan | ALL | NULL | NULL | NULL | NULL | 13460011 | |
+------+-------------+-------+------+---------------+------+---------+------+----------+-------+Jul 1 09:02:17 vmi319265 systemd-resolved[396]: Server returned error NXDOMAIN, mitigating potential DNS violation DVE-2018-0001, retrying tying transaction with reduced feature level UDP2020-07-01 9:02:14 140444876401792 [Note] InnoDB: Using Linux native AIO
2020-07-01 9:02:14 140444876401792 [Note] InnoDB: Using SSE crc32 instructions
2020-07-01 9:02:14 140444876401792 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2020-07-01 9:02:14 140444876401792 [Note] InnoDB: Completed initialization of buffer pool
2020-07-01 9:02:14 140444876401792 [Note] InnoDB: Highest supported file format is Barracuda.
2020-07-01 9:02:14 140444876401792 [Note] InnoDB: 128 rollback segment(s) are active.
2020-07-01 9:02:14 140444876401792 [Note] InnoDB: Waiting for purge to start
2020-07-01 9:02:14 140444876401792 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 73770213$
2020-07-01 9:02:14 140444876401792 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-01 9:02:14 140442079295232 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-07-01 9:02:14 140444876401792 [Note] Server socket created on IP: '0.0.0.0'.
2020-07-01 9:02:14 140444876401792 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.44-MariaDB-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Ubuntu 18.04
2020-07-01 9:02:17 140444875769600 [Warning] Host name 'mail.stargate-legacy.net' could not be resolved: Name or service not known
2020-07-01 9:02:17 140444875564800 [Warning] Host name 'mail.stargate-legacy.net' could not be resolved: Name or service not known
