September 17, 2007

Using GROUP BY WITH ROLLUP for Reporting Performance Optimization

Posted by peter |

Quite typical query for reporting applications is to find top X values. If you analyze Web Site logs you would look at most popular web pages or search engine keywords which bring you most of the traffic. If you’re looking at ecommerce reporting you may be interested in best selling product or top sales people. This information may often need simple select query, however what if you would like to show percents not just absolute value ?
[read more...]

Posted by peter @ 9:35 am :: benchmarks, production :: 8 comments
Print This Post Print This Post book mark Using GROUP BY WITH ROLLUP for Reporting Performance Optimization in del.icio.usdel.icio.us :: submit Using GROUP BY WITH ROLLUP for Reporting Performance Optimization to digg.comdigg

MySQL: what read_buffer_size value is optimal ?

Posted by peter |

The more I work with MySQL Performance Optimization and Optimization for other applications the better I understand I have to less believe in common sense or common sense of documentation writers and do more benchmarks and performance research. I just recently wrote about rather surprising results with sort performance and today I’ve discovered even read_buffer_size selection may be less than obvious.
[read more...]

Posted by peter @ 7:41 am :: benchmarks, community :: 17 comments
Print This Post Print This Post book mark MySQL: what read_buffer_size value is optimal ? in del.icio.usdel.icio.us :: submit MySQL: what read_buffer_size value is optimal ? to digg.comdigg