Monthly Archives - January 2007

Looking for someone with Chinese knowledge

We’re looking to implement CJK Support in Open Source Full Text search engine Sphinx .
Initially we’re thinking to base search ob bi-gram indexing to keep it simple, especially as according to research papers it offers decent quality for most cases. This is not that complex to implement however there is no way […]

Read more

Getting real life query speeds with MySQL

To check for query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the query and see if there is any significant improvement.
Leaving aside question of checking single query alone might not be the best way to see real improvement for your application, the problem they usually run […]

Read more

MySQL automatic data truncation can backfire

I had a fun case today.
There is set of cache tables which cache certain content in MyISAM tables and queries for these tables such as:

Shell

select data from cache0003 where `key`=2342526263 and real_key=’cp_140797_6460aad5d2e50d3e859e8649007686ac’;

1

select data from cache0003 where `key`=2342526263 and real_key=’cp_140797_6460aad5d2e50d3e859e8649007686ac’;

The “key” is CRC32 of the real key which is used to keep […]

Read more

MySQL sources from development tree

I just want to write few tips how to get MySQL from development BitKeeper tree, as there are several tricks.
First of all you need a fresh free client – bk-client2.0 http://www.bitkeeper.com/Hosted.Downloading.html .
Once you get it, you can clone latest tree:
bkf clone bk://mysql.bkbits.net/mysql-5.0 mysql-5.0
New client supports “changes” command, so you can look latest changes
bkf changes […]

Read more

Sphinx Developer joins our team

We’re happy to announce Andrew Aksyonoff, developer of popular OpenSource full text search software Sphinx joins our team.
Andrew will now have more time to dedicate to Sphinx development so cool new features will come sooner.
Having Andrew on board we’ll be able to solve all kinds of problems related to full text search, tagging […]

Read more

InnoDB vs MyISAM vs Falcon benchmarks – part 1

Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM.
The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is transactional, […]

Read more

InnoDB benchmarks

There was several changes in InnoDB to fix scalabilty problems, so I ran benchmark to check
new results and also compare overall performance of InnoDB in 5.0 and 5.1 before and after fixes.
Problems in InnoDB that were fixed:

Thread trashing issues with count of theads 100+. In this case
performance of InnoDB degraded dramatically. The problem […]

Read more