In preparing for this month’s Percona Live MySQL Conference and Expo, I’ve been reminiscing about the annual MySQL User Conference’s history – the 9 times it previously took place in its various reincarnations – and there are a lot of good things, fun things to remember. 2003 was the year that marked the first MySQL user conference [...]
Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions – as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul! What’s the “ideal” use case for the PBXT engine, and how does it compare in performance?  When would I [...]
Will Percona Support Drizzle ?
August 6, 2008 By 10 Comments
People are asking me if Percona will support Drizzle and what is in general our position regarding this project. First about Support. We surely will support the customers if they select to run the Drizzle instead of MySQL Server. For us it is same as supporting MySQL Server with custom patches, which we do. In [...]
The tool I’ve been waiting for years
March 18, 2008 By 10 Comments
I’ve just been pointed to the nice tool which I was waiting for years to see. It is fincore – little perl script which allows you to see what pages of file are cached in OS memory. This is really cool.
Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set correctly. I’ve seen a lot [...]
MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
OK, I am not getting too much people feedback on what would they like to hear about on MySQL Users Conference, so I went ahead and submitted few presentation ideas. I do not expect all of them would be accepted, furthermore it would be hard to prepare so many good presentations if they are so [...]
MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
Yesterday I’ve attended MySQL Customers Conference in London. This event is much smaller size than Users Conference (one day and about 170 people attending) and surely less geeky – there were no one from MySQL Development Support or Consulting teams and Sales Engineers were as close as you could get. Though Anders Karlsson and Ivan [...]
Query Profiling with MySQL: Bypassing caches
September 12, 2007 By 6 Comments
Quite frequently I run into question like this “I’m using SQL_NO_CACHE but my query is still much faster second time I run it, why is that ? The answer to this question is simple – because SQL_NO_CACHE only bypasses query cache but it has no change on other caches, which are MySQL Caches – Innodb [...]
Landscape of Transactional Storage Engines for MySQL
August 1, 2007 By 11 Comments
I finally found a time to publish Landscape of Transactional Storage Engines slides on MySQL Presentations page , this is the talk which we gave on OSCON 2007 and which talks about current state behavior and performance properties of Innodb, Falcon, PBXT and SolidDB Storage Engines.
Speaking on OSCON 2007
July 3, 2007 By 2 Comments
Vadim and me will be speaking on OSCON 2007, taking place in Portland,OR July 23-27. Our talk will be about Open Source Transactional Storage Engines meaning Innodb, Falcon, Solid and PBXT. We’ll look into architecture of these storage engines as well as compare performance in number of Benchmarks. If you will be visiting OSCON please [...]
