Comments on: 40 million tables in MySQL 8.0 with ZFS

By: Alexander Rubin

Alexander Rubin — Sat, 03 Nov 2018 15:11:50 +0000

In reply to ongres. Thank you! Yes, I looked at the presentation. Post published: https://www.percona.com/blog/2018/10/22/one-billion-tables-in-mysql-8-0-with-zfs/ Let me know if you will see any additional improvements we can do.

By: Alexander Rubin

Alexander Rubin — Thu, 25 Oct 2018 20:11:52 +0000

In reply to Nick Vyzas. ZFS on Linux

By: Alexander Rubin

Alexander Rubin — Fri, 28 Sep 2018 12:26:36 +0000

In reply to Laurent. Yes, I will try lz4 as well

By: Laurent

Laurent — Fri, 28 Sep 2018 12:25:06 +0000

Why using ZFS gzip compression in place of lz4, which is ways faster and still provide compression levels close to gzip ?

By: ongres

ongres — Wed, 12 Sep 2018 13:44:19 +0000

In reply to Alexander Rubin. That will be awesome! Please do that and let me know, I will be happy see that :) You might find in our initial presentation some hints which might apply to MySQL too :)

By: Alexander Rubin

Alexander Rubin — Tue, 11 Sep 2018 11:48:36 +0000

In reply to Alvaro Hernandez. Hi Alvaro, Challenge accepted :). I will attempt to create 1B tables in MySQL and share the results in a blog post. Alex

By: Eric

Eric — Mon, 10 Sep 2018 14:57:36 +0000

Nice post Alexander – We currently average around 15K databases per server (2.4MM tables per server) and earlier this year moved away from INNODB_FILE_PER_TABLE and created a General Tablespace per database (MySQL 5.7). Reducing the number of INNODB_OPEN_FILES helped us significantly as well…especially the MySQL startup times.

By: Nick Vyzas

Nick Vyzas — Fri, 07 Sep 2018 21:07:34 +0000

Is this FreeBSD, Solaris or ZFS on Linux?

By: Alvaro Hernandez

Alvaro Hernandez — Mon, 03 Sep 2018 23:15:50 +0000

It’s great that you are able to achieve 40M tables in MySQL!

Mind you that 5 years ago I created 1B first, and later 2B tables in PostgreSQL: https://www.pgcon.org/2013/schedule/events/595.en.html