Dec 09, 2007 |
Insight for DBAs
If you enable logging of all queries as “slow queries” using the patch or MySQL 5.1 you can get log file to grow huge. Same may happen with general log file. In some cases we’ve got log file sizes of 100G or more which may need to be cleaned up. Here is some danger waiting […]
Nov 29, 2007 |
Percona Events
Our company, Percona is even more Virtual than MySQL AB – we have no offices and 100% of staff members work out of their homes (or traveling, onsite with customers etc). We also probably have just couple of cities where more than one Employee lives. Working as a virtual company has a lot of benefits […]
Nov 25, 2007 |
Percona Events
I have now posted slides for the talk I gave in Zurich last week in MySQL Performance Presentations section. That was fun talk and fun trip in general. Thank you for inviting.
Nov 18, 2007 |
Percona Events
I’m visiting customer in Zurich next week and also was invited to give a talk on MySQL Performance Wednesday November 21. If you’re in the area please feel free to drop by I’ll start by talking about Query Optimization and we’ll keep it interactive to see what else audience would like to know.
Nov 18, 2007 |
Insight for Developers
I was thinking today of how people tend to use MySQL in modern applications and it stroke me in many cases MySQL is not used to process the data, at least not on the large scale – instead it is used for data storage and light duty data retrieval. Even in this case however the […]
Nov 13, 2007 |
Insight for DBAs
People are sometimes contacting me and asking about bugs like this which provide a trivial way to crash MySQL to the user with basic privileges and asking me what to do. My answer to them is – there is nothing new to it and they just sit should back and relax 🙂 Really – there are […]
Nov 12, 2007 |
Insight for DBAs
At Percona we are pleased to announce couple of services which should be helpful to MySQL Community and which are not offered by MySQL, Oracle and other companies I know about. First we now do Data Recovery for MySQL. We’re mainly focused on Innodb with this one because it has distinct page structure which allows […]
Nov 12, 2007 |
Percona Events
Baron have been updating you a lot about chapter by chapter progress so I should not repeat it, instead I thought it would be a good idea to write a bit about how we work on the book. Generally, quite similar to the previous book this is long process, which is probably what happens when […]
Nov 07, 2007 |
Insight for DBAs
To get this straight – I’m not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right with filtering can get quite bumpy road. In some applications however it is very helpful so lets see what one should do […]
Nov 04, 2007 |
Insight for Developers
I now got answers to the second portions of the questions you asked Heikki. If you have not seen the first part it can be found here. Same as during last time I will provide my comments for some of the answers under PZ and will use HT for original Heikkis answer. Q26: You also […]
Nov 01, 2007 |
Insight for Developers
Look at this post recently published on TechCrunch – It is ugly standard 404 error message, but what is interesting is the server line which shows nginx 0.5.32 I have checked and indeed images served from assets.hulu.com have nginx server in response header. This would be the first site of this (planned) scale to run […]
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 Analysis of MySQL powered Web Applications In this session we’ll go beyond […]
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 follow up questions […]
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 there is significant legal differences – first one would be […]
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 last time. […]
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 presentations if they are so […]
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 Registered over this time, which I consider decent number […]
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 bugs database as they are now so […]
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 MySQL is rather broad – we can prepare […]
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 it was running well and because we […]