- Posted in: Admin-tips, Databases, Development, My Projects
- Tags: full-text, index, MySQL, optimization, Ruby, scalability, scribd, sphinx
19 May2008
How often do you think about the reasons why your favorite RDBMS sucks? 🙂 Last few months I was doing this quite often and yes, my favorite RDBMS is MySQL. The reason why I was thinking so because one of my recent tasks at Scribd was fixing scalability problems in documents browsing.
The problem with browsing was pretty simple to describe and as hard to fix – we have large data set which consists of a few tables with many fields with really bad selectivity (flag fields like is_deleted, is_private, etc; file_type, language_id , category_id and others). As the result of this situation it becomes really hard (if possible at all) to display documents lists like “most popular 1-10 pages PDF documents in Italian language from the category “Business” (of course, non-deleted, non-private, etc). If you’ll try to create appropriate indexes for each possible filters combination, you’ll end up having tens or hundreds of indexes and every INSERT query in your tables will take ages.
Read the rest of this entry →
[lang_en]
At this week I came across great blog of Peter Zaitsev and Vadim Tkachenko – two developers from High Performace Group at MySQL Inc. This blog’s name is MySQL Performance Blog and, as you probably assume, it is about misscelaneous sides of MySQL optimization and related stuff. So, if you are MySQL administrator or, even, developer, that works with MySQL, I would advise you to take a look at this blog – there are lots of useful MySQL optimization info.
[/lang_en]
[lang_ru]
На этой неделе я случайно наткнулся на отличный ресурс Петра Зайцева и Вадима Ткаченко – двоих разработчиков из High Performace Group в MySQL Inc. Их блог называется MySQL Performance Blog и, как Вы уже могли догадаться, в нем рассказывается о различных аспектах оптимизации MySQL и различных вещах, относящихся к оптимизации. Потому, если вы являетесь администратором MySQL или, просто, разработчиком, работающим с MySQL, я хочу настоятельно порекомендовать Вам взглянуть на этот блог – там очень много полезной информации по оптимальной работе с MySQL.
[/lang_ru]