by Peter Zaitsev | Oct 30, 2007 | Percona Events
Looking at the Feedback I got for other Presentations Proposals I thought I indeed should submit general presentation focusing on Web Application performance tuning and explaining how you analyze performance and why do you do it this way, so here it is: Performance...
by Aurimas Mikalauskas | Oct 29, 2007 | Insight for DBAs
Suppose you want to remove auto_increment from 100G table. No matter if it’s InnoDB or MyISAM, you’d usually ALTER TABLE huge_table CHANGE id id int(6) NOT NULL and then wait hours for table rebuild to complete. If you’re unlucky i.e. you have a lot...
by Peter Zaitsev | Oct 26, 2007 | Insight for Developers
Its almost a month since I promised Heikki Tuuri to answer Innodb Questions. Heikki is a busy man so I got answers to only some of the questions but as people still poking me about this I decided to publish the answers I have so far. Plus we may get some interesting...
by Peter Zaitsev | Oct 26, 2007 | Percona Events
What is the difference between “MySQL Support” and “Support for MySQL” ? In my mind there is not much difference in meaning just first one is shorter and I would use it also because how people would search stuff in Google. It turns out however...
by Peter Zaitsev | Oct 26, 2007 | Percona Events
Try number two. We have moved to the new server yet again, now it is server hosted by ServerBeach as recommended by Kevin Burton and few other guys. Lets hope this will run stable and we’ll not need to move it back in emergency in less than a week as we had to...
by Peter Zaitsev | Oct 24, 2007 | Percona Events
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...
by Peter Zaitsev | Oct 24, 2007 | Percona Events
About three months ago I announced ClickAider to become available to general public. And I think it is about the time to write about the progress we have with this project for those who interested. The project generates decent interest and we have about 3000 sites...
by Peter Zaitsev | Oct 22, 2007 | Percona Events
If you have been MySQL User for many years you might remember the times when MySQL had “zero bugs policy”, this is when all known bugs really were fixed before release was made. To be honest at that time bugs were reported via bugs mailing list not via...
by Peter Zaitsev | Oct 22, 2007 | Percona Events
It is submission time now, with about one week left till proposal submission deadline. Both me and Vadim had submitted few talks to the Grand Jury which will make elite selection of sessions for MySQL Users Conference and we plan to submit few more. Our experience in...
by Peter Zaitsev | Oct 17, 2007 | Percona Events
I already wrote once about hosting troubles which we had with this site a while back. Today we had another trouble to one of the European hit servers for ClickAider project. We had purchased this 1and1 server few months ago, before we were running into troubles and as...
by Peter Zaitsev | Oct 17, 2007 | Insight for Developers
One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants or order by. Ie use indexed_col=N is good. function(indexed_col)=N is bad because MySQL Typically will be unable to use index on the column...
by Peter Zaitsev | Oct 17, 2007 | Percona Events
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...
by Aurimas Mikalauskas | Oct 16, 2007 | Insight for Developers
The other day I had a case with an awful performance of a rather simple join. It was a join on tb1.vid = CONCAT(‘prefix-‘, tb2.id) with tb1.vid – indexed varchar(100) and tb2.id – int(11) column. No matter what I did – forced it to use...
by Peter Zaitsev | Oct 12, 2007 | Insight for DBAs
The question I often get is how far MySQL may fall behind and how to keep replication from lagging. The lag you will see will vary a lot from application to the application and from load to load. Plus what is the most important within same application the lag will...
by Vadim Tkachenko | Oct 12, 2007 | Uncategorized
We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not escalate MyISAM scalability question. This time working on...
by Peter Zaitsev | Oct 11, 2007 | Insight for DBAs
I already wrote about this issue but as I is third team I’m helping customers to resolve this “frm corruption” issue it is the time to return to it again. During MySQL 5.0 release cycle the change was made so now MySQL does not stop if Innodb storage...
by Peter Zaitsev | Oct 6, 2007 | Percona Events
Almost two weeks have passed since HighLoad 2007 conference in Moscow, Russia so I’m pretty late with feedback and my only excuse I was pretty busy to spare some time for it. Lets start with bright side. The conference had a lot of great sessions by experts in...
by Peter Zaitsev | Oct 5, 2007 | Benchmarks, Insight for Developers
When I was comparing performance of UNION vs MySQL 5.0 index merge algorithm Sinisa pointed out I should be using UNION ALL instead of simple UNION in my benchmarks, and he was right. Numbers would be different but it should not change general point of having...
by Peter Zaitsev | Oct 5, 2007 | Percona Events
About one month ago we posted a call for interns to work with us on various MySQL Performance related things. We got good number of replies and a lot of people wondered what tasks exactly we could offer as surely this sort of involvement should be fun and should teach...
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...
