…versus observing queries only. An additional benefit is that SchemaSpy is command-line driven and builds the …the exact same name (in this case, parent_id) in the child and parent tables. Your environment may…automate SchemaSpy via crontab once you’re done. What are some ERD tools you use and how…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… CMAN. Let’s have look at what happens if we have a cluster … to cluster failed: Transport endpoint is not connected… …but MySQL is still running: [root@percona2 ...your cluster using cman_tool or clustat (if you have installed rgmanager) [root@percona3 ~]# cman_tool nodes Node Sts Inc Joined Name…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…. By the way, a good practice to avoid this is always naming your keys with a consistent pattern. This new behavior was introduced… words, it checks for duplicate keys, but not redundant ones. What is the difference? Let’s see an example. If we execute… second, because in some cases, we may need to have what at first seems redundant indexes but effectively they are not…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… ‘nuclear-bomb’, ‘ejector-seat’); This is okay because each correlation name (k1, k2, k3) is an index lookup. Look … an option there? Yes, I think what you’re referring to is what I covered as the Derived-…solution was 150x faster for this case, so your suggestion is a good one! Thanks again for …
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 …? What does that mean? In most of these high-availability solutions it means that mysqld is …username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –…
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…, however, is not the true limit. To find out what the actual limit is, we must delve further into the FRM file. What is an…)) if $n >= 10; $c= int $c/36; } $name.=’0′ foreach(length $name .. shift); return $name } my $sql= “CREATE TABLE `”.cname(16,63).”` (“; foreach…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… that will be incorporated into your certificate request. What you are about to enter is what is called a Distinguished Name or a DN. There are… Province 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: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…is important to understand. What is flow control? One of the things that people don’t often expect when switching to Galera is…soon as the fc_limit is exceeded. Therefore, care must be taken that your application or some …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
…with business. The conference name changes to “MySQL Conference…is delivered by Marten Mickos. It is truly a year of storage engines, focused on showing what is on top is what…what memorable moments do you have from you attending MySQL Conference over last 10 years. Please leave comment and share your…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… My major takeaways from those talks were: Oracle is investing a tremendous amount of time and energy… vendors, and technologies. This was the first of what I hope are many such events where all… Santa Clara Convention Center, to name just a few. Please mark your calendars now for two upcoming Percona…
