the links here are useful and informative…
Comment: How to calculate a good InnoDB log file size
June 14, 2013 By 38 Comments
According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.
Post: Call for papers: Percona Live London
June 14, 2013 By Leave a Comment
… Millenium Gloucester Conference Center. Login or register as speaker and submit your proposals. Your participation is an opportunity to make a…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…: http://phptechnicalgroups.blogspot.co.il/2013/05/simple-mysql-and-php-prodcuts-and-cart.html create dynamic main menu and sub… using php and mysql php CREATE TABLE `menu` ( `id` int(11) NOT NULL auto_increment, `label` varchar(50) NOT NULL default ”, `link` varchar…, $level) { $result = mysql_query(“SELECT a.id, a.label, a.link, Deriv1.Count FROM `menu` a LEFT OUTER JOIN (SELECT parent…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… | grep 224 224.0.0.0/4 dev eth1 scope link In that space, we pick an unused mcast address (again…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It’s also designed to help…. I have included the metadata file I used to properly link child_A to parent table:
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can…
Comment: Is Synchronous Replication right for your app?
May 28, 2013 By 18 Comments
Jay – Yoshinori found one performance bug for semi-sync — http://bugs.mysql.com/bug.php?id=69341. Wonder if there are others.
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats…
Comment: Percona XtraBackup 2.1.2 for MySQL available for download
May 22, 2013 By 4 Comments
…-xtradb-cluster/10198-can-not-get-percona-xtradb-cluster-to-link-up-start-mysql-its-a-cluster-f). When I update…
