by Peter Zaitsev | Oct 4, 2007 | Insight for DBAs
Recent couple of days our team was pointed to number of bugs in MySQL 5.0 which again seriously shakes the confidence in both MySQL Quality Control and bug fix promptness. Let me just take couple of bugs as examples: Triggers broken with auto-increment columns for...
by Peter Zaitsev | Sep 28, 2007 | Insight for Developers
Have you ever had a question about Innodb internal design or behavior which is not well covered in MySQL manual ? I surely had. Now you have a great chance to have them answered ! Heikki Tuuri, Creator of Innodb will answer your Questions about Innodb at MySQL...
by Peter Zaitsev | Sep 18, 2007 | Percona Events
26th of September, just after HighLoad conference I will have full day MySQL master class. This time we will talk about Innodb Architecture and Performance Optimization and when will discuss some MySQL Performance Optimization and Scaling case studies from audience...
by Peter Zaitsev | Sep 18, 2007 | Insight for Developers
Every so often you need to perform sort results retrieved from MySQL when your WHERE clause goes beyound col=const values which would allow MySQL to still use second portion of the index for the order by. Ranges as well as IN lists make this optimization impossible,...
by Peter Zaitsev | Sep 17, 2007 | Benchmarks, Insight for DBAs
The more I work with MySQL Performance Optimization and Optimization for other applications the better I understand I have to less believe in common sense or common sense of documentation writers and do more benchmarks and performance research. I just recently wrote...
by Peter Zaitsev | Sep 15, 2007 | Percona Events
I finally got my visa so I’m going to MySQL Developers meeting in Heidelberg, Germany next week. Hopefully it will be great source of “technical insight” information, either from organized sessions or from developers themselves. Plus I’m...
by Peter Zaitsev | Sep 12, 2007 | Insight for DBAs
Monty Taylor posted interesting investigation of the fact read_buffer_size variable affects connection speed. This is not something you would expect right ? me too. Not only global user data is expected to be cached on startup but even if it is not why would you do...
by Peter Zaitsev | Sep 3, 2007 | Percona Events
HighLoad.RU is the conference focused on Building High Performance Systems and has speakers from most of top Russian Internet companies. It is taking place in Moscow, Russia 24-25 of September and you should know a bit of Russian to attend 🙂 The conference has some...
by Peter Zaitsev | Sep 2, 2007 | Percona Events
We have yet another opening at MySQL Performance Blog. We’re looking for Intern position (with limited compensation) to work on project of MySQL Performance research and analysis, developing and running benchmarks under our guidance, writing WhitePapers and...
by Peter Zaitsev | Aug 31, 2007 | Percona Events
As you may already have seen announcement by Baron we’re working on major rewrite of High Performance MySQL book – the most famous book about MySQL Performance on the market… which is getting old though. We’ve been slowly working on the book...
by Peter Zaitsev | Aug 17, 2007 | Insight for Developers
Jan has a good article about finding the row matching some value in the group: This is one illustration of group by limitations in SQL language which is not offset by any MySQL specific extensions,yet As you can see if you want to get one row from the group which is...
by Peter Zaitsev | Aug 15, 2007 | Percona Events
Sheeri just posted a great post putting a different view on recent MySQL Community Announcements. This however raises very interesting point what MySQL Community really needs ? I think the problem is there are no single set of needs for Community which can be...
by Vadim Tkachenko | Aug 9, 2007 | Percona Events
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...
by Peter Zaitsev | Aug 9, 2007 | Percona Events
Yesterday Kaj Published changes to MySQL Community Release Policies. I knew about them a bit in advance but now they are public I can comment a bit. In general I’m disappointed and think this is moving in the wrong direction, it also makes me to think hard if...
by Peter Zaitsev | Aug 1, 2007 | Insight for DBAs
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...
by Peter Zaitsev | Jul 26, 2007 | Percona Events
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...
by Peter Zaitsev | Jul 4, 2007 | Insight for DBAs
I’ve read through Top 5 (or more) wishes posted by number of MySQL employees as well as by a lot of community members. It was great to see so wide coverage as people with different backgrounds wish different things – Developers have some wishes to ease...
by Peter Zaitsev | Jul 3, 2007 | Percona Events
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...
by Peter Zaitsev | Jun 29, 2007 | Insight for DBAs
About a week ago Marten send me email pointing to his article published on Jays Blog (Come on Marten, it is time for you to get your own blog). I should have replied much earlier but only found time to do that now. So here is my list 1. Be Pluggable Unlike many...
by Peter Zaitsev | Jun 15, 2007 | Hardware and Storage
In the previous post I mentioned not all architectures and solutions work for Commodity People, and people seems to agree with me. Number of vendors would claim they are in Commodity Software or Hardware business but few would probably mention they are doing it for...
