Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
August 18, 2008
Worse than DDOS
Today I worked on rather interesting customer problem. Site was subject what was considered DDOS and solution was implemented to [...]
August 9, 2008
Picking datatype for STATUS fields
Quite commonly in applications, you would need to use some kind of “status” field – the status of an order [...]
August 4, 2008
To find the bottleneck, stop guessing and start measuring
We recently examined a customer’s system to try to speed up an ETL (Extraction, Transformation and Loading) process for a [...]
August 1, 2008
How adding another table to JOIN can improve performance ?
JOINs are expensive and it most typical the fewer tables (for the same database) you join the better performance you [...]
July 20, 2008
Sphinx 0.9.8 is released just in time for OSCON 2008
As you probably already seen in a post by Baron, Sphinx Release 0.9.8 is finally out, just in time for [...]
July 20, 2008
Missing Data – rows used to generate result set
As Baron writes it is not the number of rows returned by the query but number of rows accessed by [...]
July 3, 2008
How to load large files safely into InnoDB with LOAD DATA INFILE
Recently I had a customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal [...]
June 26, 2008
Web Site Optimization: FrontEnd and BackEnd
I spent Monday and Tuesday this week on Velocity Conference It was quite interesting event worth attending and it was [...]
June 17, 2008
Lighttpd as reverse proxy
We often recommend to set lighttpd in front of apache to handle http requests (more about https://www.percona.com/blog/speedup-your-lamp-stack-with-lighttpd/ ) , redirect dynamic [...]
May 20, 2008
Apache PHP MySQL and Runaway Scripts
Sometimes due to programming error or due to very complex query you can get your PHP script running too long, [...]
April 28, 2008
The MySQL optimizer, the OS cache, and sequential versus random I/O
In my post on estimating query completion time, I wrote about how I measured the performance on a join between [...]
April 23, 2008
Efficient Boolean value storage for Innodb Tables
Sometimes you have the task of storing multiple of boolean values (yes/now or something similar) in the table and if [...]
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 [...]