I will be presenting at upcoming MySQL Meetup at San Francisco this Thursday, August 13. I will talk about Sphinx covering the new cool features this search engine has as well as showing the demo on how simple it is to use Sphinx to implement high performance full text search for your MySQL driven application. [...]
Percona BOFs at OSCON
July 18, 2009 By Leave a Comment
Talks are great. I however very much like discussion and opinion share atmosphere of the Birds of a Feather sessions so we host/co-host number of BOFs at the comming OSCON conference. Future of MySQL Forks, Branches and Patches I guess is the topic a lot of us are interested in. Monty was going to Show [...]
Profiling MySQL stored routines
January 19, 2009 By 4 Comments
These days I’m working with a customer who has an application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’s going to be a piece of cake. In the end – it was, but there’s a catch.
New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
As you likely have seen Sun has posted the new SpecJAppServer Results More information from Tom Daly can be found here These results are quite interesting for me as I worked on some of the previous SpecJAppServer Benchmarks several years ago while being employed by MySQL. These are great results, plus they can be relevant [...]
Percona turns two today !
August 1, 2008 By 13 Comments
July 31st 2006 was my last day working for MySQL and August 1st I started what later was incorporated Percona with Vadim joining me September 1st as co-founder. Two years is a significant anniversary for any startup – surviving (and being profitable) for 2 years can be seen as validation of our business model and [...]
Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
As you probably already seen in a post by Baron, Sphinx Release 0.9.8 is finally out, just in time for OSCON 2008. Even though it is “minor release” if you look at the number, it is major release in practice (and you can view snapshots as minor releases). The changes since 0.9.7 are dramatic with [...]
How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
Recently I had a customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal was to load this data on many servers without putting it into the binary log. While this is generally a fast way to load data (especially if you disable unique key checks and foreign key [...]
Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
We know MySQL Backups using LVM are pretty cool (check out mylvmbackup) or MMM though it is quite typical LVM is not configurable properly to be usable for MySQL Backups. Quite frequently I find LVM installed on the system but no free space left to be used as snapshot undo space, which means LVM is [...]
Learning about MySQL Table Fragmentation
May 1, 2008 By 20 Comments
Recently I was working with the customer who need quick warmup – to get Innodb table fetched in memory as fast as possible to get good in memory access performance. To do it I run the query: “SELECT count(*) FROM tbl WHERE non_idx_col=0″ I use this particular form of query because it will do full [...]
T2000 CPU Performance – Watch out
May 1, 2008 By 12 Comments
Sun is aggressively pushing T2000 as Scalable MySQL Platforms, and indeed it is Scalable in terms of high concurrency workloads – it is able to execute a lot of concurrent threads and so speed gain from 1 thread to say 32 thread will be significant. But thing a lot of people miss is – Being [...]
