As you might know while running GROUP BY and some other kinds of queries MySQL needs to create temporary tables, which can be created in memory, using MEMORY storage engine or can be created on disk as MYISAM tables. Which one will be used depends on the allowed tmp_table_size and also by […]Read more
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 […]
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 […]
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 […]