… have used the exact same name (in this case, parent_id) in the child and parent tables. Your environment may be like… by name to see if you have any implicit constraints that you might have missed and can then write into your metadata… forget to automate SchemaSpy via crontab once you’re done. What are some ERD tools you use and how do they…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… RHEL/CentOS prior to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain… are not yet using CMAN. Let’s have look at what happens if we have a cluster with 3 nodes (CentOS… your cluster using cman_tool or clustat (if you have installed rgmanager) [root@percona3 ~]# cman_tool nodes Node Sts Inc Joined Name…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…between 47000 and 50000 with no movies, but your random number generator picks values in that …of columns in the index. Example: WHERE (last_name, first_name) = (‘Karwin’, ‘Bill’); Q: On the Dynamic Pivot,… option there? Yes, I think what you’re referring to is what I covered as the Derived-Table…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… the way, a good practice to avoid this is always naming your keys with a consistent pattern. This new behavior was introduced… as early as 2005!). The report explains more in detail what the “will be disallowed in a future release” means. In… second, because in some cases, we may need to have what at first seems redundant indexes but effectively they are not…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… into your certificate request. What you are about to enter is what is called a Distinguished Name or a…Name (full name) []: Locality Name (eg, city) [Default City]: Organization Name (eg, company) [Default Company Ltd]: Organizational Unit Name (eg, section) []: Common Name (eg, your name or your…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… pools or anything else that’s on your mind! There are numerous solutions for MySQL high…. “Warm standby server”? Did you catch that? What does that mean? In most of these …-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –…
Comment: 10 years of MySQL User Conferences
April 13, 2013 By 6 Comments
… before the keynote?”. Weird. Spent my sleepless jetlag night wondering what that was about. So met him outside the ballroom before…, sitting next to Giuseppe & Dups. “Just how do you pronounce your name?” Sheeri asks. Weirder. So keynotes, …., community awards. And the community…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… “What is the minimum maximum number of columns in MySQL?”. Before you read on, ponder those questions and come up with your own answers… and see if you’re right or can prove me wrong! Back in 2009, I finished what seemed…)) if $n >= 10; $c= int $c/36; } $name.=’0′ foreach(length $name .. shift); return $name } my $sql= “CREATE TABLE `”.cname(16,63).”` (“; foreach…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…gcs.fc_factor=1.0″; Working with flow control What happens during flow control Simply speaking: flow control … is exceeded. Therefore, care must be taken that your application or some other maintenance operation (like a … Node Queue Ops Bytes Flow Conflct time name P cnf # name cmt sta Up Dn Up Dn Up …
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…’Reilly’s style of mixing fun with business. The conference name changes to “MySQL Conference and Expo” that year and moves… a year of storage engines, focused on showing what is on top is what really matters. Falcon, SolidDB, NitroSecurity, PBXT, StorageEngine for… know what memorable moments do you have from you attending MySQL Conference over last 10 years. Please leave comment and share your…
