…+——————————+———–+ | Status | Duration | +——————————+———–+ | starting | 0.000060 | | checking permissions | 0.000003 | | checking permissions….mysql.com/bug.php…MySQL versions prior to 5.5: I remember a customer case where there is a reporting slave…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…We’re running a typical master-slave replication with ROW based binary …partition. The first step is clear, check which files are on that partition: #…MySQL can creates temporary files even thought those temporary files are not visible on the EXPLAIN or SHOW STATUS… issue: http://bugs.mysql.com/bug.php…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’… table on a separate computer, maybe a replication slave. Can you make the reorganization run in a …may be bug in the status or bug in implementation. I’ll check with Alexander or check myself to see …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…mysql> STOP SLAVE; we don’t want schema changes to be replicated to db1 now. 3. on db2: load the sql scripts $ mysql…just enter commands from cli, execute some php/python/ruby script or anything else. Most …@C1 set_online db1 Now you can check MMM status for the cluster – it should display db2…
