… series of FREE one-day educational events, we are pleased to feature 10 technical talks by members… integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to … possibilities and free drinks for event attendees. If you‘re in the Portland area and work with …
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… anything until maybe the ’90s. (Think Netscape.) We are now re-raising those old questions about business …the future.” It will be interesting to see how this plays out. I think it will work. …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… application? Think about your workload. How frequently do you update any given row? We call rows that are updated heavily “hotspots”. Examples of…’; How many players might accomplish this achievement at the same time? Example 2: You have users and groups in your application. These are… in Galera you cannot relax synchronous replication. You can’t change the law, you can only adapt around it, but how might you do that…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
… small change can make a big difference. There are two ways to know how many records an InnoDB page stores. The index… method to confirm how many records are in the page is to follow records pointers – and count them. As you might know, records… can be make: The page structure is not corrupt You know how many records to expect This is what constraints_parser does…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… where it would make sense it is still zero. If you know how InnoDB uses `PREC` please let me know. mysql> select…. The matter is regardless at what position primary key fields are defined in CREATE TABLE statement internally they always go first…, PRIMARY KEY (`actor_id`) ) ENGINE=InnoDB; In the end there are two notes: The generated structure differs from the original structure…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… easy to shoot yourself in the foot if you use it incorrectly. So how do you safely disconnect a replication slave? In short… in the documentation, the connection parameters are still held in memory. In any case, you will be able to restart replication, but… work as expected without any additional tricks. As soon as you are aware of the difference between RESET SLAVE and RESET SLAVE…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… gave the short answer, Rick has a point but there are generally other considerations to take into account. He also didn… table. Depending on how often you write to the table, you may not see the difference. However…. 1. If you have uneven reads across… only about the ‘Selects’ and Inserts, its also about what you do with the table. Removing partitions is easier and quicker…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… variables. For a quick intro to metadata locks and how they may affect you, see Ovais’s article. In short: pt-online… have problems. And there are certain versions of MySQL that have critical bugs. Version check will warn you about these if your…, so specify –iterations or –run-time to limit how long they run. There are more changes in addition to those highlights. For…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… MySQL That Could Save Your Day.” In this presentation you‘ll learn how to perform typical but challenging MySQL database administration tasks… the Percona Toolkit tools for MySQL. In this presentation, you will learn how you can use some of these tools to solve typical… without putting too much load on your server How to check which tables are affected when someone accidentally wrote to a replica…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…, but how big is that? And when is flow control relaxed? There are a few settings that are relevant here, and they are all… application. How to tell if flow control is happening and where it is coming from There are two global status variables you can…_control_sent so you can tell if and when flow control is happening and what node (or nodes) are causing it. Using…
