June 19, 2013

Post: MySQL Query Patterns, Optimized - Webinar questions followup

June 3, 2013 By 2 Comments

… a problem if the keywords were returned in a different order from what you specify in the query? The tuple comparison you’re… each kind_id. It was more efficient in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order.  This made the first table in…

Filed Under: Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

May 31, 2013 By Leave a Comment

…in detail what the “will be disallowed in a future release” means. In MySQL 5.7 the checks will be stricter: in the default SQL mode, a duplicate index…first one. Why can’t MySQL enforce this kind of constraints? For many reasons…

Filed Under: Insight for DBAs, MySQL, On Ground Training, Percona Toolkit, Training Tagged With: , , , , , , , , ,

Post: What to tune in MySQL Server after installation

September 29, 2006 By 118 Comments

…work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL … well, and data can be much larger than indexes in many cases. Check however if all of key_… buffer size compared to MyISAM. MyISAM may work kind of OK with default key_buffer_size even …

Filed Under: Insight for DBAs Tagged With:

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

…pretty much inevitable: if you do this kind of data processing in MySQL, you’re going to end … can change the lifecycle of your application in advance. What about partitioning in MySQL 5.1?  I know …the indexes less than half the size. In real life this technique often makes the table+index much …

Filed Under: Insight for Developers Tagged With: , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…-text Search in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In part … our FT index on the InnoDB table and try the above queries one more time. We already know what the … of InnoDB FTS compare to its MyISAM counterpart, and what kinds of tricks can we use to make it go…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Troubleshooting MySQL Memory Usage

March 21, 2012 By 5 Comments

…kinds of memory leaks and I would say these are rather rare in MySQL…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in …, I find that kind of behavior unsettling. I don’t like case-sensitivity in my table or …files. What, exactly, are they? In short, the _CONFIG.ibd file contains configuration info about the FT index (…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see

February 12, 2013 By 4 Comments

… that Innodb supports Full-text indexing, I’m interested in other good discussion points about… sets. Internals of new InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning …in the latest/greatest out of Tungsten, and also what decision points he tends to bring to the table with this kind…

Filed Under: Events and Announcements, MySQL, Percona Live Tagged With: , ,

Post: Innodb vs MySQL index counts

November 29, 2011 By 6 Comments

…_SCHEMA.INNODB_SYS_INDEXES table, which exists in Percona Server 5.1, but doesn’t appear in MySQL until 5…. to figure out what index was missing via the Innodb data dictionary (more on that in a minute), create…frm, add that index to it, and copy the new .frm back over the original.  Kind of scary. My…

Filed Under: MySQL

Post: Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

…: 1 row in set (0.02 sec) The table is approximately 30GB in size including indexes which is …in buffered mode. Take a look at the graph: What this tells me is there is a lot of untapped potential in MySQL… workloads such cases are rare – most OLTP kind of workloads indeed work better with O_DIRECT…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,
« Older Posts