… how to change the replication topology when using GTID-based replication. That will show where GTIDs shine and where improvements are…and use mysqlbinlog with the good old –start-position option! Even with GTIDs, you cannot totally forget old-style replication positioning. Conclusion Reconfiguring…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… to see which tables are referenced the most, and which are candidates for dropping (why keep old data if you don’t need to… is explicit. This has an impact on how SchemaSpy identifies the relationship, and whether you need to provide a hint or not… to automate SchemaSpy via crontab once you‘re done. What are some ERD tools you use and how do they compare with SchemaSpy? Feel…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 20, 2013 By 13 Comments
…” with the software (OS and compilers); no option. You paid lots for a service contract (vaccuum tubes… maybe the ’90s. (Think Netscape.) We are now re-raising those old questions about business practices, in yet…the future.” It will be interesting to see how this plays out. I think it will work. …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…structure from .frm files or take it from some old backup. A new tool sys_parser can recover …it would make sense it is still zero. If you know how InnoDB uses `PREC` please let me know. mysql>… KEY (`actor_id`) ) ENGINE=InnoDB; In the end there are two notes: The generated structure differs from the …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…the promoted slave is permanently disconnected from its old master. If not, it may get …shoot yourself in the foot if you use it incorrectly. So how do you safely disconnect a replication slave?…expected without any additional tricks. As soon as you are aware of the difference between RESET SLAVE and…
Post: Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
March 21, 2013 By Leave a Comment
… MariaDB are continuing to mature. For this year’s conference I am going to give a tutorial titled, “Percona XtraBackup: Old and… — in the conference center halls and behind the curtains. If you are lucky you can grab engineers from Facebook, Twitter, Google, Box, Esty… MySQL will be, and how we, with Percona Server, are going to beat MySQL in performance. And you can actually go and ask…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
… slave with a 24-hour old backup, and apply the binary logs continuously until it catches up, you will be waiting almost…” capacity, 19h48m/4h12m = 4.7 days). So what are the solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should… feature a few months ago. If you are using multiple storage engines, then your options are to either try and time delay slaves…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… GA release date – quite respected. The cases when you see old MySQL versions are used is typically when application is not overly demanding… it. Do you think such policies are reasonable ? Do we need longer support cycle or shorter would make sense ? How long older platforms… very old operating system is important for you ? Finally I’d like to know What is the Oldest Platform/Operating system are you running…
Post: Explaining Indexes with a Library Metaphor
August 30, 2011 By 1 Comment
… is comparing them to index cards in an old library. In an old library, you used to (or still do) have index cards…. You have your result and you have saved yourself from walking over to the shelves. Using a covering index You are interested to know how many pages a certain book by J.R. Hartley has. You go over to the…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries are IO bound… query shows information about how many pages are in buffer pool for given table (cnt), how many of them are dirty (dirty), and what…. You can use this feature to tune buffer pool invalidation strategy, for example play with innodb_old_blocks_pct and innodb_old_blocks…
