Yearly Archives - 2007

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