Bartosz, You are right this is due to an optimizer inefficiency. But till the time the optimizer is not efficient enough we would have to use workarounds. In fact hints tend to be used a lot because although mostly optimizer makes good choices but sometimes it doesn’t.
Comment: Load management Techniques for MySQL
May 11, 2012 By 3 Comments
So, i dont know if there is the right place to suggest somenting , but i will, i have one …
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
… I do agree that turning off session binlog is the right strategy to go with. But can you explain why I…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… show only 0-100k level: I implemented Zipf for sysbench, right now it is in a separate tree https://code.launchpad…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… engineering effort that requires a lot of expertise to do right, and Percona has that expertise, as we’ve proven by…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading the system causing user experience to …
Comment: Version 1.0 of Percona Monitoring Plugins Released
April 27, 2012 By 7 Comments
That is apparently a bug (or “feature” — I’m not sure if the official shell spec defines the right behavior) in specific shell implementations. It’s been reported on Launchpad.
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
… keep working even when things are somewhat broke/not quite right and very easy to maintain. Cats are finicky, high maintenance… system that will run even when things aren’t quite right. My point is, MyISAM is still a good engine for…
Comment: Finding out largest tables on MySQL Server
April 19, 2012 By 24 Comments
Stefan, Why not make a combined key of categID, subcategID? CREATE INDEX index_2 on table(categID, subcategID) Right now, if I’m reading it properly, you reference the categID index, and then scan everything in that index. If you make a combined key, it can do both at the same time.
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 11, 2012 By 9 Comments
I would like to point out a limitation that is not currently documented: the tool will get confused if you rename a column, and won’t do the right thing.
