… html after each run, so I find it convenient to set it up on crontab so that schema changes are automatically…_id) in the child and parent tables. Your environment may be like a lot of shops that we see, where the parent… doesn’t help SchemaSpy at all. This is where Metadata files come in to play Creating a Metadata File The format of…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could … schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE… data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…using GTID-based replication. That will show where GTIDs shine and where improvements are expected. This is … executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba:1, 3d3871d1-…is a solution of course, but very poor in my opinion: look for the binlog file/…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… a specific replication topology. However you should keep in mind some limitations of the current implementation. This …servers, but only if all servers have gtid_mode set to ON. Could it be interesting to run …to be able to mix servers where gtid_mode is ON with servers where gtid_mode is OFF. This …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…’ve seen situations where even under just a moderate load on the host system, DRBD can end up in a split-brain… replication filtering rules are processed. There are some informative flowcharts in addition to the textual explanation. Q: What is my recommendation… talking to the same set of data nodes on the back end, but I think that’s probably where the similarities end…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… about using a temporary table to store an interim result set, and then use that to ultimately produce the result you… returned in a different order from what you specify in the query? The tuple comparison you’re referring to is this example: WHERE… it would have to match the order of columns in the index. Example: WHERE (last_name, first_name) = (‘Karwin’, ‘Bill’); Q: On…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to … fixed #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform … (see MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… the wsrep_provider_options global variable. gcs.fc_limit This setting controls when flow control engages. Simply speaking, if the wsrep… certification index smaller in memory. It keeps the certification interval small, which minimizes replication conflicts on a cluster where writes happen on…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… obscure limitations from the 1980s alive in the 21st century and instead wanted a modular system where the storage engines themselves owned… MySQL, with MySQL 1.0 being released in 1995. The FoRM file specified what fields where on what screen for entering, as…)+2) (bytes) + length of all comments (in bytes) + length of all intervals (for ENUM, SET) in bytes. If you use that as a…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… this table with a statement like this: UPDATE achievements SET count = count + 1 where achievement = ‘killed_troll’; How many players might accomplish… SET last_joined=NOW(), last_user_id=100 WHERE id=1; COMMIT; How often might multiple users join the same group? Results In… == 0 ) { $db->do( “UPDATE achievements SET count = $last_count where achievement = ‘killed_troll’”; } change your schema In Example 2, above, how above moving…
