Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
April 18, 2008
Idea: Couple of more string types
MySQL has a lot of string data types – CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such as [...]
April 4, 2008
Multi-Column IN clause – Unexpected MySQL Issue
We have an application which stores massive amount of urls. To save on indexes instead of using URL we index [...]
April 2, 2008
Stored Function to generate Sequences
Today a customer asked me to help them to convert their sequence generation process to the stored procedure and even [...]
March 13, 2008
Economics of Performance Optimization
I think every person responsible for Development or Operations of growing application sooner or later have to decide on couple [...]
March 7, 2008
Speeding up GROUP BY if you want aproximate results
Doing performance analyzes today I wanted to count how many hits come to the pages which get more than couple [...]
March 6, 2008
Sphinx 0.9.8 reaches RC stage, Docs updated
Andrew Aksenoff is pretty slow with release numbers for Sphinx. By MySQL Users Conference 2007 Sphinx version 0.9.7 was released [...]
February 15, 2008
MySQL Performance Blog now uses Sphinx for Site Search
I never liked how build in WordPress search works. it shows full documents rather than snippets it does not search [...]
February 7, 2008
MySQL Full Text Search in Action
Preparing to move I’m selling stuff on GumTree which is UK based clone of Craigslist offering similar functionality but with [...]
February 1, 2008
Performance gotcha of MySQL memory tables
One performance gotcha with MEMORY tables you might know about comes from the fact it is the only MySQL storage [...]
January 10, 2008
PHP vs. BIGINT vs. float conversion caveat
Sometimes you need to work with big numbers in PHP (gulp). For example, sometimes 32-bit identifiers are not enough and [...]
December 20, 2007
Large result sets vs. compression protocol
mysql_connect() function in PHP’s MySQL interface (which for reference maps to mysql_real_connect() function in MySQL C API) has a $client_flags [...]
December 19, 2007
MVCC: Transaction IDs, Log Sequence numbers and Snapshots
MySQL Storage Engines implementing Multi Version Concurrency Control have several internal identifiers related to MVCC. I see a lot of [...]
December 18, 2007
Fixing Column Encoding Mess in MySQL
Just had an interesting issue with an encoding mess on a column containing non-ASCII (Russian) text. The solution was not [...]
November 22, 2007
Pitfall of proxying HTTP requests through Lighttpd
Recently I had a case with a web server farm where a random node went down every few minutes. I [...]
November 18, 2007
MySQL: Data Storage or Data Processing
I was thinking today of how people tend to use MySQL in modern applications and it stroke me in many [...]
November 4, 2007
Heikki Tuuri answers to Innodb questions, Part II
I now got answers to the second portions of the questions you asked Heikki. If you have not seen the [...]
November 1, 2007
Nginx Powers Hulu.com ?
Look at this post recently published on TechCrunch – It is ugly standard 404 error message, but what is interesting [...]
October 26, 2007
Heikki Tuuri Innodb answers – Part I
Its almost a month since I promised Heikki Tuuri to answer Innodb Questions. Heikki is a busy man so I [...]
October 17, 2007
MySQL Performance – eliminating ORDER BY function
One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants [...]
October 16, 2007
Be Careful when Joining on CONCAT
The other day I had a case with an awful performance of a rather simple join. It was a join [...]