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 28, 2007 | Insight for Developers
Many Open Source software solutions use database per user (or set of tables per user) which starts to cause problems if it is used on massive scale (blog hosting, forum hosting etc), resulting of hundreds of thousands if not millions of tables per server which can...
by Peter Zaitsev | Sep 28, 2007 | Insight for DBAs
It always surprised me how little Innodb team seems to think about product usability/ease of use, when it comes to settings, performance management etc. I could understand many things 5 years ago, like a lot of information being available only in hard to parse SHOW...
by Vadim Tkachenko | Sep 26, 2007 | Insight for DBAs
There was long played scalability issue with InnoDB auto-increment field. For details check Bug 16979. In short words the problem is in case of insert into table with auto-increment column the special AUTO_INC table level lock is obtained, instead of usual row-level...
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 Developers
Quite typical query for reporting applications is to find top X values. If you analyze Web Site logs you would look at most popular web pages or search engine keywords which bring you most of the traffic. If you’re looking at ecommerce reporting you may be...
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 13, 2007 | Insight for DBAs
General query logging can be very handy in MySQL on profuction server for various debugging needs. Unfortunately you can’t switch it on and off without restarting server until MySQL 5.0. What can you do in MySQL 5.0 and below ? Use Our Patch – With this...
by Vadim Tkachenko | Sep 13, 2007 | Insight for DBAs
If you like to compile MySQL from sources by yourself, for different needs, like debugging, testing etc, you probably can face this issue. What I usually do to fast compile and test is ./configure --prefix=/dir/to/mysql make make install 123 ./configure...
by Peter Zaitsev | Sep 12, 2007 | Insight for Developers
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...
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 10, 2007 | Percona Events
As one of my last posts about issues with hosting provider got great response and We got a lot of good advice and offers I decided to ask for advice another problem we have as we’re growing our company – organizing good phone communications. Our goals are...
by Vadim Tkachenko | Sep 7, 2007 | Percona Events
Returning to my post about memory consumption with Stored Function at this moment I want to annul that post. Trying to repeat described behavoir I cannot repeat that again and probably there was something wrong with the whole box, not MySQL. I apologize if it was...
by Peter Zaitsev | Sep 5, 2007 | Insight for Developers
MySQL Has API to run Multiple Queries at once. This feature was designed mainly with saving network round trip in mind and got a little traction due to associated security risks and not significant gains in most cases. What would make MySQL Multiple Queries API more...
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
During last one and a half year we had pretty good track record with MySQL Performance Blog – there were times when site was slow (especially when backup was running) but I do not remember significant downtime, until today we went down for few hours. All this...
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...
