…using CMAN. Let’s have look at what happens if we have a cluster with… that percona1 is now offline: ============ Last updated: Thu May 23 08:29:36 2013 Last change: …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
…order of columns in the index. Example: WHERE (last_name, first_name) = (‘Karwin’, ‘Bill’); Q: On the Dynamic Pivot,… 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: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…Duplicate Index Detection I commented about this on my last webinar, but did not have time to … way, a good practice to avoid this is always naming your keys with a consistent pattern. This new … checks for duplicate keys, but not redundant ones. What is the difference? Let’s see an example. If…
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…_limit is exceeded. Therefore, care must be taken that your … since the last SHOW GLOBAL STATUS that flow control is effect, … Flow Conflct time name P cnf # name cmt sta 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
…takeaways from those talks were: Oracle is investing a tremendous amount of… ever-evolving MySQL ecosystem.”[/caption] Unlike last year, Oracle sent both executives … technologies. This was the first of what I hope are many such…Convention Center, to name just a few. Please mark your calendars now for …
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
…name which identifies table down to partition, which is very helpful for analyzes of your access to partitions – you can actually check if your…what is really getting warmed up first as well as how buffer pool is…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… you to connect the Raspberry Pi to your screen, and so follow what is happening on the console of the Raspberry … IP to a DNS name in your router’s DNS server setup. The password for user ‘root’ is ‘root’, and the ….0.180 root@192.168.0.180′s password: Last login: Fri Feb 22 23:27:49 2013 from …
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
….10 sec) Because we refer state by name, which is unique,it is pre-read and query executed basically on single… cost still could be significant. And the last test – selecting city and name in arbitrary order, skipping first 10000 rows…as you expect. Though again a lot depends on your data and queries….
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… last 2 blog posts about High Availability for MySQL we…cover what is the most popular HA solution for MySQL, replication. High Availability solution for MySQL: Replication This HA solution is…add a separate server, the Manager that, like the name imply, manages the availability of the MySQL service. …
