EmergencyEMERGENCY? Get 24/7 Help Now!

Yahoo Search Suggestions for MySQL

 | August 16, 2007 |  Posted In: Events and Announcements

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

Read More

MySQL Community Needs

 | August 15, 2007 |  Posted In: Events and Announcements

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

Read More

MySQL VIEW as performance troublemaker

 | August 12, 2007 |  Posted In: Insight for DBAs

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

Read More

FaceBook Search, Search for social networks

 | August 12, 2007 |  Posted In: Events and Announcements

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

Read More

MySQL Community contrubutions

 | August 9, 2007 |  Posted In: Events and Announcements

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

Read More

Query_cache and column level privileges

 | August 6, 2007 |  Posted In: Insight for Developers

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

Read More