June 19, 2013

Post: Find and remove duplicate indexes

June 20, 2012 By 9 Comments

…In this post I’m going to explain the different types of duplicate indexes and how to…indexes are easy to find out and to avoid them. How? Just specify the index name and MySQL will avoid to create duplicate indexes: mysql> alter table t add index…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software

Post: Feature preview: Compact backups in Percona XtraBackup

January 29, 2013 By 11 Comments

We continue to improve Percona XtraBackup, and today I would like to give a preview for one feature which comes in next Percona XtraBackup… not secondary. It allows to safe some space on a backup storage. How much? Well, it depends on how many indexes you have. For… command to prepare is: innobackupex –apply-log –rebuild-indexes /data/backup As a bonus, secondary indexes are created by sorting, that in general gives much…

Filed Under: MySQL, Percona Software Tagged With: ,

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

…indexes built by sorting in case of ALTER TABLE (the big Gotcha for MyISAM tables). Are there any plans to be able to build indexes in…giving you problems if you have a lot of concurrent inserts happening to…in MySQL 5.2 or even MySQL 5.1. I surely would like to see it sooner at least in…

Filed Under: Events and Announcements Tagged With:

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

March 4, 2013 By 7 Comments

…in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In…to do this in a single blog post) than what MyISAM gives…To test this hypothesis, I reset innodb_ft_min_token_size to 1, dropped/rebuilt the InnoDB index, and tried again. mysql…

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

Post: The Optimization That (Often) Isn't: Index Merge Intersection

December 14, 2012 By 6 Comments

… to execute. Yet it appears so benign. What gives? One word: selectivity. Out of 4.5M rows in…could be satisfied in some other way. After all, if an index isn’t there, MySQL can’t attempt to use … exactly how the server should be finding and manipulating data, they can be quite effective. In the …

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

Post: How to estimate query completion time in MySQL

April 22, 2008 By 16 Comments

… a query in MySQL and wondered how long it’ll take to complete? Many people have had …MySQL to perform the query as a table scan of the fact table, then an index lookup in each dimension table in…more complicated ones to consider, but hopefully this gives you an idea how you can tackle this problem in…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Consulting - Being on your own

February 20, 2007 By 7 Comments

…in my professional life. In SpyLOG I was second person in the company and completely managed technical department, later in MySQL…how to do the things but also implementing things ourselves, which gives quite a different prospective in…

Filed Under: Events and Announcements Tagged With:

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

February 12, 2013 By 4 Comments

…MySQL Query Anti-Patterns that can be moved to Sphinx - (Vladimir Fedorkov, PalominoDB) Now that Innodb supports Full-text indexing, I’m interested in…how to get beyond a single-mastered data store and why it’s a hard problem to solve. State of the Art for MySQL…

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

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in…consider any one of these factors (schema, queries, indexing) in isolation, because they are tightly bound together, …I find out which are the most likely to give the greatest gains. I use a dual…

Filed Under: Insight for Developers Tagged With:

Post: Side load may massively impact your MySQL Performance

November 13, 2011 By 7 Comments

…index as p using(index_id) where t.schema=’test’ group by i.index_id \G INDEX…to non zero value, if not I would strongly suggest changing default from zero in MySQL…

Filed Under: Benchmarks, Insight for DBAs, MySQL
« Older Posts
Newer Posts »