Comments on: One Billion Tables in MySQL 8.0 with ZFS https://www.percona.com/blog/one-billion-tables-in-mysql-8-0-with-zfs/ Wed, 07 Aug 2019 13:13:11 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: dobo https://www.percona.com/blog/one-billion-tables-in-mysql-8-0-with-zfs/#comment-10970960 Wed, 10 Jul 2019 06:28:05 +0000 https://www.percona.com/blog/?p=53315#comment-10970960 “MariaDB 10.0 is a stable (GA) release of MariaDB. It is built on the MariaDB 5.5 series with backported features from MySQL 5.6 and entirely new features not found anywhere else.” (from mariadb.org)

]]> By: Diego https://www.percona.com/blog/one-billion-tables-in-mysql-8-0-with-zfs/#comment-10969954 Wed, 14 Nov 2018 12:49:33 +0000 https://www.percona.com/blog/?p=53315#comment-10969954 I think MariaDB 10.x is not based on MySQL 5.x but it’s a new development (and not compatible with MySQL 5.x), but I don’t now if it still uses one FRM file per table.

]]> By: Alexander Rubin https://www.percona.com/blog/one-billion-tables-in-mysql-8-0-with-zfs/#comment-10969951 Tue, 13 Nov 2018 16:45:30 +0000 https://www.percona.com/blog/?p=53315#comment-10969951 MariaDB is based on MySQL 5.x, no new data dictionary, meaning that there is 1 FRM file per each table. I do not want to create 2 billion files… 🙂

]]> By: Diego https://www.percona.com/blog/one-billion-tables-in-mysql-8-0-with-zfs/#comment-10969950 Tue, 13 Nov 2018 13:54:59 +0000 https://www.percona.com/blog/?p=53315#comment-10969950 Next challenge: what about MariaDB 10? 😉

]]> By: Alexander Rubin https://www.percona.com/blog/one-billion-tables-in-mysql-8-0-with-zfs/#comment-10969899 Fri, 02 Nov 2018 21:15:16 +0000 https://www.percona.com/blog/?p=53315#comment-10969899 Ubuntu 18.04, I was not using the ebs, I was using the i3 instances with the local nvme cards.

]]> By: Heidi Schmidt https://www.percona.com/blog/one-billion-tables-in-mysql-8-0-with-zfs/#comment-10969889 Thu, 01 Nov 2018 13:30:03 +0000 https://www.percona.com/blog/?p=53315#comment-10969889 What OS did you use ZFS with and what was the default settings for io capacity with respect to EBS SSD? (If you wouldn’t mind posting the show global variables — it would be interesting to see.) Thanks!

]]> By: McFlew van Landed on ya feet https://www.percona.com/blog/one-billion-tables-in-mysql-8-0-with-zfs/#comment-10969866 Fri, 26 Oct 2018 09:31:23 +0000 https://www.percona.com/blog/?p=53315#comment-10969866 What a great lab/test/mythbuster case thanks for sharing all the specs and steps involved!

@Matt just rm -rf /var/lib/mysql/ that’s what you do with 1bi empty tables and then you reinstall mysql from scratch.

]]> By: Matt https://www.percona.com/blog/one-billion-tables-in-mysql-8-0-with-zfs/#comment-10969859 Wed, 24 Oct 2018 03:00:19 +0000 https://www.percona.com/blog/?p=53315#comment-10969859 Loved this post. Now what to do with those 1 billion empty tables?

]]> By: Alexander Rubin https://www.percona.com/blog/one-billion-tables-in-mysql-8-0-with-zfs/#comment-10969857 Tue, 23 Oct 2018 23:17:36 +0000 https://www.percona.com/blog/?p=53315#comment-10969857 Restart time for MySQL 8.0 with billion tables here (just FYI):

# time service mysql restart

real 11m16.531s
user 0m0.006s
sys 0m0.005s

Which is also significantly faster than MySQL 5.6/5.7

]]>