July 31, 2014

Yahoo Search Suggestions for MySQL

I noticed today if you go to Yahoo.com and type MySQL to Search field it gives you suggestions for MySQL, which are: * loading javascript arrays with mysql data * mysql performance blog * mysql download * mysql administrator download * mysql front download It may not be best search suggestions but it is cool […]

MySQL Community Needs

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 […]

MySQL VIEW as performance troublemaker

I start to see applications being built utilizing VIEWs functionality which appeared in MySQL 5.0 and quite frequently VIEWs are used to help in writing the queries – to keep queries simple without really thinking how it affects server performance. Even worse than that – looking at the short table which just gets single row […]

FaceBook Search, Search for social networks

Yesterday I ran into the article which sheds some light on FaceBook search implementation. As we’re recently a lot into search having implemented a bunch of search projects ourselves and helped number a of customers with their full text search needs I decided to post my thoughts on this matter. First I was surprised article […]

SpyLOG Was sold the other day, time to look back

Friends are pointing me to the article saying SpyLOG, the startup which I co-founded back in 1999 was sold the other day to the MasterHost. The amount is not disclosed but it is estimated to be $3M – amount not worth mentioning for USA market but quite decent one for Russian Internet Market. So I […]

MySQL Community contrubutions

I’ve just read post http://www.planetmysql.org/kaj/?p=123 about MySQL plans of including community contributions into releases. I understand MySQL’s interest to make releases stable, and includes contributions only into development tree, but this is not something I would like to see. Look, MySQL 5.0 was shipped as production on 19 October 2005. Since almost 2 years there […]

New MySQL Community Release Policies published

Yesterday Kaj Published changes to MySQL Community Release Policies. I knew about them a bit in advance but now they are public I can comment a bit. In general I’m disappointed and think this is moving in the wrong direction, it also makes me to think hard if MySQL is out of more creative solutions […]

Query_cache and column level privileges

Recently we were puzzled by question how query_cache works with column level privileges. The question was appeared as we discovered function query_cache_send_result_to_client is called before real parsing of query, so at the moment of execution the query_cache is not able to know which columns are accessed. Looking into source code I found out that in […]

Landscape of Transactional Storage Engines for MySQL

I finally found a time to publish Landscape of Transactional Storage Engines slides on MySQL Presentations page , this is the talk which we gave on OSCON 2007 and which talks about current state behavior and performance properties of Innodb, Falcon, PBXT and SolidDB Storage Engines.