… at max approximately 3,000 tables per schema and perhaps 10,000 tables per mysqld instance. SchemaSpy does take some time…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc…-java.jar Example Schema CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE… CREATE TABLE `child_A` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… servers, and 384GB for Xeon E5-2600 servers, so sacrificing 10% ram for ZFS metadata is worthwhile.)
Comment: What Are Full, Incremental, and Differential Backups?
June 4, 2013 By 9 Comments
Im having the same issue with that project. i could really use some help right about now. its been wrecking my head for a while nw
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… see if you can accommodate with them (think of replication 10 years ago or partioning in 5.1 for instance).
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…@percona3 ~]# clustat Cluster Status for lefred_prm @ Thu May 23 10:20:36 2013 Member Status: Quorate Member Name ID Status…
Comment: ZFS on Linux and MySQL
May 29, 2013 By 17 Comments
… implementation has not yet been optimized for performance. As the project matures we can expect performance to improve.” http://zfsonlinux.org…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… various other flavors of suboptimal. On Wednesday, June 5, at 10 a.m. PDT (1700 UTC), I will be presenting a…
Comment: ZFS on Linux and MySQL
May 27, 2013 By 17 Comments
… zfsonlinux (latest) are benchmarked. c) Regarding integrity, XFS from 3.10 is going to have metadata checksums. d) What compression algo…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
You can replicate from MySQL 5.6 to MariaDB 10.0 or vice versa. You just won’t be able …
