A paginated display is one of the top optimization scenarios we see in the real world. Search results pages, leaderboards, and most-popular lists are good examples. You know the design pattern: display 20 results in some most-relevant order. Show a “next” and “previous” link. And usually, show how many items are in the whole list [...]
Yet another presentation submission
October 30, 2007 By Leave a Comment
Looking at the Feedback I got for other Presentations Proposals I thought I indeed should submit general presentation focusing on Web Application performance tuning and explaining how you analyze performance and why do you do it this way, so here it is: Performance Analysis of MySQL powered Web Applications In this session we’ll go beyond [...]
HighLoad 2007 Review
October 6, 2007 By 1 Comment
Almost two weeks have passed since HighLoad 2007 conference in Moscow, Russia so I’m pretty late with feedback and my only excuse I was pretty busy to spare some time for it. Lets start with bright side. The conference had a lot of great sessions by experts in their field. A lot of top Russian [...]
MySQL Community Needs
August 15, 2007 By 3 Comments
Sheeri just posted a great post putting a different view on recent MySQL Community Announcements. This however raises very interesting point what MySQL Community really needs ? I think the problem is there are no single set of needs for Community which can be maintained within single version. I see at least two set of [...]
Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
I’ve already wrote a few times about various projects using Sphinx with MySQL for scalable Full Text Search applications. For example on BoardReader we’re using this combination to build search against over 1 billion of forum posts totaling over 1.5TB of data handling hundreds of thousands of search queries per day. The count of forum [...]
RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
Just found this wonderful summary of articles by Jeremy and wanted to give some of my thoughts on the topic. First lets speak about death of the RAID. I think this is far from the case especially if you consider Software RAID here. For many workloads you would like to get RAID just for the [...]
MySQL Consulting – Being on your own
February 20, 2007 By 7 Comments
About half a year have passed since me and Vadim have left MySQL to do MySQL Consulting on our own. Bunch of people have been wondering about our experiences so I thought it would be worth to share it here.
