One Billion Tables in MySQL 8.0 with ZFS

The short version
I created > one billion InnoDB tables in MySQL 8.0 (tables, not rows) just for fun. Here is the proof:
MySQL
$ mysql -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1425329
Server version: 8.0.12 MySQL Community Server – GPL
Copyright (c) 2000, 2018, Oracle and/or its […]
Read more