Buy Percona ServicesBuy Now!

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

More Gotchas with MySQL 5.0

 | July 27, 2007 |  Posted In: Insight for DBAs

Working on large upgrade of MySQL 4.1 running Innodb to MySQL 5.0 and doing oprofile analyzes we found very interesting issue of buf_get_latched_pages_number being responsible for most CPU usage. It did not look right. The close look revealed this is the function which is used to compute number of latched pages in Innodb Buffer Pool, […]

Read More

MySQL 5.0 Community Edition Regression

 | July 27, 2007 |  Posted In: Insight for DBAs

It is true you might be better of being unaware about problems, because in this case you might not run into them 🙂 Just couple of days ago Kaj Arno told me there are issues reported with SHOW PROFILE patch available in latest MySQL Community Edition and I’ve been troubleshooting customer affected by one of […]

Read More

MySQL on OSCON

 | July 26, 2007 |  Posted In: Events and Announcements

Interesting enough this year people at OSCON do not show to much interest in the MySQL, and Databases for that reason. Our talk comparing performance of MySQL Storage Engines had probably 20-30 people, Monty’s talk on MySQL Source Code had about same number, and as Monty told me he never had so few people on […]

Read More

MySQL and PostgreSQL SpecJAppServer benchmark results

 | July 25, 2007 |  Posted In: Benchmarks

Listening to Josh Berkus presentation on OSCON today I decided to take a closer look at SpecJAppServer benchmarks results which were published by PostgreSQL recently and which as Josh Puts it “This publication shows that a properly tuned PostgreSQL is not only as fast or faster than MySQL, but almost as fast as Oracle (since […]

Read More
Subscribe to the Percona Database Performance Blog for open source database help, technical resources, Percona Live updates and upcoming webinars.
Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.