… of clicks/views etc. I’m testing with table with ~ 10 000 000 rows generated randomly. In first table I store…. The most common query in such cases is to get top N results for browsers/platforms/countries etc in any time… CHARSET=latin1 AUTO_INCREMENT=91748 ; So the query to get top 10 countries will be SELECT iplist.code COUNT(stat.ip_interval…
Comment: Tools and Techniques for Index Design Webinar Questions Followup
October 5, 2012 By 5 Comments
…, so I might only create three new indexes for the top 10 queries. It’s also common to find cases where an… needed for one of them. Once I get past the top queries, the remaining queries usually each account for less than… indexes that help queries ranked higher. So start at the top of the ranked list, try to find indexes that benefit…
Post: Announcing Percona Server for MySQL 5.6.10-60.2
March 14, 2013 By Leave a Comment
…=”alignright” width=”247″] Percona Server for MySQL version 5.6.10-60.2[/caption] Percona is glad to announce the release… the experimental Percona Software Repositories). Based on MySQL 5.6.10, including all the bug fixes in it, Percona Server 5… MariaDB. This feature enables the MySQL server to keep the top performance even with the increased number of client connections. Expanded…
Post: Amazon Web Services and HP Keynotes at Percona Live MySQL Conference and Expo
February 14, 2013 By 1 Comment
…, quick tip, or demonstration. Submissions will be reviewed and the top 10 will present during the one-hour Lightning Talks session during…
Comment: Innodb performance gotcha w Larger queries.
September 28, 2009 By 7 Comments
… dominating in the 5.1.30 codebase, disappear from the top 10 functions in 5.1.37 codebase. Though unlike your success…
Post: How to Outrun the Lions
July 13, 2008 By 10 Comments
… titled Outrun the Lions. Our customers run several of the top 10 applications on Facebook right now (as measured by the number…
Comment: Neat tricks for the MySQL command-line pager
June 24, 2008 By 13 Comments
… show processlist will now suppress sleeping sessions and display the top 10 oldest sessions. Thanks for the tip on passing any script…
Comment: How much overhead is caused by on disk temporary tables
August 18, 2007 By 26 Comments
[...] took the same table as I used for MySQL Group by Performance Tests to see how much MySQL can sort 1.000.000 rows, or rather return top 10 rows from sorted result set [...]
Comment: Sphinx: Going Beyond full text search
July 24, 2007 By 18 Comments
… is too bad. If the goal would be to show top 10 any links this approach would work just fine 
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… really bad is Parallel query. Reporting with group by over 10.000.000 of rows in real time is one painful…
